★ EPPM Solutions ★ Technology ★ Business Analysis ★ ITIL ★ ITSM ★ PMBOK ★


(
uB )

Custom Implementation, Services, Training & Support through Experienced, Wise Use of Available Knowledge, Facilitating Access to Relevant Information, Research and Opportunities besides hands on EPMO and EPMS Projects. Ask !
Solution ID: prim82845

Bad public username or password. Database Server Error: Login failed for user ‘pubuser’. The server principal "pubuser" is not able to access the database "master" under the current security context.;
Version(s): 6.0, 6.1, 6.2, 6.2.1
Problem: Bad public username or password. Database Server Error: Login failed for user ‘pubuser’. The server principal “pubuser” is not able to access the database “master” under the current security context.;

Cause: Permissions were denied on the master database for guest login.
Fix: For the Guest account on the master database the following permissions are the minimum needed for proper connection to a Project Management database:

GRANT (checked):
  • CONNECT

  • NO CHECK MARK:
  • CONNECT REPLICATION
  • CONTROL
  • EXECUTE
  • SELECT
  • VIEW DATABASE STATE

  • DENY (checked):
  • ALL THE REST
  • 0 comments:

    Post a comment

    Thank you.