Page History: Manual Install
Compare Page Revisions
Page Revision: 2007/08/13 02:46
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.zip
- Extract providusdb.zip to C:\Program Files\Web Scraper Plus+\Data
- Open SQL Server Express Management Studio Express and connect to 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.
If you get Login failed for user sa do the following:
- Under the ./PROVIDUSSTD -> Security -> Logins or Users -> "sa", make the password velocityscape, Server Role sys_admin, and User Mapping -> ProvidusDB, owner and public checked.
- 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:
- 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.