how to move permissions from sql 2014 to sql 2016 to a new server

I have two sql servers, old is v14, and my new server is running v16.  I've already moved all the databases over, but now the problem is, the useraccounts do not have the permissions from the old server.  Is there a free tool to copy all the permissions/rights from the old server to the new?

Thanks.
DanNetwork EngineerAsked:
Who is Participating?
 
Mark WillsConnect With a Mentor Topic AdvisorCommented:
There is a "How To" at Microsoft https://support.microsoft.com/en-au/help/918992/how-to-transfer-logins-and-passwords-between-instances-of-sql-server

Might need to start checking sys.database_permissions et all and check manually if partially done.
0
 
DanNetwork EngineerAuthor Commented:
Looks like not all the users have been moved over for each database.  I had someone do that, is since it hasn't been done, is there a way to copy the users for each specific database from the old server to the new server.
0
 
DanNetwork EngineerAuthor Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.