How to add a named instance of sql server to EM?

I got an app that installed a named instance of MSDE instead of including
its databases in my existing SQl server instance. I would like to be able to
manage the databases and view the table structures of this app in Enterprise
manager. How can I include that named instance and its tables etc.. in my
SQL server Enterprise manager?
Thanks for any help,
BobBob,
Try registering the SQL Server instance using computername\instancename.
HTH
Jerry
"Bob" <bdufour@.sgiims.com> wrote in message
news:%23TdlkDDyFHA.2500@.TK2MSFTNGP10.phx.gbl...
>I got an app that installed a named instance of MSDE instead of including
>its databases in my existing SQl server instance. I would like to be able
>to manage the databases and view the table structures of this app in
>Enterprise manager. How can I include that named instance and its tables
>etc.. in my SQL server Enterprise manager?
> Thanks for any help,
> Bob
>|||Thanks but does not work, I get a does not exist or acces denied when I try
to register it. I'm set up to use mixed mode authentication and use the
system account to login and I am sa. but I can't seem to access that
instance of Sql server.
Any othetr way anyone can think of?
Thanks for your help.
Bob
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:u9W30aDyFHA.596@.TK2MSFTNGP12.phx.gbl...
> Bob,
> Try registering the SQL Server instance using computername\instancename.
> HTH
> Jerry
> "Bob" <bdufour@.sgiims.com> wrote in message
> news:%23TdlkDDyFHA.2500@.TK2MSFTNGP10.phx.gbl...
>>I got an app that installed a named instance of MSDE instead of including
>>its databases in my existing SQl server instance. I would like to be able
>>to manage the databases and view the table structures of this app in
>>Enterprise manager. How can I include that named instance and its tables
>>etc.. in my SQL server Enterprise manager?
>> Thanks for any help,
>> Bob
>>
>|||Are you connecting across a network? Did you try to log onto
the box and connect?
Check the error logs from the MSDE instance from when it
started up to see what protocol it is listening on - if it's
just shared memory, you can't connect to it over a network.
In that case, you need to enable TCP/IP.
-Sue
On Mon, 3 Oct 2005 13:39:08 -0400, "Bob"
<bdufour@.sgiims.com> wrote:
>Thanks but does not work, I get a does not exist or acces denied when I try
>to register it. I'm set up to use mixed mode authentication and use the
>system account to login and I am sa. but I can't seem to access that
>instance of Sql server.
>Any othetr way anyone can think of?
>Thanks for your help.
>Bob
>"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
>news:u9W30aDyFHA.596@.TK2MSFTNGP12.phx.gbl...
>> Bob,
>> Try registering the SQL Server instance using computername\instancename.
>> HTH
>> Jerry
>> "Bob" <bdufour@.sgiims.com> wrote in message
>> news:%23TdlkDDyFHA.2500@.TK2MSFTNGP10.phx.gbl...
>>I got an app that installed a named instance of MSDE instead of including
>>its databases in my existing SQl server instance. I would like to be able
>>to manage the databases and view the table structures of this app in
>>Enterprise manager. How can I include that named instance and its tables
>>etc.. in my SQL server Enterprise manager?
>> Thanks for any help,
>> Bob
>>
>>
>