Re: SQL 2005 as a new instance on a SQL 2000 machine

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Skc wrote:
I have a Server running Windows 2003 Server with SQL2000 installed as a Default instance. I now need to install SQL2005.

I have run the setup, but I have stopped continuing with the install. I noticed that it has created a new directory in C:\Program Files\Microsoft SQL Server\90 which I assume is for SQL2005?

Furthermore, I have named my SQL 2005 instance "sql05_on_sql02" as the machine it sits on is called SQL02.

I want to continue to run SQL2000 as well as SQL2005 - so i need advise on how to continue with the installation wizard so that I have both instances running.

Thanks,

s
You just move on with the installation. The install program can see that there are a SQL2000 default instance and will install SQL2005 as a named instance.


--
Regards
Steen Schlüter Persson
Databaseadministrator / Systemadministrator

Relevant Pages

  • RE: Problems upgrading SQL MSDE for Sharepoint
    ... I used Registry Editor to delete PendingFileRenameOperations in the ... I restarted the Server and tried to install SQL ... Press Retry to continue installation or Cancel to exit setup. ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL Server 2005 Cluster Setup Quiz
    ... Setup is supposed to install client tools on all nodes. ... Microsoft SQL Server MVP ... the first instance on the cluster. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Adding a server instance to SQL 2005
    ... The OEM SQL is certainly hard wired to the one named instance, ... SQL 2005 from a set of SQL CD's included in the package, ... the OEM SQL engine in the medical billing installation. ... and no way to specify a different instance if I install it again. ...
    (microsoft.public.sqlserver.tools)
  • Re: how do I change the user install wizard to create user folder in different location?
    ... Some people read the instructions in such a way that they install both a new ... instance of sql, ... Never slight the SBS wizards. ... I reinstalled from scratch using the Dell OpenManage Server ...
    (microsoft.public.windows.server.sbs)
  • Re: Unable to install 64bit SQL 2005 on Windows 2008 Cluster
    ... cluster installation of SQL. ... All of the database files are on the SAN share. ... Below are the logs from the install. ... SELECT `Action`,`Type`,`Source`,`Target`, NULL, `ExtendedType` FROM ...
    (microsoft.public.sqlserver.clustering)