SQL Server 2008 R2 not connecting in MII 12.2.2.8

[Former Member]

Hi,

We have installed MII 12.2 with SP 2 and Patch Level 8 on the Netweaver 3 and the MII is a GA version...

I am able to connect to ERP but in the case of SQL Server 2008 R2 i am not able to connect.

I have dowloaded the Microsoft SQL Server JDBC Driver 3.0 and upload the same in MII and deployed the same without any issue.

Data Server Configration:

Connector : IDBC

Connectory Type : SQL

Date Prefix :'

Date Suffix : '

Retention Days :7

Internal Data Format: yyyy-MM-dd HH:mm:ss

JDBC Driver : com.microsoft.sqlserver.jdbc.SQLServerDriver

Max Retry Count : 5

Password: .....

Pool Max :100

Pool Size : 1

Retry Interval : 60,000

Server URL:jdbc:sqlserver://Hostname:1433;databaseName=xMIIDemo

Time Out :15

Use Count : 256

Username : sa

Validation Query : SELECT GETDATE()

Wait Time : 30

But in the status it is showing as Stopped...

Java Production Version 7.00 is running on the client... desktop...

Thanks in advance

[khaleelurrehman_badeghar · Accepted solution]

Hi Prasanna,

Try by replacing the Server URL in your current settings with this:

jdbc:sqlserver://<serverName or IP>:<port>;instanceName=SQL2008R2;database=DBName

If it does not work then this is the problem with JDBC driver.

Use jtds-1.2.5.jar and accordingly you should change

JDBC Driver: net.sourceforge.jtds.jdbc.Driver

Server URL: jdbc:jtds:sqlserver://<serverIP or name>:<port>/DBName

Hope this helps.

Thanks and Regards

Khaleel

[Former Member]

Here is how I got it to work:

Microsoft SQL Server JDBC Driver 3.0

Can be downloaded as a self extracting archive here:

http://www.microsoft.com/download/en/details.aspx?id=21599

Important: Contains two different and mutually exclusive JDBC drivers u2013 one is for Java 5 (1.5) and one is for java 6 (1.6) u2013 and they are not upward/downward compatible so you must choose the right JDBC driver!

NW 7.3 is running on Java6 and so you must choose sqljdbc4.jar !

Also, the class path has changed to: com.microsoft.sqlserver.jdbc.SQLServerDriver

And the connection URL format has changed:

jdbc:sqlserver://[NAME/IP]:[PORT];instanceName=[INSTANCE];database=[DBNAME]

This is not documented in the download page or the archive , but very good documentation is available on MSDN:

http://msdn.microsoft.com/en-us/library/hh335190(v=SQL.10).aspx

Hope this helps!