August 4, 2003 at 3:21 am
I urgently need to know what the disadvantages/problems are when running an instance of 7 and 2000 on the same machine. Has anybody got practical experience in this? I know that one should keep memory sharing in mind, but what else can cause problems?
August 4, 2003 at 4:57 am
I've used this configuration many times especially when upgrading SQL Server 7.0 to SQL Server 2000. You need the install 7.0 as the default instance and install 2000 as a named instance.
The only gotcha I've come across was with SQLMail. If you first setup SQLMail with SQL Server 7.0 you'll find that SQLMail will no longer work in SQL Server 2000 if you remove the 7.0 installation.
Joseph
August 6, 2003 at 8:08 am
You may also want to note that the SQL Server 2000 instance will not run on the default port. (1433) Depending upon your network configuration, you may be required to specifically denote the port number in any client connection strings, particularly if your systems operate across multiple subnets.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply