Re: second instance of Sql Server 2000

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

From: oj (nospam_ojngo_at_home.com)
Date: 04/21/04 

Date: Tue, 20 Apr 2004 17:12:05 -0700

Frank,

What's the error message? How did you install the second instance?
This article might help:
http://msdn.microsoft.com/library/en-us/instsql/in_overview_0v3l.asp 

-- 
-oj
http://www.rac4sql.net
"Frank Dulk" <fdulk@bol.com.br> wrote in message
news:OHmqSinJEHA.628@TK2MSFTNGP11.phx.gbl...
> I installed a second instance of Sql Server 2000 in a machine with WinXP
> Professional.
>
> I followed the instructions of the book Dominating SQL Server 2000 - the
> Bible. Gundeloy.
>
> But when I rotate the sql server it usually works with the instance
pattern,
> however doesn't appear anything of the second instance.
>
> Does anybody know me the one to say what to do to work with the two
> instances?
>
> The reason of having two instances is to test the replication using an
only
> one it conspires.
>
>

Relevant Pages

  • 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)
  • instance of sql server
    ... 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 ...
    (comp.databases.ms-sqlserver)
  • Re: Restore registry from within a new instance of Win2k
    ... >> If you want to backup a few steps to what happened and exactly ... When I did the original install, ... > I'm presently running a second instance of Win2kProSP4 with all ... It does seem that better preparation in advance (eg registry backups) ...
    (microsoft.public.win2000.registry)
  • 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)
  • Re: Restore registry from within a new instance of Win2k
    ... get a stable second instance working, install my antivirus, and then hunt ... When I did the original install, I was somehow directed to drives for the ... I'm presently running a second instance of Win2kProSP4 with all its updates. ... Checked by AVG anti-virus system. ...
    (microsoft.public.win2000.registry)