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

Question

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

michael.packard

SSC Eights!

Points: 802
More actions
March 16, 2012 at 11:56 am

#258684

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?

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

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

Lowell SSC Guru Points: 323518 More actions · Answer 1

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!

michael.packard SSC Eights! Points: 802 More actions · Answer 2

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.

Lowell SSC Guru Points: 323518 More actions · Answer 3

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!