SQL Server 2008中的连接问题 [英] Connection problem in SQL Server 2008

问题描述

我可以通过''网络将数据库连接到其他服务器，但是最近几天它无法连接.它将填充错误消息无法为此请求检索数据(Microsoft.SqlServer.Management.Sdk.Sfc.EnumeratorCore)"

以我的价格，我可以连接SQL事件探查器.谁能帮帮我.

问候，
John

I could connect the database to different server thro'' network, but last few days it fails to connect. It populates the Error message Failed to retrieve data for this request (Microsoft.SqlServer.Management.Sdk.Sfc.EnumeratorCore)

To my suprice I could connect the SQL Profiler. Can anyone help me out.

Regards,
John

推荐答案

如果您以前一直在连接，而现在突然没有连接，那么*某些东西*现在必须有所不同.

如果您尚未更改代码，则*某物*必须与网络相关.

您需要检查的一些区域是:

1.数据库用户是否获得了适当的权限?
2.网络防火墙是否阻止对适当端口的访问?
3.服务器/数据库名称是否已更改?

您可能需要对此进行更深入的研究，并发布一些有关如何连接的代码...

If you have been connecting previously, and now it suddenly isn''t connecting, *something* must now be different.

If you haven''t changed the code, then that *something* must be network related.

Some areas for you to check would be:

1. Has the database user got the appropriate permissions?
2. Is the network firewall blocking access to the appropriate ports?
3. Has the server/database name changed?

You may need to delve a little deeper into this, and post some code about how you are connecting...

这篇关于SQL Server 2008中的连接问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！