Configure SQLExpress to accept remote connections
来源:互联网 发布:淘宝可以办假的身份证 编辑:程序博客网 时间:2024/04/30 08:51
在使用SQL Server Express的时候经常会碰到如下告警:
TITLE: Connect to Server
------------------------------
Cannot connect to ..
------------------------------
ADDITIONAL INFORMATION:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=2&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
在这种情况下,可以按以下步骤尝试:
1. [可选] SQL Server Management Studio Express
为了使用方便,可以先到 http://go.microsoft.com/fwlink/?LinkId=65110 去下载一个类似SQL2000的企业管理器的工具(SQL Server Management Studio Express)。
2. 允许TCP/IP
在SQL Server Configuration Manager中将Protocols for SQLExpress->TCP/IP设为Enabled。
3. [可选] IP Dynamic Ports
在SQL Server Configuration Manager中SQL Server Browser服务设为Enabled。同时,为了减少SQLExpress被攻击表面,可将Protocols for SQLExpress->TCP/IP Properties 中的IP Dynamic Ports清空,并设置TCP Port为1433(推荐,如果没有SQLServer9.0以下版本;或其它)。
3. [可选] 防火墙
如果在完成1-2-3 步骤后仍不能解决问题,可以检查一下防火墙设置,这里就不再多说了。
TITLE: Connect to Server
------------------------------
Cannot connect to ..
------------------------------
ADDITIONAL INFORMATION:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=2&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
在这种情况下,可以按以下步骤尝试:
1. [可选] SQL Server Management Studio Express
为了使用方便,可以先到 http://go.microsoft.com/fwlink/?LinkId=65110 去下载一个类似SQL2000的企业管理器的工具(SQL Server Management Studio Express)。
2. 允许TCP/IP
在SQL Server Configuration Manager中将Protocols for SQLExpress->TCP/IP设为Enabled。
3. [可选] IP Dynamic Ports
在SQL Server Configuration Manager中SQL Server Browser服务设为Enabled。同时,为了减少SQLExpress被攻击表面,可将Protocols for SQLExpress->TCP/IP Properties 中的IP Dynamic Ports清空,并设置TCP Port为1433(推荐,如果没有SQLServer9.0以下版本;或其它)。
3. [可选] 防火墙
如果在完成1-2-3 步骤后仍不能解决问题,可以检查一下防火墙设置,这里就不再多说了。
- Configure SQLExpress to accept remote connections
- How to: Configure Express to accept remote connections
- How to: Configure Express to accept remote connections zz
- Allowing MySQL on Amazon’s EC2 to accept remote connections
- How to configure SQL Server 2005 to allow remote connections
- How to configure SQL Server 2005 to allow remote connections
- Configure SQL Server 2005 to allow remote connections
- How to enable remote connections in SQL Server 2008?
- Remote Configure
- How to configure Tomcat to support remote debugging
- adb for remote connections
- How To Configure Client Failover For Dataguard Connections Using Database Services (Doc ID 1429223.1
- Jboss Remote Debug Configure
- How to configure ODBC DSN in Client to access remote DB2 for Windows
- how to install and configure Remote BLOB Storage (RBS) in a SharePoint 2013 farm
- Reuse the remote connections in Ubuntu14.04
- Top 6 Free Remote Desktop Connections Manager
- Top 3 Free Remote Desktop Connections Manager
- 落户csdn
- 程序员的灯下黑:坚持和良好心态近乎道
- 前进
- 从客户端检测到有潜在危险的Request.Form 值
- 虚拟机&模拟器
- Configure SQLExpress to accept remote connections
- 巴科斯范式
- 经典外贸口语106句
- 不要一辈子靠技术生存
- 关于使用存储过程的一些好处以及注意事项
- java中的时间操作
- 用户控件中图片路径问题
- 用户控件使用__doPostBack提交信息和其他的不同
- C# 常数 -笔记