Hum

This is why people bag on Microsoft.

SQL Server Management Studio 2005 forgets password

As does the 2008 version. I ran into this issue, and was (not) surprised to find the bug dating back to version 2005 and still not be fixed.  Hey, at least you can delete some files to fix it though.

On another note, it’s not often you see a woman write something like the following (what can I say, there’s not that many women in my field):

It doesn’t take too long to set up a tool to monitor a file or directory – you can download FileMon from:

http://www.microsoft.com/technet/sysinternals/FileAndDisk/Filemon.mspx

The Connect to Server dialog can pop up in different situations where there is no security context for the connection to use. If you use registered servers (and save the password there) when you view the registered servers, select a server in the Registered Servers task pane and then click New Query on the toolbar or Right Click, Connect, Object Explorer or New Query which will result in connecting under the security context you used when registering the server. If a server isn’t selected, there is no security context available so the Connect to Server dialog pops up. I haven’t heard of passwords  being “lost” or “forgotten” using the registered servers task pane and saving registration information there.

Good info.

Tags: 2005, 2008, Microsoft, Sql, SQL Server Management Studio, SSMS

This entry was posted by admin on Monday, January 18th, 2010 at 12:18 pm and is filed under Software, Technology. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.