Windows authenticated users have lost access to master (default) database
- by Rob Nicholson
Something very strange has occurred on our production SQL database. Users connecting via Windows authentication appear to have lost all access to the master database. By default, all logins have the default database set to master. So when you connect using SQL Server management studio, they get the error:
"Cannot open user default database. Login…