Re: SQL Server 2000 and Windows Server 2003 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???
"Aquila Deus" <aquila.deus@gmail.com> wrote in message
news:1112170808.553461.149460@f14g2000cwb.googlegr oups.com...
> df wrote:
>> I have several database on a Windows Server 2003. I re-registered
> this SQL
>> server, which is local, and after that I cannot see any of the
> databases in
>> the Enterprise Manager. The databases still work, since my
> applications work
>> fine. I have no clue how can I make these databases visible in
> Enterprise
>> Manager. I tried registering this SQL Server in Enterprise Manager
> under
>> Windows accounts and SQL Server accounts. Nothing works.
>> Can anybody help?
>
> The account you use in Enterprse Manager probably has no admin
> permission. Did you try "sa"? If your SQL Server doesn't allow SQL
> login you need to RTFM and enable it.
> |