Weblogic 8.1 JDBC connection pool error

[sumon24]

Hello All,

I am trying to create a JDBC connection pool in weblogic 8.1
My database is MS SQL Server 2005. My database instance name is like MyServer\Test and the database name is MyTestDB. My database and weblogic are installed on different servers.
I am logging to my Weblogic console and going to
Services>JDBC>Connection Pool
In the 'Configure a connection pool' page I am giving the following details -
Database Name: MyTestDB
Host Name: MyServer\\Test <even tried "MyServer\Test">
Port:1433
Database User Name:sa
Password:***
Confirm Password:***

In the next page when I am trying to test the connection, it is throwing an error
"[BEA][SQLServer JDBC Driver]Error establishing socket to host and port: MyServer:1433. Reason: Connection refused: connect".
As you can see it is ignoring the Instance name "\Test", because I believe '\' is an escape character in UNIX. Hence i am using '\\', but without any result. I have tried IP address also, but nothing is working.

I am stuck with this for a long time.

Any help in this regard will be highly appreciable.

Best Wishes,
Sumon

 

[Diancecht]

Do you have IP connectivity, ie, no firewall?

Cheers,
Dian