I have a wm7 server with a SQL Server 2k8. I can access my database using pure Java code and I can even access it with the old WmDB with the following config:
DB Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver
Alright, now in my JDBC connection, I set “com.microsoft.sqlserver.jdbc.SQLServerDriver” as DataSource class, test for Database Name and “instanceName=SQLEXPRESS” in Other Properties. All of this seems fine to me but when I try to enable the connection I get:
Error encountered [ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource database:TESTCONN.
[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
Does someone know if I am doing something wrong?