Link to home
Start Free TrialLog in
Avatar of Dale Fye
Dale FyeFlag for United States of America

asked on

Copy user permissions from database to named instance

A client recently created a new named instance on his SQL Server and migrated a database from another server to that new named instance.  When he did so, users were carried over from the old server/database to the new database when that database was restored, but the instance level logins were not copied over, and when he tries to create the user in the named instance, he gets a message indicating that the user already exists.

Does he need to remove each of the database users and add them at the instance level, and then assign them to the database?  or is there a way to script those users from original SQL Server database and create them in the named instance?User generated image
ASKER CERTIFIED SOLUTION
Avatar of Scott Pletcher
Scott Pletcher
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Dale Fye

ASKER

Client has not had a chance to attempt this yet. Will get back to this next week.
thanks for your help, guys.