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