How to test making a connection to your database

[support 216]

Step 1:  On your web server, open your c:\inetpub\passwordstate\web.config file.  Take note of the username and password inside the connection string:

 

 

Step 2: Open SQL Management Studio Tools, and enter your database server name, choose "SQL Server Authentication" and enter in the username and password you found in the web.config file

 

 

If you get an error, then either the passwordstate_user account does not have db_owner rights to your database, or the password is incorrect.  To fix this, connect to your database server using another account that has permissions, and confirm passwordstate_user has the correct permissions, and possibly set the password in SQL to match what is in your web.config file.