locked
Database Name Change Broke Windows Authentication RRS feed

  • Question

  • I have an SQL Server 2008 named DBESC with a database named DBESC that is configured to use windows authentication on a domain named DBESC.

    I have renamed the database to ESC and now I am now longer able to log in with any windows authenticated users.  SQL users ('sa', etc.) are still able to log in, but the windows users are not able to log in to the server.  And not only can they not log in to the renamed database, but they can't connect to the master or any other database on the server.

    Changing the database name back to DBESC restores windows authentication.

    I did not realize that a database name would be tied to server-wide authentication.  Is there a configuration setting that I'm unaware of?  What is happening here?

    Thanks in advance for any ideas!
    bb

    Thursday, August 23, 2012 1:30 PM

Answers

  • what are the logins default databases set as?


    Thanks, Andrew

    • Marked as answer by b3nbr0wn Thursday, August 23, 2012 2:10 PM
    Thursday, August 23, 2012 1:34 PM

All replies

  • what are the logins default databases set as?


    Thanks, Andrew

    • Marked as answer by b3nbr0wn Thursday, August 23, 2012 2:10 PM
    Thursday, August 23, 2012 1:34 PM
  • They are set to the original name, DBESC  ;)

    Excellent!  It did not occur to me to change the default database of each login.  Seems obvious now.

    Thanks a tonne Andrew!

    Thursday, August 23, 2012 2:10 PM