We are planning to migrate Tessitura to a new virtual server environment shortly.
My question is: will Tessitura/SQL Server 2005 run in a Windows Server 2008 environment?
Thanks,
- Blair
From the Microsoft SQL server site:
In an effort to provide customers with more secure products, Microsoft Windows Server 2008 and Microsoft Windows Vista are supported by SQL Server 2005 Express Edition Service Pack 1 (SP1), and for all other editions will be supported by SQL Server 2005 Service Pack 2 (SP2) or later when it becomes available. Earlier versions of SQL Server, including SQL Server 2000 (all editions including Desktop Engine edition, a.k.a MSDE), SQL Server 7.0, and SQL Server 6.5, will not be supported on Windows Server 2008 or Windows Vista. Customers running applications with these earlier versions of SQL Server should consider evaluating and upgrading to SQL Server 2005, which was designed to take advantage of the upcoming security and performance enhancements in the operating environment.
SQL Server 2005 requires Microsoft SQL Server 2005 Service Pack 2 (SP2) to run on Windows Server 2008 and Windows Vista SP1. You must first install the full release version of SQL Server 2005 before you can apply SP2. For more information about installing SQL Server Express SP2, see the SQL Server 2005 Express Edition SP2 Readme.
So in short. Make sure you immediately update to SQL Server 2005 SP 2 after you perform the install.
-Rich
Are you asking if Tess will run on W2K3 VM on Hyper-V (i.e. 2008) or if it will run on a W2K8 host OS in another VM platform?
I have had very little trouble with Hyper-V (I have 8 VM's running right now and love it) - Windows 2008 can be a bit stickier, but it isn't too bad. You just have to be a little more deliberate with enabling services and roles.
Thanks guys.
We installed Server 2008 and SQL Server 2005 sp2 and have had no problems so far.