Page History: Login failed to user 'providus_sys

Compare Page Revisions

1 0 Current 1 0

« Older Revision - Back to Page History - Current Revision

Page Revision: 2009/06/16 17:39

• 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