on 05-30-2011 4:17 PM
Hi experts
I'm trying to use JDBC for managing some B1 tables not accessible through DI API.
In the landscape systems I parameter my fields like that :
Driver : com.microsoft.sqlserver.jdbc.SQLServerDriver
URL : jdbc:sqlserver://MYSERVER;instanceName=MYINSTANCE;integratedSecurity=false;databaseName=MyBASE
User : sa
Pass : ******
The connection seems to succed but the IPO failed and when i try the BIU i get the same erreur, the next one :
Failure of the TCP / IP host SRVSAP2007, 1433. Error: "Connection refused: connect. Check the connection properties, make sure that an instance of SQL Server is running on the host accepts the TCP / IP port, and make sure no firewall is blocking TCP connections to port.
The SQL Instance run (it works on the local SQL Server Mangement studio) on the same server and there are no firewall on the 2 servers.
Note : I use SQL SERVER 2008 R2 and i think at 90% the JDBC driver are installed
Thanks for your help
Best regards
Hi,
do you use a special INSTANCE on your SQL server?
Otherwise it's enough to provide following information in field url of the system landscape definition:
dbc:sqlserver://MYSERVER:1433;integratedSecurity=false;databaseName=MYB1DATABASE
Please make also sure, that the port e.g. 1433 is activated in SQL Server Configuration Manager under TCP/IP settings.
Best regards
Bastian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
103 | |
12 | |
11 | |
6 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.