Search the Community
Showing results for tags 'sql'.
Found 3 results
Step 1: Ensure you have prerequisites set up for your web server and hosts, as per this forum post (Once off process) Step 2: Add new Password Record configured as follows: Screen 1: Ensure you configure the below 5 options correctly and enter in the password for the account. If you configure an Expiry Date it will automatically change the password when that date is reached. Screen 2: Ensure you select the correct Privileged Account and the Reset SQL Password reset script. Also confirm the Password Reset Schedule is enabled if you want the password to automatically change when the Expiry Date occurs Screen 3: Confirm the Validate Password for SQL Account validation script is selected
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.
I'm running v7.5 (Build 7539). I'm trying to setup a new HA subscriber to my installation. After the subscriber has been successfully created, when I view the synchronization status, I see the message "The process could not connect to Subscriber." With this being the case, the DB is never replicated to the subscriber. I have allowed UDP ports 1433 & 1434 and sqlbrowser.exe through the subscriber's Windows firewall. I'll be glad to provide any needed additional information.