I have RMS server on it SQL 2000 And MS Dynamics GP server on it SQL 2005 I need to make clustering using the two servers and just install SQL 2005 engine
So can i use SQL 2005 engine with RMS (Store & HQ) DB? If I can ,from where can i get the MSDE 2005 to install on the stores? And is it recommended to make RMS & GP on the same server?
I have RMS server on it SQL 2000 And MS Dynamics GP server on it SQL 2005 I need to make clustering using the two servers and just install SQL 2005 engine
So can i use SQL 2005 engine with RMS (Store & HQ) DB? If I can ,from where can i get the MSDE 2005 to install on the stores? And is it recommended to make RMS & GP on the same server?
is 1.3.1007.
If you're talking about creating a failover cluster for SQL Server, you don't need SQL Express, you need SQL Server 2005 ENTERPRISE Edition. You also need some serious hardware including an external storage array that will be shared by the two servers in the cluster. Clustering is a non-trivial exercise...
You can download SQL Server Express and find more about feature differences between editions at:
Glenn Adams Tiber Creek C> Eng,
Have something to add? Share your thoughts — no account required.
Ask the community — no account required