How to configure SQL Server 2005 to allow remote connections
来源:互联网 发布:sqlserver自增列 编辑:程序博客网 时间:2024/05/16 08:03
SOURCE: CLICK HERE
When you try to connect to an instance of Microsoft SQL Server 2005 from a remote computer, you may receive an error message. This problem may occur when you use any program to connect to SQL Server. For example, you receive the following error message when you use the SQLCMD utility to connect to SQL Server:
This problem may occur when SQL Server 2005 is not configured to accept remote connections. By default, SQL Server 2005 Express Edition and SQL Server 2005 Developer Edition do not allow remote connections. To configure SQL Server 2005 to allow remote connections, complete all the following steps:
- Enable remote connections on the instance of SQL Server that you want to connect to from a remote computer.
- Turn on the SQL Server Browser service.
- Configure the firewall to allow network traffic that is related to SQL Server and to the SQL Server Browser service.
This article describes how to complete each of these steps.
To enable remote connections on the instance of SQL Server 2005 and to turn on the SQL Server Browser service, use the SQL Server 2005 Surface Area Configuration tool. The Surface Area Configuration tool is installed when you install SQL Server 2005.
Enable remote connections for SQL Server 2005 Express or SQL Server 2005 Developer Edition
To create an exception for the SQL Server Browser service in Windows Firewall, follow these steps:
- In Windows Firewall, click the Exceptions tab, and then click Add Program.
- In the Add a Program window, click Browse.
- Click the C:/Program Files/Microsoft SQL Server/90/Shared/sqlbrowser.exe executable program, click Open, and then click OK.
Note The path may be different depending on where SQL Server 2005 is installed.
================================================================================
SOMETIMES, IF YOU GET THE ERROR:
" the fact that under the default settings SQL Server does not allow remote connections "
YOU SHOULD NOTICE THE CONNECTION STRING.
<add name="conStr" connectionString="server=./SQLEXPRESS;database=Demo;uid=SQL_USER_NAME;pwd=PASSWORD;"/>
ESPECIALLY THE RED PART. SPECIFY THE EXACT SERVER PATH AND NAME IF YOU GET THE ABOVE ERROR WHILE USING "SERVER = . "
- 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?
- How to: Configure Express to accept remote connections
- How to: Configure Express to accept remote connections zz
- 如何解决sql server2005的“不允许远程连接”错误.(how to resolve the error: "SQL Server does not allow remote connections" for SQL Server2005)
- Configure SQLExpress to accept remote connections
- Configure the Windows Firewall to Allow SQL Server Access
- How to Allow MySQL Client to Connect to Remote MySQL server
- Patch to allow multiple connections
- How to configure Tomcat to support remote debugging
- How to kill Active SQL Connections
- How To: Configure Secure FTP Server (VSFTPD)
- How to configure a Dns4 server
- HOW TO: Configure SQL Server to Store ASP.NET Session State
- how to remote connect to isa server 2000?
- How to use sendmail to configure SMTP server
- sql 修改表以及表字段
- 在Tree组件上添加CheckBox组件
- 100个最佳Linux站点
- 硬件设计窍门
- pku 1724 roads 深搜 解题报告
- How to configure SQL Server 2005 to allow remote connections
- JSP+servlet+cookie中的表单中文乱码出错的解决方案
- 从源码编译mtd-utils工具
- 模拟direct path read 等待事件
- 测试日志
- 提问的智慧
- qt移植
- Photoshop素材
- 验证自己给自己曾经许下的诺言