Web Scraper and Web Macros FAQs

Page History: Login failed to user 'providus_sys


Compare Page Revisions



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


Page Revision: 2009/06/10 17:03


  • 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
PoweredBy
Create a Page | Administration | File Management | Login/Logout | Language Selection | Your Profile |Create Account