locked
Default Database Login RRS feed

  • 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
    Monday, August 16, 2010 4:51 AM

Answers

  • 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
    Monday, August 16, 2010 5:08 AM
  • 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/
    Monday, August 16, 2010 5:38 AM
    Answerer
  • 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
    Monday, August 16, 2010 5:42 AM
    Answerer

All replies

  • 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
    Monday, August 16, 2010 5:08 AM
  • 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/
    Monday, August 16, 2010 5:38 AM
    Answerer
  • 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
    Monday, August 16, 2010 5:42 AM
    Answerer