Page History: Manual Install

Compare Page Revisions

33 32 31 30 29 28 27 26 25 24 23 22 21 20 19 18 17 16 15 14 13 12 11 10 9 8 7 6 5 4 3 2 1 0 Current 33 32 31 30 29 28 27 26 25 24 23 22 21 20 19 18 17 16 15 14 13 12 11 10 9 8 7 6 5 4 3 2 1 0

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

Page Revision: 2007/08/10 19:54

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.

• Download and Install SQL Server Express Management Studio Express
• Download ProvidusDB.mdf
• Extract providusdb.zip to C:\Program Files\Web Scraper Plus+\Data
• Open SQL Server Express Management Studio Express and connect the the .\PROVIDUSSTD instance.
• In the Object Explorer (left pane) go into PROVIDUSSTD, right click the Databases folder and go to Attach...
• Click Add and Browse to C:\Program Files\Web Scraper Plus+\Data\ProvidusDB.mdf. Click OK.
• Under ProvidusDB -> Security folder, change owner of schema, providus_sys to guest
• Delete the providus_sys user (or login) from the database level
• 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.