StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POCan't open script file in SQL Server 2008 R2 job
text
Body
copied!<p>When I try to open a SQL script file on my local machine from the SQL Server Job configuration window, I get the following error:</p> <blockquote> <p>Access to the path 'C:\temp\tbl_MiscInfo.sql' is denied. (mscorlib)</p> <p>Program Location:</p> <p>at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy) at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share) at System.IO.File.Open(String path, FileMode mode) at Microsoft.SqlServer.Management.SqlManagerUI.TSQLJobSubSystemDefinition.openFile_Click(Object sender, EventArgs e) at System.Windows.Forms.Control.OnClick(EventArgs e) at System.Windows.Forms.Button.OnClick(EventArgs e) at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent) at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.ButtonBase.WndProc(Message& m) at System.Windows.Forms.Button.WndProc(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)</p> </blockquote> <p>To be clear, here is a screen shot of the action I'm trying to perform:</p> <p><img src="https://i.stack.imgur.com/eSFDC.png" alt="enter image description here"></p> <p>This seems to be a permissions issue, but nothing I try seems to work.</p> <p>The sqlagent on my machine is using a user that has admin privileges, I've given the login for the job a user credential that has admin privileges, and I've set the "run as user" option to a user mapped to the login with admin privileges.</p> <p>Any suggestions?</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload