Post reply

Getting 'access to path is denied' error every first time of executing a query

  • July 23, 2010 at 9:21 am

    #144199

    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?

  • July 23, 2010 at 9:27 am

    #1197576

    Change to another folder, not the temp one.

    It worked for me before.

  • July 26, 2010 at 2:08 am

    #1198060

    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....

  • July 26, 2010 at 2:25 am

    #1198067

    Although another location, F:\Tmp, seems to be working fine without the annoying error 😀

    So thanks for the advice BlueTiger!!

  • July 26, 2010 at 9:58 am

    #1198275

    Any chance you are doing this on a cluster?

  • July 26, 2010 at 10:17 am

    #1198286

    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.

  • July 27, 2010 at 9:47 am

    #1198805

    Henry Treftz (7/26/2010)

    Any chance you are doing this on a cluster?

    No...

  • July 27, 2010 at 10:03 am

    #1198812

    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 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply