[color=#121E9C][size=4][font=Arial]Giuseppe,
If you actually have access to the database you're trying to connect to then this is what I use:
<core:set var="DB_Server_Name_or_IP"
value="255.255.255.255" />
<core:set var="DB_Database_Name"
value="DBname"/>
<core:set var="DB_user"
value="username" />
<core:set var="DB_password"
value="password" />
<core:set var="Clarity_DB" value="jdbc:sqlserver://${DB_Server_Name_or_IP}:1433;databaseName=${DB_Database_Name};user=${DB_user};password=${DB_password};"/>
<sql:setDataSource url="${Clarity_DB}" driver="com.microsoft.sqlserver.jdbc.SQLServerDriver" var="ClarityDS"/>
Just remember you'll need the latest Microsoft JDBC driver files available from their website. These files should be in the lib folder of the XOG/GEL installation.
sqljdbc_xa.dll
sqljdbc_auth.dll
sqljdbc4.jar
sqljdbc.jar
Hope this helps.
Patrick
[font][size][color]