Default Database Login

Question

Hi. I have a SQL server database which prompts for credentials when users try to open it. By default 'sa' is displayed in the login screen as the default login for access. I have created another account whoch I want to be the primary account to allow access to this database. What do I have to do so that my other account 'MB_Admin' is displayed by default in the login prompt? Thanks for any help. John

Answer 1

Hi John,

When you connect it for the first time using any login successfully, SSMS remembers it and next time password for that login is prompt.

---

-Chintak

Answer 2

Moreover, if you use Windows Authentications the window login will be displayed when user tries to connect to.

---

Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

Answer 3

You can type in the specific login name and its passwords and tick the remember password checkbox so next time when you open the SSMS you can make use of the stored login properties. Also make sure the login has access to the database otherwise you will just be able to see \ access master and tempdb database.

---

Thanks, Leks