Can't Connect with Remote Sql server.

Hello All ,

I had installed Sql Server 2000 on Windows server 2003 enterprize Edition. But when I Try to connect it with Remote, 'Sql Server doesn't exists' message appears..

anybody know what may be the reason?

Moving this thread to the SQL Server forums.|||

By default, SQL Server 2005 does not allows remote connections. To configure SQL Server 2005 to allow remote connections, complete all the following steps:

1.Select the SQL Server Surface Area Configuration tool from the Configuration Tools and then click Surface Area Configuration for Services and Connections option. expand Database Engine, click Remote Connections, click Local and remote connections, click the appropriate protocol to enable for your environment, and then click Apply and Ok for restarting the Database engine service.

2. Try adding sqlservr.exe (present in \MSSQL\Binn directory for the default instance and \MSSQL$instance_name\Binn directory for the named instance) in the list of allowed firewall exceptions on the Windows 2003 box.

Regards,

Rajesh

|||

My question was slightly wrong..

I want to connect with sqlserver 2000 with Ip address.

-my installments are

1. Microsoft Windows Xp or window 2003 server

2 Sql Server 2000

and just want to do to connect with ip address.

I can connect to sqlserver with ip in windows2000

|||

You can connect using IP Address without any problem and for that ensure to add an entry on the client network utility on your client's machine.

Also refer to KBA http://www.sql-server-performance.com/faq/sqlviewfaq.aspx?topicid=12&faqid=143 which helps to resolve any issues you might get.