Jump to content

How to test making a connection to your database


Recommended Posts

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:

 

2016-08-23_8-48-30.png

 

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

 

2016-08-23_8-50-19.png

 

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.

 

 

 

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...