Home Forums SQL Server 2005 SQL Server 2005 Security How to create SysAdmin Login and Associate SysAdmin User with it in a database RE: How to create SysAdmin Login and Associate SysAdmin User with it in a database
jacob sebastian
SSChampion
Points: 11822
More actions
December 26, 2007 at 6:13 am
#762662
Try the following:
go to the properties of the 'sysadmin' login and make sure that it has permissions to access your new database. I guess it mightnot have permissions. grant permissions and it might help.
.