Web Scraper and Web Macros FAQs

Page History: Manual Install

Compare Page Revisions

« Older Revision - Back to Page History - Newer Revision »

Page Revision: 2008/01/15 22:28

The following process fixes the Login failed for user 'sa' or 'providus_sys' by attaching the ProvidusDB database that has a clean Web Scraper Backend preconfigured in its tables. This is for new installations, that don't have pre-existing packages and datapages that you want to keep.

  1. Download and Install SQL Server Management Studio Express
  2. Download providusdb.zip
  3. Extract providusdb.zip to C:\Program Files\Web Scraper Plus+\Data
  4. Open SQL Server Express Management Studio Express and connect to the .\PROVIDUSSTD instance.
  5. In the Object Explorer (left pane) go into PROVIDUSSTD, right click the Databases folder and go to Attach...
  6. Click Add and Browse to C:\Program Files\Web Scraper Plus+\Data\ProvidusDB_data.mdf. Click OK.
  7. If you don't have permission to attach, try going to File -> Connect Object Explorer, and connect as user sa, with password velocityscape. If you can't login as sa, try the next step to create it and come back to this step.

If you get Login failed for user sa do the following:

  1. Under the ./PROVIDUSSTD -> Security -> Logins or Users -> "sa", make the password velocityscape, Server Role sys_admin, and User Mapping -> ProvidusDB, owner and public checked.
  2. Make sure that "Enforce password policy" is unchecked. If you get an error about changing the password, try to delete the sa user and re-create it.

If you get Login failed for user providus_sys do the following:

  1. Under ProvidusDB(not PROVIDUSSTD) -> Security folder, change owner of schema, providus_sys to guest
  2. Delete the providus_sys user (or login) from the database level
  3. Create the providus_sys user at the instance level (password machupicchu) with user mapping set to make it the owner of providusdb. Also make sure its server role is set to sysadmin.
  4. 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\Velocityscape\Providus
    3. Change IsFirstRun to 0. You are now ready to try to start Web Scraper again

Create a Page | Administration | File Management | Login/Logout | Language Selection | Your Profile |Create Account