cancel
Showing results for 
Search instead for 
Did you mean: 

Connecting MII 12.0.4 to MS SQL 05

Former Member
0 Kudos

Hello,

I am having problems establishing connection between the MII system and MS SQL 05. I have gone through the other threads related to this question and have followed note 990322. But it is surprising the connection is not even listed in the 'Connection Status' page ( of course I have enabled the connection ). For the individual connection status, the status is 'Running' and other values such as 'No. of Used Connections' display blank ( Not ZERO ).

Please let me know your thoughts. Thanks for your time.

Cheers, Praveen

Accepted Solutions (0)

Answers (1)

Answers (1)

0 Kudos

I don't know if it can help but this is what we have setup to connect to an MSSQL 2005 (SQLEXPRESS server)

1) Add the jdbc driver : sqljdbc.jar given by MICROSOFT

& Deploy it

2) Create a new IDBC server :

JDBCDriver : com.microsoft.sqlserver.jdbc.SQLServerDriver

ServerURL : jdbc:sqlserver://hostname\instancename:port;databaseName=basename

example:

ServerURL : jdbc:sqlserver://frbetms51-sv01.ist-priv.rhodia.com\SQLEXPRESS:1433;databaseName=MES_LIB

Password :

Username : yourusername

ValidationQuery : SELECT GETDATE()

Another advise is to be sure that you can connect to the MS SQL server using for instance the MS SQL Server Management studio Express

From time to time I had to stop & restart the XMII application so new connection works properly.