• RED HOT WEB HOSTING

    Starting from £ 3.99 per month

    All our plans use WebSitePanel - the best windows control panel. Clustered Servers - separate web, mail and database servers

    ASP.Net hosting 99.9% Network Uptime
    Windows Reseller Hosting Fast Response Times
    UK Hosting WebSitePanel
    POP3 & Web Mail
    Windows Hosting Money back
Client Area
Login
Registration
Forget Password?
(44)1772368116 (UK)
Live Support

Knowledgebase

Portal Home > Knowledgebase > Windows Hosting > I get error when conneting to MS SQL 2008 server

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?

Add to Favourites Add to Favourites

Print this Article Print this Article
Also Read
Connecting to a SQL Server or MySQL Database in WebMatrix (Views: 47)
How to Take Database Offline - Take Database Online (Views: 269)
How to change asp.net version for my website? (Views: 1663)
MS SQL 2008 and MySQL server addresses (Views: 2561)
How to restore ms sql 2008 db (Views: 1090)

Powered by WHMCompleteSolution

Language:

Remember Me
support website