2 months ago
We are trying to log into the SQL server through SSMS but we are getting a password issue. The password was orignally encrypted but I wanted to set it to passwords I use for my server farm. I typed in the password, and rebuilt the image. We are getting a login failure (I copied the env file entry) and we cannot log in. why isn't the password being used from the env file?
5 Replies
2 months ago
Changing the password in the environment variables will not change the password in the server if it's been previously deployed before.
If you wish to regenerate a password, go to the Database tab in service configuration, click on Credentials, and click Regenerate Password
0x5b62656e5d
Changing the password in the environment variables will not change the password in the server if it's been previously deployed before.If you wish to regenerate a password, go to the Database tab in service configuration, click on Credentials, and click Regenerate Password
2 months ago
I do not see at database tab in service configuration. This is a MS SQL server. Does it have one? How do I get to service configuration?
2 months ago
I think you'd need to directly change the password within the container if its MS SQL then. There are plenty of documentations on how to do that online.
2 months ago
Connect to the server via SSMS using the original password and in a new query window run
ALTER LOGIN sa WITH PASSWORD = 'YourNewPasswordFromEnvFile';
GO
Disconnect and log back in with your new password.
2 months ago
i changed the env file and do not have the old password. I guess I can delete the instance and create a new instance. Since I never got to use the server, nothing lost