Is it possible to connect to SQL Server in another host?

[Former Member]

Hi all,

I have a problem with the connection to SQL Server. I have installed SAP Netweaver on my server. I try to connect form SAP EP to MaxDB or MySQL, it's OK. But when I try to connect to SQL Server (not localhost, in another computer), I have an error "fail to connect to back-end system ...".

I have also download the JDBC driver for MSSQL, and follow the steps on wiki:

- Driver: com.sap.portals.jdbc.sqlserver.SQLServerDriver

( or com.microsoft.jdbc.sqlserver.SQLServerDriver)

- URL: jdbc:sap:sqlserver://Myserver:1433;DatabaseName=DemoDB

Is it possible to connect to sql server in another host ?

Thank you very much & best regards,

Tweety.

[Former Member]

Hi Silvecast,

I have a similar problem, have MI server on my machine and sql server on another machine and trying to connect sql server from my server by using the following code

String driverClass = "com.microsoft.jdbc.sqlserver.SQLServerDriver";

try

{

Class.forName(driverClass);

}

But I am getting class Not found exception, could you please tell me the solution if you have any idea.

Thanks and Regards,

Kishore.

[Former Member]

Thanks for your reply.

The problem is that, if I use JDBC MSSQL Driver of Microsoft,

the Driver Class must be:

com.microsoft.jdbc.sqlserver.SQLServerDriver

and the Connection URL:

jdbc:microsoft:sqlserver://hostname:1433;database=<database name>

Kindly regards,

Tweety.

[Former Member]

Ti Tweety,

this should be possible, did you check if the port is open (e.g. with telnet)?

Best Regards,

Marcel