topic Running Alfresco 4.2.1 on MS SQL Server 2008 R2: any experiences? in Alfresco Archive

Running Alfresco 4.2.1 on MS SQL Server 2008 R2: any experiences?

mpeters — Thu, 22 May 2014 09:40:35 GMT

Hello there,wer are currently Running Alfresco 4.1.6 (on Windows 2008 Server) with SQL Server 2008 R2 as database and would like to upgrade to Alfresco 4.2.1..Unfortunately Alfresco discontinued support of MS SQL

Re: Running Alfresco 4.2.1 on MS SQL Server 2008 R2: any experiences?

mrogers — Thu, 22 May 2014 09:56:00 GMT

Its unlikely to have changed that much between 4.1 and 4.2 so use the same driver as you do for 4.1.

The problem is that it will not have been tested with that old version of SQL server, AFAIK there are no known issues.

Re: Running Alfresco 4.2.1 on MS SQL Server 2008 R2: any experiences?

mpeters — Tue, 27 May 2014 06:54:02 GMT

Hello Mark,

thanks for sharing your point of view.

Kind regards
Markus

Re: Running Alfresco 4.2.1 on MS SQL Server 2008 R2: any experiences?

fariq — Thu, 03 Dec 2015 11:01:23 GMT

Hi,

I'm using Community version 5d. Install in windows server 2008 R2 and plan to use sql server DB in separate box.

I'm follow the instruction given here: http://docs.alfresco.com/5.0/tasks/sqlserver-config.html

Once done when I try to login it say the ID was not authorize or alfresco was currently not available.

Please help

Re: Running Alfresco 4.2.1 on MS SQL Server 2008 R2: any experiences?

mrogers — Thu, 03 Dec 2015 11:33:04 GMT

In future please post your log files. The error would be clear.

However this is probably that SQL server is not supported (won't work) on alfresco community. There may be a community add on for this, have you installed it?