on 11-14-2014 4:20 PM
Hi Everyone,
Please help me to solve the below communication channel connectivity issue.
User has created a new communication channel through Integration Builder but while checking communication channel monitor I can see below error.
Database Connectivity Test Could Not Open connection to jdbc:sqlserver://xx.xx.xx.xx:1433; databaseName=xxxx
JDBC Driver : com.microsoft.sqlserver.jdbc.SQLServerDriver
I checked the connectivity issue through ping or telnet from apps server to target system and its going through fine. Port is also there in service file.
I asked user and he is able to connect from given userid and password through SQL Server Management Studio.
Best Regards,
Avinash Tripathi
Hi All,
My apologize, I have not replied on time.
The issue got resolved by changing the driver version and then restart Java Instance.
Thanks for all your suggestion.
Best Regards,
Avinash Tripathi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Avinash,
On the Database server check if the SQL Server Browser service is running and recheck if "Allow remote connections to server" is checked for the database.
Regards,
Alka Panday.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Avinash,
On prod server, Go to SE38, run the program RSBDCOS0
Do a Telnet from here and check if the return code is OK. You might have to take help of Basis if you do not have access for t code.
Regards,
Pranav
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Few things to see..
Please make sure jdbc drivers for the right version of jvm is installed. You might want to check Microsoft web site for it. They recommend diff drivers for 2000, 2003, 2008 versions...
If the sql server side settings is in default settings, this server might not allow remote connection to be established. You already confirmed about firewall port thing.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
If you are using SQL Server 2000 driver , then class name should be as follows:
Driver class | : | com.microsoft.jdbc.sqlserver.SQLServerDriver |
URL | : | jdbc:microsoft:sqlserver://<db_server>:port;databaseName=<db_name> |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.