Microsoft SQL Server error – Failed to retrieve data for this request

Asked By josesharwinn 0 points N/A Posted 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)

 

Additional information:

 

An exception occurred while executing a Transact-SQL statement or batch.

 

(Mircrosoft.SqlServer.ConnectionInfo)

The server principal "saathumd_umeed" is not able to access the database "britisha_bacad"

under the current security context.  (Microsoft SQL Server, Error : 916)                                                                                                                                                                                                               

                                                                                                                                     OK

• Status: Open
• Question Views: 1769
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS SQL Server

Answered By jacks.niccoli59 0 points N/A #96567

Microsoft SQL Server error – Failed to retrieve data for this request

 

Hi Joses,

 

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,

About jacks.niccoli59

Questions
0

Answers
13

Best Answers
4

• Vote Up 0 Vote Down

• Posted on - 08/25/2011
• Question Category: MS SQL Server