The server principal "username" is not able to access the database

• krishnaraj.knowledge

  SSC Enthusiast

  Points: 103

  More actions

  September 2, 2008 at 4:45 am

  #192986

  Hi All,

  I have one strange problem working with my sql server express edition. I have MS SQL Server Express Edition 2005 installed in my computer. When I try to connect to a remote database via Windows authentication I am able to connect to that server successfully. When I try to access the user created database I get an error message –

  “The server principal "username" is not able to access the database "dbName" under the current security context”.

  But I am successfully able to access all system databases such as master. Also the icon just at the bottom corner of the database server name also does not turn green even after connecting. One more interesting thing is, this problem is happening only to my user id. Rests all in my team are able to access the database using windows authentication with their login id.

  I don’t find any problem in working with local database.

  Thanks in advance,

  Krishnaraj

• MarkusB

  SSC-Dedicated

  Points: 37370

  More actions

  September 2, 2008 at 8:33 am

  #866018

  My guess would be that your colleagues are member of a Windows group which has access rights to the user databases and you're not.

  The reason why you can access system databases is because for the system databases the guest user is enabled.

  [font="Verdana"]Markus Bohse[/font]