I am a grails user and working with sql server 2008. Because grails uses hibernate I think I am at the right place.
I need some hints on how to get further in connecting to SQL-Server 2008.
Code:
url = "jdbc:sqlserver://[SERVER]:[Port];databaseName=...;instance=SQLEXPRESS;user=...;password=...;"
dialect = org.hibernate.dialect.SQLServerDialect
This code works with SQL Server 2000 and 2005 with pure Groovy-JDBC and Grails / Hiberante. Great!
But switching to SQL Server 2008 only connecting with Groovy JDBC works. Grails / Hibernate does not.
In the stack trace the SQL Server returns, is written, that the user 'sa' has an Authentification Error, though I tried to log as another user.
So I guess I am using a false connection url or it might be something hibernate dialect specifc.
Perhaps somebody can give me a hint where to dig further?