Connection Problem to SQL2005 via ODBC

[appi]

Hi all,

we've two servers. One with the Tool and the second with a SQL Server 2005.
I try to set up an ODBC-Connection to the db-server
I tried all possible ways.
The server is setup like <hostname>\<Instance>
I take hostname in the Server field and also in the Client Config with dynamically port
==> SQLSTATE 01000 Server Error 10060 and SQLSTATE 08001 SQLERROR 17
Also tested to use <hostname>\<Instance> in both config
==> SQLSTATE 01000 Server Error 11004 and SQLSTATE 08001 SQLERROR 6
If I try to connect from a local PC everything works with
Server = hostname and Client Connectivity = <hostname>\<Instance>.

How could I set up the Connection from the Tools-Server ?

kind regards
appi

 

[Jamfool]

as default sql 2005 will not accept remote connections. you will need to change this in surface area configuration on your server running your db.

 

[appi]

Hi all,

we found the problem. Our Firewaller have had half closed eyes ..... jusst the config in firewalling was wrong.
Sorry for the confusion over here.