Geek Answers Handbook

Change the default name of SQL Server Management Studio (SSMS)

Some time ago, I created a new login on my local SQL Server 2008 Express database server called "sa_readonly". Now every time I run SQL Server Management Studio, it displays the "Connect to Server" form, with the default input set to "sa_readonly". This login no longer exists, and I want to change the default account to "sa". How to do it?

+5
source share
1 answer

From Deleting a List of Registered Users and Passwords in SQL Server Management Studio :

You can delete all saved links by deleting or renaming the file.

SQL Server Management Studio 2008 C:\Users\%username%\AppData\Roaming\Microsoft\Microsoft SQL Server\100\Tools\Shell\SqlStudio.bin

SQL Server Management Studio 2005 - , , Vista. C:\Users\%username%\AppData\Roaming\Microsoft\Microsoft SQL Server\90\Tools\Shell\mru.dat

Vista/Win7

+4

More articles:


All Articles