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

[Krishnaraj Barvathaya B]

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 Barvathaya B

[Wendelius]

If login to SQL Server via different Windows identified ID than rest of your team, open your login from server and from mapping delete yourself from the database "dbName" , click ok and then add yourself as a user to the database "dbName". Also remember to add relevant roles in the database. This way your user id should be reset in target database.

[Krishnaraj Barvathaya B]

I found answer for this. The reason why I was not able to access the remote data base via Windows authentication was because my user account was not been added as a local admin in the remote computer.

Krishnaraj Barvathaya B