Connect To Sqlserver2005

[cavogadr]

Hi!!!!.... Anybody that could connect sqlserver 2005 that want to help me.

I haven't connected isomorphic to sqlserver yet.

here server log.

=== 2010-06-07 19:41:13,406 [sor3] DEBUG RPCManager - Request #1 (DSRequest) pay
load: {
    appID:"adminConsole",
    operation:"testDB",
    values:null,
    dbName:"SQLServer",
    dbConfig:{"driver.portNumber":"1433", "interface.type":"dataSource", "driver
.networkProtocol":"TCP/IP",
     "driver.context":"_container_","database.type":"sqlserver", driverName:"sql
server",
     dbName:"SQLServer","driver.url":"jdbc:microsoft:sqlserver://databases:1433;
DatabaseName=master;User=DBUSER;Password=DBPASS",
     driver:"com.microsoft.sqlserver.jdbc.SQLServerDriver",dbStatus:"Unable to c
onnect",
     "driver.driverType":"thin",useURL:true, "driver.serverName":"Embedded in JD
BC URL",
     _selection_10:true},
    criteria:{}
}
=== 2010-06-07 19:41:13,406 [sor3] INFO  IDACall - Performing 1 operation(s)
=== 2010-06-07 19:41:13,406 [sor3] DEBUG AppBase - [adminConsole.testDB] No user
Types defined, allowing anyone access to all operations for this application
=== 2010-06-07 19:41:13,406 [sor3] INFO  AppBase - [adminConsole.testDB] Invokin
g custom app operation method '_testDB'
=== 2010-06-07 19:41:13,406 [sor3] INFO  AdminConsole - [adminConsole.testDB] te
sting db 'SQLServer' with config: {"driver.portNumber":"1433", "interface.type":
"dataSource", "driver.networkProtocol":"TCP/IP",
 "driver.context":"_container_","database.type":"sqlserver", driverName:"sqlserv
er",
 "driver.url":"jdbc:microsoft:sqlserver://databases:1433;DatabaseName=master;Use
r=DBUSER;Password=DBPASS",driver:"com.microsoft.sqlserver.jdbc.SQLServerDriver"
,
 "driver.driverType":"thin","driver.serverName":"Embedded in JDBC URL"}
=== 2010-06-07 19:41:13,421 [sor3] DEBUG AdminConsole - [adminConsole.testDB] Te
sting DB connection for database: SQLServer with config: {"driver.portNumber":"1
433", "interface.type":"dataSource", "driver.networkProtocol":"TCP/IP",
 "driver.context":"_container_","database.type":"sqlserver", driverName:"sqlserv
er",
 "driver.url":"jdbc:microsoft:sqlserver://databases:1433;DatabaseName=master;Use
r=sa;Password=Sqlserver01",driver:"com.microsoft.sqlserver.jdbc.SQLServerDriver"
,
 "driver.driverType":"thin","driver.serverName":"Embedded in JDBC URL"}
=== 2010-06-07 19:41:13,421 [sor3] DEBUG PoolableSQLConnectionFactory - [adminCo
nsole.testDB] Initializing SQL config for 'SQLServer' from system config - using
 DataSource:  com.microsoft.sqlserver.jdbc.SQLServerDriver
=== 2010-06-07 19:41:13,421 [sor3] INFO  AdminConsole - [adminConsole.testDB] te
stDB (SQLServer) error: java.lang.ClassCastException: com.microsoft.sqlserver.jd
bc.SQLServerDriver
=== 2010-06-07 19:41:13,421 [sor3] DEBUG RPCManager - Content type for RPC trans
action: text/plain; charset=UTF-8

I've tried all "interface type" without success.

I've installed jdbc on Sun System and it worked fine.

The driver is ok, because if it were bad, the status in the admin console would be driver not installed.

Any clue?. Thanks.