SQL server2005 cannot be accessed directly by ip address

Sql2000 was originally installed, sql2005 was newly installed, and the new instance "sql2005" was used. After installation, you can access the database using the instance sql2005 or ipsql2005 or the machine name sql2005,

However, you cannot access the port directly in the form of an IP address or port. telnet also shows that the port is enabled.

After searching on the Internet, you can find that you only need to set the instance name, and the instance name must be included during access. Currently, this machine cannot use the default instance name because it is already occupied by sql2000, so sql2005 cannot be used.

Solution: replace sql2000 with 2005.

Question 2

Check that the local port 1433 is bound, and telnet Port 1433 is also successful. The IP address is inaccessible.
That is, the connection string:
Provider = SQLOLEDB.1; Password = 123; Persist Security Info = True; User ID = sa; Initial Catalog = InfoPubAttach; Data Source = 172.16.8.88 connection failed,
However, you can change 192.16.8.88 to DBServerSQL2005. DBServer is the machine name, and SQL2005 is the instance name for installing SQL Server2005
In addition, changing to the machine name also fails. That is, access is only allowed through DBServerSQL2005.

A program must also be accessed using an IP address.

Open start-all programs-Microsoft SQL Server 2005-Configuration tool-SQL Server Configuration Manager"

Find "SQL SERVER 2005 network configuration-MSSQLSERVER protocol" and find that the "TCP/IP" status is "disabled", which is the key to the problem. Double-click it, set it to "enabled", restart SQLSERVER, and solve the problem.