SQL Server 2008

[indyjones2]

Can someone walk me through the steps needed to take to connect Seam 2.2.0 to a SQL Server 2008 instance....

When I log into the SQL server....my login box shows...

smithlap\SQLEXPRESS

When I log in I have one database called blue....

So, my connection url in my ds.xml is...

jdbc:sqlserver://smithlap\SQLEXPRESS:1433

And in my persistance.xml I have...

<property name="hibernate.default_schema" value="blue"/>

I know this isnt correct....can someone help?

Thanks

I did make sure the TCP/IC connetion was enabled through SQL Server Connfiguration manager....

[eiglesia]

Try this on your persistence.xml
       

 <property name="hibernate.default_catalog" value="nameOfDataBase"/>
         <property name="hibernate.default_schema" value="dboOrYourSchema"/>

Hope this helps