Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
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
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

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


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 8:41 PM
Points: 31,080, Visits: 15,525
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