topic Re: SQL Server Configuration Failed in Alfresco Archive

SQL Server Configuration Failed

sajiworkz — Tue, 03 Mar 2009 10:14:48 GMT

Hi , I am using Apache tomcat 6.0.18,Alfresco Labs 3 Stable in Windows XP Platform. The database is derby. Actually it works fine but i got the some errors when i tried to configure the same installation with SQL Server 2005. I was using version 3a with Sql Server 2005 and i have the alfesco databas

Re: SQL Server Configuration Failed

mikeh — Tue, 03 Mar 2009 12:18:01 GMT

http://forums.alfresco.com/en/viewtopic.php?f=8&t=17252&p=56742#p56742

Mike

Re: SQL Server Configuration Failed

sajiworkz — Tue, 03 Mar 2009 12:35:13 GMT

Hi Mike,

Thanks for your prompt reply, but it was working fine with my previously Installed version 3.0.0 (a 1032) schema 128. Could you please confirm there is no way to connect MS SQL Server with alfresco 3 Stable version.

Regards,

Saji

Re: SQL Server Configuration Failed

mikeh — Tue, 03 Mar 2009 13:37:00 GMT

That's correct - you'll have to use Derby or MySQL (recommended).

Thanks,
Mike

Re: SQL Server Configuration Failed

sajiworkz — Wed, 04 Mar 2009 05:10:34 GMT

Hi Mike,

Thanks again, Could you please tell me how can i upgrade my previously installed version (version 3.0.0 (a 1032) schema 128) into alfresco 3 Stable version. Becuase as i mentioned the earlier version 3.0.0 (a 1032) was working fine with SQL Server Database.

Regards,

Saji

Re: SQL Server Configuration Failed

mikeh — Wed, 04 Mar 2009 09:27:57 GMT

Please see http://wiki.alfresco.com/wiki/General_Upgrade_Process

Note you'll also have to move your SQL Server database over to MySQL. There are probably 3rd party tools to help you with this.

Thanks,
Mike

Re: SQL Server Configuration Failed

sajiworkz — Thu, 05 Mar 2009 13:08:56 GMT

Hello Mike,

Thanks for your support, but we need to continue with SQL Server 2005. Could you please suggest some workaround to keep MS SQL as the backend for Alfresco 3 stable.

Regards,

Saji Krishnan

Re: SQL Server Configuration Failed

mikeh — Thu, 05 Mar 2009 13:52:00 GMT

You'd need to take the MySQL upgrade scripts and translate them into SQL Server-compatible versions in the correctly named folder. Have a look at some v2.x upgrade scripts for examples.

Thanks,
Mike

Re: SQL Server Configuration Failed

holgert — Tue, 24 Mar 2009 15:50:51 GMT

Hi Mike and Saji,

I am surprised that Alfresco 3.0 and MS SQL should not work. I installed such a configuration (Alfresco3, Stable 1526, schema 1002) recently and it worked fine.
Alfresco did all the schema creation in Microsoft SQL (after I had changed the hibernate-config in 'custom-hibernate-dialect.properties' and added "hibernate.dialect=org.alfresco.repo.domain.hibernate.dialect.AlfrescoSQLServerDialect" as config) and the installation is still up and running.
We have MS SQL 2000 SP3 (internal version 8.00.760). But it should work on MS SQL2005 if you configure the database to be run in 8.0-compatibility mode.

Or did I get something wrong and only the upgrade scripts from 3.0b to stable do not work correctly?

Holger