Sunday, February 19, 2012

Connecting from a remote Enterprise Manager

I have installed MSDE2000A and it is working perfectly on the local machine,
but how do I connect from a remote Enterprise Manager? I keep on getting the
message that either sql does not exist or access denied. How do I fix this?
PLEASE HELP
Hi,
Using client network utility (cliconfg.exe) create a new Alias Specifying IP
Address and port number in machine which has Enterprise manager.
use this ALIAS name to register.
Thanks
Hari
SQL Server MVP
"cwsjnr" <cwsjnr@.discussions.microsoft.com> wrote in message
news:443CB7EF-4F5B-4309-9E85-96D6B7347D62@.microsoft.com...
>I have installed MSDE2000A and it is working perfectly on the local
>machine,
> but how do I connect from a remote Enterprise Manager? I keep on getting
> the
> message that either sql does not exist or access denied. How do I fix
> this?
> PLEASE HELP
|||cwsjnr wrote:
> I have installed MSDE2000A and it is working perfectly on the local machine,
> but how do I connect from a remote Enterprise Manager? I keep on getting the
> message that either sql does not exist or access denied. How do I fix this?
> PLEASE HELP
Use SVRNETCN.exe, and by default it's located in C:\Program
Files\Microsoft SQL Server\80\Tools\Binn. Set the network protocol (I
enable TCP/IP) that you require. Restart MSDE and you should be able to
connect.

No comments:

Post a Comment