cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Server 2005 Connection Status Pending

Former Member
0 Kudos

Hi all,

How do I debug a SQL Server connection in ? The status goes to pending and stays there.


MII V12.0.4
VMWare/Windows 2003 64bit
SQL Server 2005 JDBC Driver 1.2, a Type 4 JDBC 

I deployed the sqljdbc.jar to MII (downloaded and deployed).

I created a new IDBC type SQL. I changed the following:


  JDBC Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver
  Password: abcdefg!
  Server URL:   jdbc:sqlserver://xx.xx.xx.xx:4813;databaseName=MYDB;
  User Name: my_user

I am able to use a Java program from my PC to connect to the database using sqljdbc.jar


  Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
  String connectionUrl = "jdbc:sqlserver://xx.xx.xx.xx:4813;" +
	   "databaseName=MYDB;user=my_user;password=abcdefg!;";

I used NetWeaver Administration/Sys Mgmt/Monitoring/Logs and didn't see anything interesting.

I don't know what to do next and I don't have access to

Thanks,

--Amy Smith

--Haworth

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

Amy,

Where is the server located? I think its the problem with some firewall blocking that port. Configure the firewall to allow the port.

One more option you can try is to use system name instead of IP. Make an entry in the hosts file(drivers\etc) and use the server's host name and try. I had faced similar kind of problem before and this thing had worked for me.

Regards,

Prasanna

Former Member
0 Kudos

Thanks for the hints.

I don't really know what was wrong. The consultant had installed a SQL Server 2000 jar and we have 2005. Even though I was assured it would work, I downloaded the correct JDBC drivers and configured the correct connect string for the new driver. Everything works fine now.

--Amy Smith

--Haworth

0 Kudos

Sounds like you do know what was wrong. "The consultant had installed a SQL Server 2000 jar and we have 2005. Even though I was assured it would work..."

Former Member
0 Kudos

Punish the guilty! Name that bad consultant!

Answers (0)