SQL Server Express Edition没有作为服务器响应 [英] SQL server express edition is not responding as a Server

问题描述

我已经制作了 SQL Server速成版 [

I have made SQL server express edition[] as a server and then want to access the database from another machine which is on the same network.
But getting this following error.

报价:

超时已过期.在操作完成之前经过了超时时间，或者服务器没有响应.

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

推荐答案

此错误消息是由于服务器上的远程连接设置引起的查询超时.默认值为 600秒，或 10分钟.

This error message is due to the server setting of Remote Connection Query Timeout. The default is 600 seconds, or 10 minutes.

EXEC SP_CONFIGURE 'remote query timeout', 1800
reconfigure
EXEC sp_configure
 
EXEC SP_CONFIGURE 'show advanced options', 1
reconfigure
EXEC sp_configure
 
EXEC SP_CONFIGURE 'remote query timeout', 1800
reconfigure
EXEC sp_configure

进行此更改后，请确保关闭窗口并创建新的连接，以继承新的查询超时设置.

问候，
Eduard

After making this change, make sure to close the window and create a new connection in order to inherit the new query timeout settings.

Regards,
Eduard

您必须在SQL Express中启用远程连接，因为默认情况下它已禁用.

参见此处: http://blogs.msdn.com/b/sqlexpress/archive /2005/05/05/415084.aspx [ http://blogs.msdn.com/b/sqlexpress/archive/2004/07/23/192044.aspx [ ^ ]

> http://stackoverflow.com/questions/2486610/how-从另一台计算机连接到sql-server-服务器 [

You have to enable remote connections in SQL Express as it is disabled by default.

See here : http://blogs.msdn.com/b/sqlexpress/archive/2005/05/05/415084.aspx[^]

http://blogs.msdn.com/b/sqlexpress/archive/2004/07/23/192044.aspx[^]

http://stackoverflow.com/questions/2486610/how-to-connect-to-sql-server-from-another-computer[^]

配置TCP/IP端口.
启用它并设置端口号1433

Configure TCP/IP port.
enable it and set the port no 1433

这篇关于SQL Server Express Edition没有作为服务器响应的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！