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

  • 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.

    .