View Single Post

   
  #8 (permalink)  
Old 02-29-2008, 07:53 AM
df
 
Posts: n/a
Default Re: SQL Server 2000 and Windows Server 2003

Thanks,

I have fixed the problem. I suspect that when I installed service packs, it
created the second instance, since I did not do it explicitly. I shut it
down, and registered the original one.


"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns9629EB819DA24Yazorman@127.0.0.1...
> df (df@df.com) writes:
>> When I looked in the Windows services I see another instance of SQL
>> Server
>> running. There are the following services:
>> MSSQL$DELLSRV
>> MSSqlSever
>>
>> I have no clue how this could happen. But the question is how can I get
>> to
>> the old instance???

>
> So you have two instances of SQL Server on your machine, and you have
> connected to the one that does not have any databases.
>
> To connect to the default instance, specify "." or servername. To
> connect to the other, specify ".\DELLSRV" or "servername\DELLSRV".
>
> You might also want to check the Client Network Utility whether you
> have any aliases.
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techinf...2000/books.asp



Reply With Quote