can we connect?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rogers - 14 Jul 2005 16:34 GMT

can we connect named instance through IP like in the network utility I just
defined the IP of the server where the named instance installed and define
the port....

Client Netowork Utility > Alias >

Alias: MyServer
Server: 209.45.23.55
Port : 1434
Protocol: TCP/IP

any thing else I need to do for connecting this... I did the above stuff but
I had failed to connect but why I can connect the default instance.... please
guide me..

Thanks and I would highly appreciate if your prompt reply

thanks and have a great day

Reply to this Message

Hari Prasad - 14 Jul 2005 22:13 GMT

Hi,

Open the SQL Server error log under the folder
SQL_Server_installation_path>\MSSQL$instance_name\LOG folder to make sure
that the SQL Server named instance runs well and to find the TCP port which
this named instance is listening.

As well as using Server network utility verify TCP/IP protocol is enabled.

Get the SQL Server name from Error log and use that name to connect from
query analyzer

Thanks
Hari
SQL Server MVP

> can we connect named instance through IP like in the network utility I
> just
[quoted text clipped - 17 lines]
>
> thanks and have a great day

Reply to this Message

Rogers - 15 Jul 2005 17:38 GMT

First of all Hari, thanks for your reply.... I can easily connect the named
instance on that same machine ... I am trying to connect that named instance
through my client machine and facing this problem...

> Hi,
>
[quoted text clipped - 33 lines]
> >
> > thanks and have a great day

Reply to this Message