May 28, 2009 at 11:04 pm
hi every one
i had taken backup and restored the database from one server to other sqlserver 2005. i have the windows authentication users exists in the restored database. now i want to give access to those users on new server.i tried to create a user on server using windows authentication.but i says user already exists. when i tried to connect through the database user its not working .
can any one help me on how to give access to the database users on server.
thanks and regards
ROCK.....
May 29, 2009 at 2:03 am
After restoring any DB to another server.. we need to fix the Orphan users.. means the users which are existing in the source server ...
u can use 'sp_change_users_login' with 'auto-fix' option to fix the users at destination server....
May 29, 2009 at 2:41 am
the sp_change_users_login will only work for SQL logins and users.
If the problem is Windows users, simply try creating the windows login on the server without giving db access, ie without creating a user in the db...the windows login and user in the db should sync automatically becuase they will already have matching SID's
Gethyn Elliswww.gethynellis.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply