使用 SSMS 连接到 MS SQL Server 数据库时出现问题
我有一个与Godaddy（使用SQL Server 2005）在线的数据库。他们提供基本的管理工具，但告诉您，对于更高级的工具，您可以直接使用 SSMS 连接。我按照他们的指示进行操作，以确保我的在线数据库能够接受远程连接，并且显然可以使用 SSMS 成功登录（在提供我的主机名和访问数据之后）。
但是：现在在 SSMS 中，当尝试展开“数据库”文件夹树时，我收到以下错误：
Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server& LinkId=20476
附加信息：
执行 Transact-SQL 语句或批处理时发生异常。 (Microsoft.SqlServer.ConnectionInfo)
服务器主体“cmitchell”无法在当前安全上下文下访问数据库“3pointdb”。 （Microsoft SQL Server，错误：916）
I have a database on line with Godaddy (who uses SQL Server 2005). They provide basic management tools, but tell you that for more advanced tools you can connect directly using SSMS. I followed their instructions to ensure my online database will accept remote connections, and can apparently log in using SSMS with success (after giving my hostname and access data).
However: Now from in SSMS, when attempting to expand the "Databases" folder tree, I get the following error:
Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server& LinkId=20476
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
The server principal "cmitchell" is not able to access the database "3pointdb" under the current security context. (Microsoft SQL Server, Error: 916)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.4262&EvtSrc=MSSQLServer&EvtID=916&LinkId=20476
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
我也遇到了同样的问题，但最终解决了问题。
http://clayburt.com/2009/12/28/godaddy-windows-hosting-ms-sql-2005-database-with-sql-management-studio-ssms-2008/
阅读说明小心地
我确实知道为什么会发生这种情况，但它恰好为我解决了问题。希望有帮助！
I been having the same problem but finally fix the issue.
http://clayburt.com/2009/12/28/godaddy-windows-hosting-ms-sql-2005-database-with-sql-management-studio-ssms-2008/
Read the direction carefully
I do know why this happen but it happen to fix the problem for me. Hope that helps!
您似乎没有查看该数据库的权限。我建议 GODaddy 技术支持是解决该问题的地方。
You don't appear to have permissions to view that database. I would suggest GODaddy tech support would be the place to resolve the issue.