Cannot open or save a file in SSMS 2008 with new windows 7 box

  • My company just upgraded to windows 7 from windows XP. Now when I open a session with SSMS and try to open a file using "File+open" I get an error message stating: "The operation could not be completed. Access is denied" before I get the chance to select a file. If I go to the location and double click on a *.sql file, it will open in SSMS, but then I can't save it. I found the registry settings for the default folder location and tried changing them, but as soon as I open SSMS the changes are overwritten. Does anyone have any ideas on how to fix this?

  • Are you editing the registry while SSMS is still open? i think it saves it's settings on exit, so you might be deleting the key, and closing SSMS re-writes the keys again;

    also, make sure you are editng the registry as administrator;

    Windows7 has a nasty habit of letting you think you are editing a key, say in HKLocalMachine, but it's really putting the changes somewhere else.

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • No, SSMS is closed when I'm editing the registry, I wasn't specifically running regedit in administrator mode, but even when I did, my changes were overwritten.

  • michael.packard (3/16/2012)


    No, SSMS is closed when I'm editing the registry, I wasn't specifically running regedit in administrator mode, but even when I did, my changes were overwritten.

    darn, sorry Michael, that was my first guess. let me see how my Google-Fu is today, might find something...

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 4 posts - 1 through 3 (of 3 total)

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