We have installed SQL Server 2000 in our new server running on Microsoft Windows Server 2003.
We tried to connect to the database in the Server where it is installed. We are able to connect when we give server name. We are unable to connect when we give IP Address of the server.
We have latest SP3a of SQL Server 2000 installed.
Could anyone help us in resolving this issue?
Thanks in Advance.Ensure to use the HOSTS file or LMHOSTS, put the TCP/IP address of the SQL Server server at the start of the line followed by a few spaces followed by the machine name of the SQL Server server.
The HOSTS or LMHOSTS file belongs in the System32\Drivers\Etc directory for client computers running Microsoft Windows NT and Microsoft Windows 2000, or in the \Windows directory for clients running Microsoft Windows ME, Microsoft Windows 98, or Microsoft Windows 95.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment