April 5, 2004 at 2:35 pm
I have a backup of a database.I have created this in a new server.I have moved the logins using sp_help_revlogin. My problem is , the users for this database are not appearing in the new server. I am lookign at the EM and I can see all the logins but no users for the database. Could anybody help me please?
April 5, 2004 at 2:46 pm
If the login already exist on the new server, you could do:
EXEC sp_change_users_login 'Update_One', 'Mary', 'NewMary'
at the current database, and your user will start appearing one by one.
mom
April 5, 2004 at 3:06 pm
Hi,
When I did the sp_change_users_login it gave me this error message
Server: Msg 15291, Level 16, State 1, Procedure sp_change_users_login, Line 87
Terminating this procedure. The User name 'sree' is absent or invalid.
I just found out that all the users went to my master database. where did I go wrong?
April 5, 2004 at 3:25 pm
I think I found out the answer myself. I had created generate sql server users and role permissions by generating the s
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply