Web Scraper and Web Macros FAQs

Page History: Manual Install

Compare Page Revisions

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

Page Revision: 2007/08/10 20:06

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 Express Management Studio Express
  2. Download ProvidusDB.mdf
  3. Extract providusdb.zip to C:\Program Files\Web Scraper Plus+\Data
  4. Open SQL Server Express Management Studio Express and connect the 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.mdf. Click OK.
  7. Under the ./PROVIDUSSTD -> Security -> Login or User "sa", make the password velocityscape, Server Role sys_admin, and User Mapping of ProvidusDB to owner and public.
    • Make sure that the General setting Enforce password policy in unchecked. If you get an error about changing the password, you might delete the sa user and re-create it.
  8. Under ProvidusDB -> Security folder, change owner of schema, providus_sys to guest
  9. Delete the providus_sys user (or login) from the database level
  10. 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.

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