How to transfer the existing database users to a new ms sql server?

Question

I have imported my database to a new ms sql server. This works but the logins are not working. They exists on the database itself but they are not available in the security->logins area of the ms sql server. I tried to create them manually there but receive the exception that they already exists on my database.

How can I achieve that these logins are active for my new ms sql server?

Thanks

please refer this link : step by step help support.microsoft.com/kb/918992 — Anvesh
– Anvesh, Commented May 6, 2013 at 10:33

Dave Simione · Accepted Answer · 2013-05-06 09:24:06Z

1

Add the logins to the server, but don't associate them with the database. Then, run this:

USE [your database];
GO    
ALTER USER {user} WITH LOGIN={login};

answered May 6, 2013 at 9:24

Dave Simione

1,4412 gold badges22 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Al Phaba · Accepted Answer · 2013-05-06 09:26:01Z

1

Found the solution which works for me

USE testdb;
GO
EXEC sp_change_users_login 'Auto_Fix', 'testuser', NULL, 'testpwd';
GO

answered May 6, 2013 at 9:26

Al Phaba

6,82513 gold badges58 silver badges99 bronze badges

Collectives™ on Stack Overflow

How to transfer the existing database users to a new ms sql server?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related