Jump to content

Test SQL Credentials are still valid


Recommended Posts

Issue:

You have an issue with your website loading, and one test you need to do is confirm the SQL credentials your website is using are still valid.

 

Instructions:

 

Step 1:

Log in to your Passwordstate webserver, and open the c:\inetpub\passwordstate\web.config file.  At the top of the file you will see a connection string as per below screenshot. 

 

1.png

 

If you cannot see this connection string, this means you have encrypted your web.config file, and you will need to decrypt to reveal the connection string in clear text. You can do this by following this guide: https://forums.clickstudios.com.au/topic/2699-encrypting-and-decrypting-the-webconfig-file/

 

 

Step 2:

In the connection string, take note of the server name, username and password as this example screenshot below shows:

 

2022-07-27_8-01-26.png

Step 3:

Open SQL Management Studio Tools, and connect to the appropriate Server name, with the user name and password you found in the step above.

 

2022-07-27_8-02-32.png

 

Results:

If you cannot establish a connection, then you will need to log in with a SQL account that has permissions to reset the password for the account you found in Step 2 above.  You should then update this password in your web.config file, and then try logging back in to Passwordstate.

 

Unfortunately Click Studios cannot help reset the SQL password, and you will need to liaise with you Database Administrator to perform this action.  If you do not have a Database Administrator, you will need to log in with the inbuilt SA (SuperAdministrator) account.  

 

If you do not know the SA password to log in with, please Google "How to reset SQL SA password"

 

Regards,

Click Studios

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...