64-bit Manual Install

1. Download SQL Server Express(SQLEXPR.EXE)
2. Download and Install SQL Server Management Studio Express
3. Download providusdb.zip and extract to "C:\Program Files (x86)\Web Scraper Plus+\Data" If the folder isn't there, create it.
4. Click the executable SQLEXPR.EXE
5. Uncheck hide advanced options box when you see it
6. Change instance name to PROVIDUSSTD from SQLEXPRESS
7. Choose Mixed Mode validation with sa password "velocityscape"
   1. If the password policy is violated choose a strong password that will need to set back to velocityscape later
8. Use Local System rather than Network Service for the account type
9. Open SQL Server Express Management Studio Express and connect to the Database Engine, .\PROVIDUSSTD instance, SQL Server Authentication, user: sa, password: velocityscape
10. In the Object Explorer (left pane) go into PROVIDUSSTD, right click the Databases folder and go to Attach...
11. Click Add and Browse to C:\Program Files\Web Scraper Plus+\Data\ProvidusDB_data.mdf. Click OK.
12. If you had to make a strong password earlier, go under PROVIDUSSTD -> Security -> Users or Logins -> sa, and change password to "velocityscape" and uncheck enforce password policy checkbox
13. In PROVIDUSSTD -> Databases -> ProvidusDB -> Tables -> Right-click the settings table and choose Open Table, then change any of the values in the val column that start with "C:\Program Files\" to instead start with "C:\Program Files (x86)\"
14. Once you are done setting up ProvidusDB manually (the above steps), you will need to tell Web Scraper to not attempt to do this itself the first time it starts. To do this edit the registry as follows
    1. Start regedit by typing "regedit" in the command prompt
    2. Browse to HKEY_LOCAL_MACHINE\Software\Wow6432Node\Velocityscape\Providus
    3. Change IsFirstRun to 0.
15. Download and Install SQL Server backwards compatibility for 64-bit.

• Under (YourComputerName)\PROVIDUSSTD -> Databases -> ProvidusDB -> Security folder -> Schemas, right click providus_sys and change owner Schema owner to "guest" without quotes.
• Again in (YourComputerName)\PROVIDUSSTD -> Databases -> ProvidusDB -> Security folder -> Users or Logins, right click providus_sys and choose Delete.
• Now under (YourComputerName)\PROVIDUSSTD -> Security -> Logins
  • Right click the Logins folder and select New Login...
  • Give it the name providus_sys
  • Choose SQL authentication with password machupicchu
  • Un-check Enforce password policy checkbox
  • Click Server Roles in the left pane and check sysadmin
  • Click user mapping in left pane and check ProvidusDB in the top right pane
  • Then check db_owner in the bottom pane
  • Press OK