sqlserver远程连接的问题（国外英文资料）.doc

sqlserver远程连接的问题（国外英文资料） SQL SERVER 2005 problem that can not connect the remote SQL SERVER 2005 2009-11-30 were unable to remote connection problem when the 2005 ticket is connected to the SQL SERVER 2005, under the default Settings SQL SERVER does not allow remote connections may lead to the failure (Microsoft SQL SERVER, an error: 10060) Step 1. Open the SQL Server Configuration Manager to view the SQL Native Client Configuration inside to determine whether the alias is configured. Note: if you are remote, you can use this method for alias configuration and connect to a remote database. Step 2. Completely solve the problem of SQL SERVER 2005 that cannot be remotely connected One, enable remote connections for SQL Click start, pointing to program, Microsoft SQL Server 2005 and configuration tool, and then click SQL Server peripheral application configurator. On the external application configurator on SQL Server 2005, click the peripheral application configurator for services and connections. 3. The outside of the service and connection application configurator page, expand database engine , in turn, click the remote connections and local and remote connections, click the corresponding agreement applicable to your environment, and then click apply. Note: please click ok when receiving the following message: The changes to the connection Settings will not take effect until the database engine service is restarted. 4. In the service and the connection of peripheral application configurator page, expand database engine , in turn, click on the service and stop, waiting for the MSSQLSERVER service to stop, and then click on start to restart the MSSQLSERVER service. Second, enable the SQL Server Browser service Click start, pointing to program, Microsoft SQL Server 2005 and configuration tool, and then click SQL Server peripheral application configurator. On the external application configurator on SQL Server 2005, click the peripheral application configurator for servi