nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

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.

Find more posts tagged with

Comments

mikeh

http://forums.alfresco.com/viewtopic.php?t=7294

davidc

You need to change Alfresco's sql dialect to SQL Server. It's much easier.

http://wiki.alfresco.com/wiki/Database_Configuration

gbaindl

Hi David,

thanks, but this is what I did. Here is the configuration in repository.properties:

# Database configuration MS SQL Server
db.schema.update=true
db.driver=net.sourceforge.jtds.jdbc.Driver
db.name=Alfresco
db.url=jdbc:jtds:sqlserver://xxx.web-shuttle.de:1433;DatabaseName=${db.name}
db.username=Alfresco
db.password=alfresco
db.pool.initial=10
db.pool.max=20

The alfresco start file can connect to the database, but it runs the mysql-comands and this brings up an error.

I would be good, if there is a detailed installation documentation about eyery step and change in every file. So I can reinstall Alfresco.

Thanks for your help.

Georg

davidc

You're missing the dialect config. The configuration steps are listed in the URL I pasted earlier. There's also a link to the list of dialects for all databases.

gbaindl

Now I found the wrong thing. I forgot to copy the jtds-1.2.jar File to the lib Folder. Now it runs with MS SQL Server. Thank you fpor your help

Georg

akshayakher

Can you simplify and give more details on that. I am trying to configure Alfresco 2.0 with MS SQL

Thanks for your help in advance
Akshaya

nick_gti

Can you simplify and give more details on that. I am trying to configure Alfresco 2.0 with MS SQL

Thanks for your help in advance
Akshaya

Here is how i got it to work.

Also please note this was a fresh install of alfresco 2.1RC1 on windows 2003 server.

First edit the custom-hibernate-dialect.properties located in the tomcat\shared\classes\alfresco\extension folder.
Contents of my file.

# Sample Hibernate configuration to disnable Hibernate schema updates
# Values are "validate" or "update" (default)
#hibernate.hbm2ddl.auto=validate

#
# Microsoft SQL dialect
#
hibernate.dialect=org.hibernate.dialect.SQLServerDialect
‍‍‍‍‍‍‍‍‍

Second edit custom-repository.properties
added to the file:

db.schema.update=true
db.driver=net.sourceforge.jtds.jdbc.Driver
db.name=Alfresco
db.url=jdbc:jtds:sqlserver://MYSQLSERV:1433;DatabaseName=${db.name}
db.username=Alfresco
db.password=alfresco
db.pool.initial=10
db.pool.max=20
‍‍‍‍‍‍‍‍‍‍

Third copy the jtds-1.2.jar file you download to \tomcat\common\lib\

Forth: I made a new database using sql enterprise manager called Alfresco
Created a sql user account named alfresco that is a member of the Alfresco database and had system administration role.

Once this is all done i started alfresco up and it ran the scripts and i was ready to go.

akshayakher

Thank you so much. I will try and implement this.

Regards
Akshaya

akshayakher

one more clarification.

jtds-1.2.jar file you would be getting when we download tomcat right or when we download alfresco?

Also will this whole setup work with Alfresco 2.0

Thanks a lot for your help.

Regards
Akshaya

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