sql文本文档（SQL text document）.doc

sql文本文档（SQL text document） Open the SQL Server Configuration Manager to see the SQL Native Client Configuration inside to determine if the alias is configured. Note: if you connect remotely to a remote database, you can use this method for alias configuration to connect to a remote database. Step 2. Completely solve the problem of SQL SERVER 2005 unable to connect remotely One, enable remote connections for SQL 1. Click start, pointing to program, Microsoft SQL Server 2005, and configuration tools, and then click on SQL Server peripheral application configurator. 2. Click on the peripheral application configurator of service and connection on SQL Server 2005 peripheral application configurator page. 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: click ok when you receive 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 SQL Server Browser service 1. Click start, pointing to program, Microsoft SQL Server 2005, and configuration tools, and then click on SQL Server peripheral application configurator. 2. Click on the peripheral application configurator of service and connection on SQL Server 2005 peripheral application configurator page. 3. Click on SQL Server Browser on the peripheral application configurator of service and connection and click auto in start type and then click apply. Note: after clicking the automatic option, the SQL Server Browser service is automatically started every time Microsoft Windows