Skip to Content
avatar image
Former Member

SQL Server 2005 Connection Status Pending

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Aug 05, 2008 at 06:01 AM

    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

    Add comment
    10|10000 characters needed characters exceeded