SQL Server 2005 Not connecting to MII 12.2

[Firoz_Ashraf]

Hello Experts !

We have installed MII 12.2 with SP 3 on Netweaver 7.3 SP 5

We are trying to make SQL Connection but are not able to connect.

The status in MII is showing as STOPPED.

We have successfully deployed the following JDBC:

1. sqljdbc4.jar

2. sqljdbc.jar

Below is our DATA SERVER details:

Data Server Configration:

Connector Type : IDBC(SQL)

JDBC Driver : com.inet.tds.TdsDriver

Server URL: jdbc:inetdae:10.3.48.201:1433?database=heatdata&sql7=true;

Any help would be highly appreciated.

Regards,

Firoz.

[jcgood25 · Accepted solution]

Your driver and connection string settings are for a different driver.

http://msdn.microsoft.com/en-us/library/aa342339.aspx

[Firoz_Ashraf · Accepted solution]

Hi Jeremy,

Thanks for your advice.

I changed the connection and driver as follows and it worked !!

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

Server URL: jdbc:sqlserver://10.3.48.201:1433;databaseName=heatdata

Thanks again.

Regards,

Firoz.