N/APosted on - 08/23/2011
Microsoft SQL Server error appears again and again. I don’t know how to remove this error. Please give me its solution and also the reason why this error appears, so that next time I can be careful.
Microsoft SQL Server Management Studio
Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)
An exception occurred while executing a Transact-SQL statement or batch.
The server principal "saathumd_umeed" is not able to access the database "britisha_bacad"
under the current security context. (Microsoft SQL Server, Error : 916)
Microsoft SQL Server error – Failed to retrieve data for this request
Your problem was a little bit hard. I try research in your problem. And I found some of the tips you can resolve you problem. First go to the object explorer then click the database. Second display the object explorer details or just pressing the F7 or view the object explorer details.
Third right click the column headers and de-select collation in that system. After that you now refresh all the database in your system. If the error came up again contact your administrative support for further information in your issue. But I hope that it will solve your problem. Thanks,