SQL Server 2008 R2 连接问题
我们已经安装了 SQL Server 2008 R2 Developer 版本，出于测试目的，我们将该计算机设置为本地服务器。
当我们尝试从其他计算机 Visual studio 2010 或 SQL Server Management studio 进行连接时，它工作正常。
但一段时间后突然连接无法正常工作。 （可能是因为 6 个用户同时尝试使用 SQL Server）。根据设置，它被设置为无限制访问。
如果我们重新启动机器，它会再次正常工作几个小时，然后我们再次遇到这个问题
有人知道为什么会这样吗？
提前致谢
We have Installed SQL Server 2008 R2 Developer edition, for testing purpose we have put that machine as Local server.
When we try to connect from other machines Visual studio 2010 or from SQL Server Management studio, it works fine.
But after some time suddenly the connection is not working. (might be because of 6 users are trying to use the sql server at the same time). As per setting it is set as unlimited access.
If we restart the machine it works fine again for some hours then again we face this problem
Anyone have any idea why it is happening this way?
Thanks in advance
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
您需要确保在打开连接时关闭它们。如果您打开与数据库的连接并且从不关闭它们 - 最终您将耗尽它们并且服务器将不得不重新启动。确定哪些内容未释放连接或哪些内容未使用连接池。
You need to be sure you close your connections when you open them. If you open connections to the database and never close them - eventually you'll run out of them and the server will have to be restarted. Determine what is not disposing the connections or what isn't using connection pooling.