Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

I synchronized users in two databases, but the added users cannot use their old passwords to access the modified database. Why?

April 26, 2017added database databases modified passwords synchronized Users

0

Posted

I synchronized users in two databases, but the added users cannot use their old passwords to access the modified database. Why?

1 Answer

0

Posted

Users’ passwords are confidential information and SQL Server does not allow the program to get them and move them between databases. In the process of synchronizing users who use SQL Server Authentication, you will see a warning at the Warnings step of the synchronization wizard that it is impossible to move passwords and you will have to specify them manually. Otherwise an empty string will be used as a password. Or you can save the synchronization script and enter passwords for all users manually before executing it in Query Analyzer.