Connections through a server alias, IP address, or any other alternate name are not supported.

Hi

I am trying to connect to another sql server in my company using the IP address for exmp. : 111.111.1.1\SQL2005 but it show this message:

Connections through a server alias, IP address, or any other alternate name are not supported. it was working well on SQL2000

Please help

Have you tried to create an alias in SQL server configuration manager?

Gary

|||Yes I did and is still not accepting|||

Hi Ziad,

Can you explain what you did exactly ? did you create the following:

1-create alisan name : mysecondserver

2-port: by default empty , you need to specify the port in case you have firewall issue.

3-protocol: TCP/IP or other..

4-server: IP\instance_name

NB: to be sure about server name on the second server select @.@.servername in query window on the second server.

If you still cannot connect , please send me a direct email, you can find it on my site and i will try to discuss it with you.

Tarek Ghazali

SQL Server MVP

http://www.sqlmvp.com