Connecting xMII with ms sql2005

[Former Member]

Hi All,

I want to connect to ms sql2005 from xmii11.5

My xmii is installed in one machine and the sql2005 database is installed in a different machine.

Is it mandatory to install sql2005 on the same machine where xmii is installed or we can put it across diffrent machines?? please let me know how to go about it..

<b>There is also other scenario where i have sql 2000 installed in a diferent machine.

Is it possible to connect it to xmii server remotely.</b>

Thanks in advance.

Regards

Aseem

[Former Member · Accepted solution]

No it is not mandatory.

What do you mean by "Is it possible to connect it to xmii server remotely"?

As far as how to go about it goes, i would request you to first please go throgh the help,forums etc. Try it out yourself and come back to the forum incase you get stuck during that course.

[Former Member]

Thanks everyone

[Former Member]

ya you can do tat.... just define the database server in the xMII data servers tab....

goto data services->dataserver...

you have to look for Default JDBC server after unchecking "Show Only Enabled Servers "

copy it and give a new name...

<b>jdbc driver..... com.mysql.jdbc.Driver</b> (if its mysql)

<b>server URl ...........jdbc:mysql://IPaddress of the sql server/databasename</b>

give username and password....enable it...nd save it...