Hi,
I need to run MSQL 6.5, 7 and 2000 on single Windows 2000 server.
Is it even possible?
Thanks, SimsasHello Simsas,
as far as I know this constallation is not possible, because the services installed by these different version doe have the same name.
Perhaps some of the experts in this forum know a way to realise it!
Greetings,
Carsten|||Yes you can have but for 6.5 or 7.0 you can only use one server instance, you need to switch between versions. And for SQL 2K only one default instance and variety of named instances.|||you won't be able to run the 6.5 along with the 7.0 as only one of them can be active at a time, I can't remember if 6.5 and 2000 can run at the same time
Is there any particular reason why you have to run all three versions at the same time on the same server? You should be able to run your 6.5 databases on 7 or 2000 in 6.5 compatability mode with little or no modification (depending on the app that's using it of course)|||thanx , i'll try
Showing posts with label single. Show all posts
Showing posts with label single. Show all posts
Friday, March 23, 2012
MSQL 6.5+7+2000>one server ?
Monday, February 20, 2012
MSDTC and SQL2000 clustered
Hi,
I'm in doubt about an installation of SQL Server 2000 (single istance hot standby) on a Win2000 Advanced Server 2 nodes cluster (2 processors per node).
I suppose MSDTC was not activated during SQL2000 setup.
Is it absolutely necessary?
Can I have problems?
In what case is it necessary?
Many thanks?Originally posted by nisant
Hi,
I'm in doubt about an installation of SQL Server 2000 (single istance hot standby) on a Win2000 Advanced Server 2 nodes cluster (2 processors per node).
I suppose MSDTC was not activated during SQL2000 setup.
Is it absolutely necessary?
Can I have problems?
In what case is it necessary?
Many thanks?
I had a problem in an active\active failover installation. MSDTC was not configured and was causing problems with the fail over function. Once I configured it as a shared resource, everything seemed fine. Hope this helps...|||True, make sure MSDTC has been started and working whenever any distributed transactions are in process.
For information refer to DB journal (http://www.databasejournal.com/features/mssql/article.php/1690901) article.
I'm in doubt about an installation of SQL Server 2000 (single istance hot standby) on a Win2000 Advanced Server 2 nodes cluster (2 processors per node).
I suppose MSDTC was not activated during SQL2000 setup.
Is it absolutely necessary?
Can I have problems?
In what case is it necessary?
Many thanks?Originally posted by nisant
Hi,
I'm in doubt about an installation of SQL Server 2000 (single istance hot standby) on a Win2000 Advanced Server 2 nodes cluster (2 processors per node).
I suppose MSDTC was not activated during SQL2000 setup.
Is it absolutely necessary?
Can I have problems?
In what case is it necessary?
Many thanks?
I had a problem in an active\active failover installation. MSDTC was not configured and was causing problems with the fail over function. Once I configured it as a shared resource, everything seemed fine. Hope this helps...|||True, make sure MSDTC has been started and working whenever any distributed transactions are in process.
For information refer to DB journal (http://www.databasejournal.com/features/mssql/article.php/1690901) article.
Subscribe to:
Posts (Atom)