Home Forums SQL Server 2008 SQL Server 2008 Administration Windows authentication only allows login with sysadmin role RE: Windows authentication only allows login with sysadmin role
sqldriver
SSChampion
Points: 10440
More actions
April 11, 2014 at 8:46 am
#1705339
Yep, that's the story. Also, if I assign another role (so they're under public and setupadmin, or public and serveradmin), they can't log in.
The default db is master for all roles and live user logins.
Thanks