Error connecting to SQL server

Hi,

We have a Windows 2000 terminal server with service pack 4 loaded.This has siebel application 7.8.2 .

We have another Windows 2003 standard edition server with service pack 1. This has SQL 2000 server with Service pack 4 installed.

When trying to connect to the sql server through odbc , i get an error

Microsoft SQL Server Login

Connection failed:
SQLState: '01000'
SQL Server Error: 10061
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied.

OK

-I am able to ping the server and viceversa.

Please let me know how to resolve this problem

Then you either have a different port than 1433 (you will have to specify the portnumber after the instance / servername with the syntax --> default instance Servername,Portnumber ; Servername\InstanceName,Portnumber for named instances). Do you have a firewall installed ? Then you will have to check if the appropiate port for SQL are enabled.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de|||

Please follow the instruction and give us more details:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=362498&SiteID=1

|||

Hi

The port is configured to 1433

There is no firewall installed

does it happen due to ODBC version.?

|||

the issue is most likely that you are using terminal server and the odbc is a user odbc, and not a system odbc. if system odbc has not been created for the connection that is having the issue, create it.

ping uses icmp, and not always best test. test the odbc, recreate it if necessary. to check the 1433 port, open telnet client and type in telnet:1433; if it opens, the port is open, otherwise you know it's closed.

also check that the db is using the 1433 port (could have been configured to use alternate).

btw- i don't think siebel 7.8.2 is supported on 2000 server