Jump to content

Search the Community

Showing results for tags 'sql'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • Essentials
    • Announcements
  • Passwordstate 8.x
    • General Support
    • Feature Requests
    • Feature Requests - Completed
    • Known Issues
    • Installing Passwordstate
  • Knowledge Base
    • General FAQs
    • Password Resets
    • Remote Session Launcher
    • Mobile Client
    • Passwordstate API
    • Browser Extensions
    • Password Reset Portal
  • Passwordstate 7.x
    • General Support
    • Known Issues

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


AIM


MSN


Website URL


ICQ


Yahoo


Jabber


Skype


Google Plus Account


Location


Interests


Biography


Location


Interests


Occupation

Found 4 results

  1. 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
  2. Here at Click Studios we frequently do testing of certain features, and we use a handy script to quickly restore your database. We thought we'd share this script with our community which can help speed up testing. An example when we use this script is we are writing an API script to import bulk passwords into the system, but we did something wrong in our script and it imported a whole bunch of incorrect data for what ever reason. We then decide to roll back the database to the state it was in just prior to running the script, and then test our API script again until we get it right. Running the script below only takes a few seconds and although there are other ways to do this, we find this is the quickest way. How to Use? Run the following SQL scripts with SQL Management Studio Tools, when connected to your database server. SQL Script 1 - Backup your database as a once off process just prior to performing your testing ------------------------------------------------------------------------------------------------------------------------------------- -- Database Backup ------------------------------------------------------------------------------------------------------------------------------------- USE passwordstate DECLARE @BackupSQLScript nvarchar(max) DECLARE @DatabaseName sysname DECLARE @SQLBackupFileName nvarchar(400) DECLARE @SQLBackupFolder nvarchar(400) SET @DatabaseName = db_name() --DB name is current DB of user (better than hard coding in case you change DB name in future versions) SET @SQLBackupFileName = 'passwordstate\' + @DatabaseName + '.bak' SET @BackupSQLScript = ' BACKUP DATABASE [' + @DatabaseName + '] TO DISK = ''' + @SQLBackupFileName + ''' WITH FORMAT' EXEC sp_executesql @BackupSQLScript SQL Script 2 - Run this script to revert your database to the state your database was in just before you started testing, ie roll back to the backup performed in SQL Script 1, above. Repeat this as necessary USE passwordstate DECLARE @BackupSQLScript nvarchar(max) DECLARE @DatabaseName sysname DECLARE @SQLBackupFileName nvarchar(400) DECLARE @SQLBackupFolder nvarchar(400) SET @DatabaseName = db_name() --DB name is current DB of user (better than hard coding in case you change DB name in future versions) SET @SQLBackupFileName = 'passwordstate\' + @DatabaseName + '.bak' SET @BackupSQLScript = ' BACKUP DATABASE [' + @DatabaseName + '] TO DISK = ''' + @SQLBackupFileName + ''' WITH FORMAT' ------------------------------------------------------------------------------------------------------------------------------------- -- Take the Database Offline ------------------------------------------------------------------------------------------------------------------------------------- -- Step 1: Retrive the Logical file name of the database from backup ALTER DATABASE [passwordstate] SET OFFLINE WITH ROLLBACK IMMEDIATE ------------------------------------------------------------------------------------------------------------------------------------- -- Restore Database ------------------------------------------------------------------------------------------------------------------------------------- RESTORE DATABASE passwordstate FROM DISK = @SQLBackupFileName WITH NOUNLOAD, REPLACE, STATS = 5 We hope this helps:) Support
  3. 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.
  4. 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.
×