Shulou(Shulou.com)05/31 Report--

SQLServer database can not be remotely connected how to solve, many novices are not very clear about this, in order to help you solve this problem, the following editor will explain in detail for you, people with this need can come to learn, I hope you can gain something.

When SQLServer database is connected remotely, we are often perplexed by some phenomena that can not be connected. In fact, the problem of remote connection is not as difficult to solve as imagined.

Solution:

1. Enable remote connection for SQLServer2005ExpressEdition or SQLServer2005DeveloperEdition.

Remote connections must be enabled for each instance of SQLServer2005 that you want to connect to from a remote computer. To do this, follow these steps: 1. Click start, point to programs, point to MicrosoftSQLServer2005, point to configuration tools, and then click SQLServer Peripheral Application Configurator.

two。 On the SQLServer2005 Peripheral Application Configurator page, click Peripheral Application Configurator for Services and connections.

3. On the Peripheral Application Configurator for Services and connections page, expand Database engine, click remote connection, click Local connection and remote connection, click the appropriate protocol for your environment, and then click apply.

How to solve the problem that SQLServer database can't connect remotely?

Note: click OK when you receive the following message: 4. On the peripheral application configuration for services and connections page, expand Database engine, click Services, click stop, wait for the MSSQLSERVER service to stop, and then click start to restart the MSSQLSERVER service.

If not, continue with the operation: use telnet to connect port 1433 and report a connection failure. It should be the network management that has sealed port 1433.

Solution: use other available ports by:

1. Open SQLServerConfigurationManager on the server. Select SQLServer configuration Manager-> SQLServer2005 Network configuration-> MSSQLSERVER Protocol-> TCP/IP, and select IP address-> IPALL- > TCP Port in the pop-up dialog box to set it to available port.

2. In the same program, select SQLServer configuration Manager-> SQLServer2005 Service-> SQLServer (MSSQLSERVER), and select restart from the right-click menu.

3. Enter: IP, port in the server name in the client login box.

4. the connection is successful.

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.