instance of sql server

From: "David" <david_vcp@xxxxxxxxxxx>
Date: Sat, 22 Apr 2006 20:54:36 -0700

I am learning SQL Server 2005 and I was told to install a second instance of
SQL Server 2005 on my machine. How can I install a second instance of SQL
Server 2005 on my machine

I already installed SQL Server 2005, I guess this is my first instance. To
install a second instance, do I just run setup again?

.

Follow-Ups:
- Re: instance of sql server
  - From: Dan Guzman

Prev by Date: Re: Order by in a INSERT INTO..SELECT
Next by Date: Re: instance of sql server
Previous by thread: Search Between Times
Next by thread: Re: instance of sql server
Index(es):
- Date
- Thread

Relevant Pages

Re: How to Convert from Active/Passive SQL Cluster to Active/Active SQL Cluster
... ..The second instance would be a named instance ... Run install again, ... >the same IP, name, disks, or group as the first ... >on the network as a completely different SQL server. ...
(microsoft.public.sqlserver.clustering)
Setup cannot verify/grant logon as service right to the SQL Server service logon account: 2453
... We are trying to install a second instance of SQL Server 2000 standard ... Setup cannot verify/grant logon as service right to the SQL Server ... service logon account: 2453 ...
(microsoft.public.sqlserver.setup)
Re: multiple instances in 1 cluster pair (please advise)
... the second instance will be a named instance. ... Columnist, SQL Server Professional ... the DBA dont know how to install a additional instance over the ...
(microsoft.public.sqlserver.clustering)
Re: Changing cluster configuration
... instance PER CLUSTER. ... The second instance you install will likely be a NAMED INSTANCE. ... The virtual server name you choose for your second instance MUST BE UNIQUE, ... Multiple Instances of SQL Server ...
(microsoft.public.sqlserver.clustering)
MSDE 2000 SP4 install gets to very end then rolls it all back
... On most machines my msde install goes fine. ... exuisting SQL server. ... Starting custom action SaveSqlServerServiceStates() ... Action start 14:23:53: RegisterClassInfo. ...
(microsoft.public.sqlserver.setup)