Knowledgebase

I get error when conneting to MS SQL 2008 server

If you get this error:

The server principal " " is not able to access the database " " under the current security context. (Microsoft SQL Server, Error: 916)

try this:

1) Bring Object Explorer Details window by selecting View --> Object Explorer Details in menu (or hitting F7)
2) In Object Explorer window click at Databases folder
3) In Object Explorer Details window right-click at the column header and deselect Collation
4) Refresh Databases folder.

Was this answer helpful?

 Print this Article

Also Read

How to send email from your asp.net code?

' Visual Basic Sample - Sending SMTP Authenticated E-mail ' Please replace yourdomain.com in...

Conection String to MS SQL 2008 DB - example

In order to connect to SQL Server 2008 from Management Studio, Enterprise Manager, Query...

MS SQL 2008 and MySQL server addresses

MSSQL 2008 server addresses are: sql2008.aspnethosting.co.uk sql2008r2.aspnethosting.co.uk...

How to enable remote IIS management for my site?

Login to your hosting control panel here http://cp.aspnethosting.co.uk then click on Web - Web...