Monday, February 4, 2013

SQL Server Management Studio forgets password

Hum » SQL Server Management Studio forgets password:


It doesn’t take too long to set up a tool to monitor a file or directory – you can download FileMon from:
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.
Agreed. :)

No comments: