12-19-2009 05:58 AM
Anyone have experience installing SQL 2005 Express into a Server currently configured with SQL 2008 Server?
I have a remote customer who just purchased 10 licenses of ACT! 2010 Premium, and then just before the installation the IT team notified me that they'd like to use their existing SQL 2008 Server licensing.
I don't mind manually creating the ACT7 instance on the server, but I'd like to avoid having to install SQL Express 2008 on all the workstations, which I understand to require a lot more overhead, and involve many reboots - which for a remote setup could be irritating to me and costly to the customer.
My initial notion was to install SQL Express 2005 onto the Server, which I understood could co-exist, but I wondered if anyone had experience with this process. For instance, would SQL Server 2008 have to be uninstalled beforehand, and then re-installed after Express is setup?
12-21-2009 06:52 PM
Microsoft say that both 2005 and 2008 versions of SQL can coexist on the same PC.
I thought this might also be useful for you: http://blog.glcomputing.com.au/2009/09/which-ms-sql-versions-should-you-use.html