locked
How can one use SQL authentication when only Windows auth is selected? RRS feed

Answers

  • Hi ,

    You can create a new SQL authenticated login and the existing SQL logins will be retained in the server logins column irrespective of the authentication set for SQL server . The picture that you have shows us is just the login details.

    You cannot connect with SQL login if only windows authentication is configured and by doing that you will be prompted with error 18456 , state 58.

    Thanks, Leks
    • Marked as answer by Tom Li - MSFT Thursday, March 11, 2010 3:23 AM
    Tuesday, March 2, 2010 6:44 PM

All replies

  • Hi ,

    You can create a new SQL authenticated login and the existing SQL logins will be retained in the server logins column irrespective of the authentication set for SQL server . The picture that you have shows us is just the login details.

    You cannot connect with SQL login if only windows authentication is configured and by doing that you will be prompted with error 18456 , state 58.

    Thanks, Leks
    • Marked as answer by Tom Li - MSFT Thursday, March 11, 2010 3:23 AM
    Tuesday, March 2, 2010 6:44 PM
  • You cannot connect with SQL login if only windows authentication is configured...

    But once you connect with a valid Windows account, could these accounts (those mentioned above) be used to regulate access inside a particular database?

    Using the 3rd party vendor software, it is easy to see that the user must have the right Windows credentials: if not, the database is simply not  accessible for them.

    However, once the logon screen of the 3rd party program appears, it is at that point that the user can utilize one of those logins to enter the program.

    Does that make sense?

    It works. I'm just trying to dissect it so I understand why.

    Tuesday, March 2, 2010 8:31 PM
  • I can think of one more possibility for this strange behaviour.

    Change in SQL Authentication mode requires restart on SQL Service. So may be your SQL Server is not restarted after changing to windows authentication mode.

    You can confirm this by recycling SQL Server service and then try to connect using SQL Logins.
    Thanks!
    Friday, March 5, 2010 3:22 PM
  • Thank you for your suggestion.

    However, the server has been restarted many times over the last 5 years (since initial configuration of authentication options).
    Friday, March 5, 2010 4:02 PM