Suddenly i cannot open my database with error like this:
" The server principal [db_user_name] is not able to access the database "index" under the current security context. (Microsoft SQL Server, Error: 916) "
After a short searching & browsing on the net, i found something that help solved the problem (thanks to my.re-invent.com for their knowledgebased).
The cause of this error is because we try to access database that we do not own. This is caused by SQL 2008 Management Studio attempting to query certain system settings that we do not have access to.
Solving problem steps are:
1. Open SQL Management Studio 2008 on your local Computer
2. In the Object Explorer, click "Databases"
3. On Menu, select View | Object Explorer Details
4. Right click on the column headers
5. uncheck the following items:
-Size (MB)
-Database Space Used (KB)
-Index Space Used (KB)
-Space Available (KB)
-Default File Group
-Mail Host
-Collation
6. Right click on databases and select refreshThat will fix the problem.
No comments:
Post a Comment