Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

How to create SysAdmin Login and Associate SysAdmin User with it in a database Expand / Collapse
Posted Wednesday, December 26, 2007 5:58 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, December 26, 2007 5:51 AM
Points: 1, Visits: 3
Hello Everybody,

I received a SQL Server 2005 database backup (say Sales database) and after restoring it I found that it has "sys" and "sysadmin" as database users defined in it.

Sysadmin Case:

Now, that Application I received tries to connect to Sales database using "sysadmin" and it fails.

I tried to create a Login with the same name, it failed by saying "Server-principal 'sysadmin' already exists", so joining User and Login didn't happen.

Sys Case:

I expanded the database tree and opened the properties of "sys" user it doesn't show me its link with sys login though sys login exists in my SQL server.

I will appreciate your assistance to resolve this issue at the earliest.
Post #436320
Posted Wednesday, December 26, 2007 6:13 AM


Group: General Forum Members
Last Login: Tuesday, December 24, 2013 4:42 AM
Points: 460, Visits: 2,523
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.

Post #436323
Posted Wednesday, December 26, 2007 9:52 AM



Group: Administrators
Last Login: Today @ 7:43 AM
Points: 34,363, Visits: 18,584
Look up sp_change_users_login as well. you might need to relink the login and user.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #436393
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse