|
Home > Archive > MS SQL Server > March 2005 > RE: SQL Server 2000 on Windows Server 2003
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
RE: SQL Server 2000 on Windows Server 2003
|
|
|
| How are you signing into the database. That is, if your EM id is not a system
administrator, you will probably only see the databases for which you have
clearance.
Try signing on as SA.
"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?
>
>
>
| |
|
| I think what happened was that when I installed service packs for SQL
Server, it created another instance of it. So, I ended up having 2
instances.
"jrpm" <jrpm@discussions.microsoft.com> wrote in message
news:4201C6CC-20F4-40D2-A718- 6768EA705A59@microso
ft.com...
> How are you signing into the database. That is, if your EM id is not a
system[color=darkred
]
> administrator, you will probably only see the databases for which you have
> clearance.
>
> Try signing on as SA.
>
> "df" wrote:
>
SQL[color=darkred]
in[color=darkred]
work[color=darkred]
Enterprise[color=dar
kred]
|
|
|
|
|