|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Can we connect?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 First of all, a named instance is referred to as <network address>\<instance name>. Also, 1434 is
the port resolution port, not the port where the data travels over. On my machine, for instance, I have a named instance named Test. My IP is 192.168.0.2. O can create alias in two ways. Option 1, dynamic post number resolution (which uses port 1434): Server Alias: MyInstance Server Name: 192.168.0.2\Test Dynamically determine port checked If you want to hard wire the port number, you first need to find out what port number the instance is using. Do that using Server Network Utility. In my case, I have 1038. Option 1, hard wire port number (doesn't use port 1434): Server Alias: MyInstance Server Name: 192.168.0.2\Test Dynamically determine port unhecked: 1038 -- Show quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ Blog: http://solidqualitylearning.com/blogs/tibor/ "Rogers" <Rog***@discussions.microsoft.com> wrote in message news:BC25B59E-7403-47BD-84A5-B1C684BCF9C0@microsoft.com... > 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 first of thanks for your reply... I did the same thing I have failed to
connect throught that instance but I can successfully connect through default instance of remote machine... Thanks Show quote "Tibor Karaszi" wrote: > First of all, a named instance is referred to as <network address>\<instance name>. Also, 1434 is > the port resolution port, not the port where the data travels over. On my machine, for instance, I > have a named instance named Test. My IP is 192.168.0.2. O can create alias in two ways. > > Option 1, dynamic post number resolution (which uses port 1434): > Server Alias: MyInstance > Server Name: 192.168.0.2\Test > Dynamically determine port checked > > > If you want to hard wire the port number, you first need to find out what port number the instance > is using. Do that using Server Network Utility. In my case, I have 1038. > > Option 1, hard wire port number (doesn't use port 1434): > Server Alias: MyInstance > Server Name: 192.168.0.2\Test > Dynamically determine port unhecked: 1038 > > -- > Tibor Karaszi, SQL Server MVP > http://www.karaszi.com/sqlserver/default.asp > http://www.solidqualitylearning.com/ > Blog: http://solidqualitylearning.com/blogs/tibor/ > > > "Rogers" <Rog***@discussions.microsoft.com> wrote in message > news:BC25B59E-7403-47BD-84A5-B1C684BCF9C0@microsoft.com... > > 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 > > Can you post, in the format I posted, what you specified for each option in Client Network Utility?
-- Show quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ Blog: http://solidqualitylearning.com/blogs/tibor/ "Rogers" <Rog***@discussions.microsoft.com> wrote in message news:69616FE5-C59D-41C0-A877-0329EEF39B07@microsoft.com... > first of thanks for your reply... I did the same thing I have failed to > connect throught that instance but I can successfully connect through default > instance of remote machine... > > Thanks > > "Tibor Karaszi" wrote: > >> First of all, a named instance is referred to as <network address>\<instance name>. Also, 1434 is >> the port resolution port, not the port where the data travels over. On my machine, for instance, >> I >> have a named instance named Test. My IP is 192.168.0.2. O can create alias in two ways. >> >> Option 1, dynamic post number resolution (which uses port 1434): >> Server Alias: MyInstance >> Server Name: 192.168.0.2\Test >> Dynamically determine port checked >> >> >> If you want to hard wire the port number, you first need to find out what port number the >> instance >> is using. Do that using Server Network Utility. In my case, I have 1038. >> >> Option 1, hard wire port number (doesn't use port 1434): >> Server Alias: MyInstance >> Server Name: 192.168.0.2\Test >> Dynamically determine port unhecked: 1038 >> >> -- >> Tibor Karaszi, SQL Server MVP >> http://www.karaszi.com/sqlserver/default.asp >> http://www.solidqualitylearning.com/ >> Blog: http://solidqualitylearning.com/blogs/tibor/ >> >> >> "Rogers" <Rog***@discussions.microsoft.com> wrote in message >> news:BC25B59E-7403-47BD-84A5-B1C684BCF9C0@microsoft.com... >> > 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 >> >> First I did try from the following option
Server Alias: HRInstance Server Name: 292.168.20.7\HR Dynamically determine port checked After that I registered the server through that alias but same problem SQL Server doesn't exist or access denied. Secondly I did try from the following option Server Alias: HRInstance Server Name: 292.168.20.7\HR Dynamically determine port unhecked: 1434 same problem after that as well.... SQL Server doesn't exist or access denied. any idea what I can do now ? Thanks in advance Show quote "Tibor Karaszi" wrote: > Can you post, in the format I posted, what you specified for each option in Client Network Utility? > > -- > Tibor Karaszi, SQL Server MVP > http://www.karaszi.com/sqlserver/default.asp > http://www.solidqualitylearning.com/ > Blog: http://solidqualitylearning.com/blogs/tibor/ > > > "Rogers" <Rog***@discussions.microsoft.com> wrote in message > news:69616FE5-C59D-41C0-A877-0329EEF39B07@microsoft.com... > > first of thanks for your reply... I did the same thing I have failed to > > connect throught that instance but I can successfully connect through default > > instance of remote machine... > > > > Thanks > > > > "Tibor Karaszi" wrote: > > > >> First of all, a named instance is referred to as <network address>\<instance name>. Also, 1434 is > >> the port resolution port, not the port where the data travels over. On my machine, for instance, > >> I > >> have a named instance named Test. My IP is 192.168.0.2. O can create alias in two ways. > >> > >> Option 1, dynamic post number resolution (which uses port 1434): > >> Server Alias: MyInstance > >> Server Name: 192.168.0.2\Test > >> Dynamically determine port checked > >> > >> > >> If you want to hard wire the port number, you first need to find out what port number the > >> instance > >> is using. Do that using Server Network Utility. In my case, I have 1038. > >> > >> Option 1, hard wire port number (doesn't use port 1434): > >> Server Alias: MyInstance > >> Server Name: 192.168.0.2\Test > >> Dynamically determine port unhecked: 1038 > >> > >> -- > >> Tibor Karaszi, SQL Server MVP > >> http://www.karaszi.com/sqlserver/default.asp > >> http://www.solidqualitylearning.com/ > >> Blog: http://solidqualitylearning.com/blogs/tibor/ > >> > >> > >> "Rogers" <Rog***@discussions.microsoft.com> wrote in message > >> news:BC25B59E-7403-47BD-84A5-B1C684BCF9C0@microsoft.com... > >> > 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 > >> > >> > > 1434 is not the correct port number. See my prior post. You need to determine what port it is
listening to (Server Network Utility). -- Show quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ Blog: http://solidqualitylearning.com/blogs/tibor/ "Rogers" <Rog***@discussions.microsoft.com> wrote in message news:2E9B382F-5578-4AF9-B939-7F57DFE662BA@microsoft.com... > First I did try from the following option > > Server Alias: HRInstance > Server Name: 292.168.20.7\HR > Dynamically determine port checked > > > After that I registered the server through that alias but same problem SQL > Server doesn't exist or access denied. > > Secondly I did try from the following option > > Server Alias: HRInstance > Server Name: 292.168.20.7\HR > Dynamically determine port unhecked: 1434 > > same problem after that as well.... SQL Server doesn't exist or access denied. > > any idea what I can do now ? > > Thanks in advance > > "Tibor Karaszi" wrote: > >> Can you post, in the format I posted, what you specified for each option in Client Network >> Utility? >> >> -- >> Tibor Karaszi, SQL Server MVP >> http://www.karaszi.com/sqlserver/default.asp >> http://www.solidqualitylearning.com/ >> Blog: http://solidqualitylearning.com/blogs/tibor/ >> >> >> "Rogers" <Rog***@discussions.microsoft.com> wrote in message >> news:69616FE5-C59D-41C0-A877-0329EEF39B07@microsoft.com... >> > first of thanks for your reply... I did the same thing I have failed to >> > connect throught that instance but I can successfully connect through default >> > instance of remote machine... >> > >> > Thanks >> > >> > "Tibor Karaszi" wrote: >> > >> >> First of all, a named instance is referred to as <network address>\<instance name>. Also, 1434 >> >> is >> >> the port resolution port, not the port where the data travels over. On my machine, for >> >> instance, >> >> I >> >> have a named instance named Test. My IP is 192.168.0.2. O can create alias in two ways. >> >> >> >> Option 1, dynamic post number resolution (which uses port 1434): >> >> Server Alias: MyInstance >> >> Server Name: 192.168.0.2\Test >> >> Dynamically determine port checked >> >> >> >> >> >> If you want to hard wire the port number, you first need to find out what port number the >> >> instance >> >> is using. Do that using Server Network Utility. In my case, I have 1038. >> >> >> >> Option 1, hard wire port number (doesn't use port 1434): >> >> Server Alias: MyInstance >> >> Server Name: 192.168.0.2\Test >> >> Dynamically determine port unhecked: 1038 >> >> >> >> -- >> >> Tibor Karaszi, SQL Server MVP >> >> http://www.karaszi.com/sqlserver/default.asp >> >> http://www.solidqualitylearning.com/ >> >> Blog: http://solidqualitylearning.com/blogs/tibor/ >> >> >> >> >> >> "Rogers" <Rog***@discussions.microsoft.com> wrote in message >> >> news:BC25B59E-7403-47BD-84A5-B1C684BCF9C0@microsoft.com... >> >> > 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 >> >> >> >> >> >>  |
|||||||||||||||||||||||
Other interesting topics