Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Connect To Server Dialog showing logins that no longer exist Expand / Collapse
Author
Message
Posted Tuesday, November 20, 2012 2:40 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, February 27, 2014 4:38 AM
Points: 27, Visits: 185
Hello,

When connecting to a SQL2005 instance using 2008R2 Studio, any 'Connect to Server' dialog boxes include a deleted login in the drop-down list. When clicking out of the Server Name this loginis automatically selected, hence i have to change it every time.
Connecting to the same instance with 2005 Studio does not include the user and i cannot see where it is picking up the login from.
Tried recreating the login and deleting again, no joy.

Any ideas?

Post #1386754
Posted Tuesday, November 20, 2012 2:46 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 7:58 AM
Points: 5,133, Visits: 4,927
I am guessing the login once existed and you set it to remember the username and password? If so you need to remove the following file and then restart SSMS and it should have got rid of the username.

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




Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1386757
Posted Tuesday, November 20, 2012 2:57 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, February 27, 2014 4:38 AM
Points: 27, Visits: 185
That's sorted it!

Thanks for the prompt reply Anthony
Post #1386763
Posted Tuesday, November 20, 2012 3:01 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 7:58 AM
Points: 5,133, Visits: 4,927
Not a problem, happy to help.



Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1386772
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse