Getting 'access to path is denied' error every first time of executing a query
-
In SQL Server Management Studio I'm always getting a "Cannot execute script. Access to path is denied" error when executing a query. The second time i press execute it runs fine. The access denied path is f.i. C:\Documents and Setting\'User'\Local settings\Temp\13\tmp8A.tmp.
All users are getting this error, not just my userprofile.
Any suggestions?
-
Change to another folder, not the temp one.
It worked for me before.
-
I've now changed it to C:\Temp in the Environment Variables, restarted SQL Server, but getting the same kind of error with now C:\Temp in the msg....
-
Although another location, F:\Tmp, seems to be working fine without the annoying error
So thanks for the advice BlueTiger!!
-
Any chance you are doing this on a cluster?
-
if it's a new disk, you might just need to add full control to everyone, or something similar. ran into this problem last time we created a new san.
-
Henry Treftz (7/26/2010)
Any chance you are doing this on a cluster?No...
-
b-singley (7/26/2010)
if it's a new disk, you might just need to add full control to everyone, or something similar. ran into this problem last time we created a new san.Full control to everyone is not always an option
But it's not a new disk, and on the F drive I'm having the same rights as on the C drive, while it works fine on the F drive.
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply