DB-Scripts for MS SQL Server needed

[gbaindl]

Has everyone built the db-scripts (create, …) for MS SQL Server? If I startet the file "AlfrescoSchemaCreate-org.hibernate.dialect.MySQLInnoDBDialect-64635.sql" I get many error and I'm not a SQL Specialist for the different SQL-Types.

[akshayakher]

also if the sql is on some other machine/server how can we tweak this code

db.url=jdbc:jtds:sqlserver://MYSQLSERV:1433;DatabaseName=${db.name}

[nick_gti]

Download jtds from http://jtds.sourceforge.net/index.html

Extract the download and just copy the jtds-1.2.jar file to:
tomcat\common\lib

On this line

db.url=jdbc:jtds:sqlserver://MYSQLSERV:1433;DatabaseName=${db.name}
‍‍‍

MYSQLSERV is your database server's hostname or ip.

[akshayakher]

Hi,

I tried all the steps given above..i dont know what I am missing here but just not working..its trying to find hsql, here is the error

Exception in thread "HSQLDB Timer 8aaff4" java.lang.NullpointerException
at org.hsqldb.lib.Hsqltimer.nextTask<unknown source>
at org.hsqldb.lib.Hsqltimer$TaskRunner.run<Unknown Source>
at java.lang.Thread.run<Thread.java:595>

Are above instructions possible with SQL2005 and Alfresco 2.0

Please help!!!

Thanks
Akshaya