Azure SQL Database
An Azure relational database service.
Database user password change in Azure SQL after Import bacpac
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 51%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPM%3C/text%3E%3C/svg%3E)
Prakash M, Bhanu
211
Reputation points
On Prem:\
I have a db called db1
User test is having access to db1
Now I have exported bacpac
in Azure SQL Single DB:
Import bacpac file
Able to Connect with server admin and able to see db1 in Azure.
Issue: I wanted to connect with db user called Test and it is failed with login failure. I tried to reset the password and got below error. The parameter PASSWORD cannot be provided for users that cannot authenticate in a database.
Please help me, instead of dropping this db user and recreate any other way to make the connectivity with the test user? So that existing db objects will remain same in the database.
Please suggest
Azure SQL Database
2 answers
Sort by: Most helpful
-
Deleted
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
2 deleted comments
Comments have been turned off. Learn more
-
Deleted
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
3 deleted comments
Comments have been turned off. Learn more