I have two instances of SQL 2000 on one of our servers. I can connect to the
first instance that has the machine name and port 1434 from anywhere I want.
But when I try to connect to the second instance on the same machine with
then name of machinename\G3 from a server on a second network where UDP 1434
port is blocked by the firewall, the connection fail and the second instance
is not available. I followed this article on Microsoft knowledge base
http://support.microsoft.com/kb/265808/ where I created an alias for the G3
server on the client machine using the IP address and the assigned port
number, but that didnâ't help and I still could not connect to the server. I
basically followed those steps:
2. Configure the server alias on the client computer.
SQL Server 2000a. Start the Client Network Utility.
b. On the General tab, verify that TCP/IP appears in the list under Enabled
protocols by order.
c. Click the Alias tab, and then click Add.
d. Under Network libraries, select TCP/IP.
e. In the Server name text box, type the IP address of the server that is
running SQL Server 2005.
Note The IP address that you type here is the one that is configured to use
the TCP/IP port number.
f. Click to clear the Dynamically determine port check box, and then type
the port number of the instance of SQL Server 2005 in the Port number text
box.
g. Type a name in the Server alias text box, and then click OK.
I asked the IT department to unblock the UDP 1434 temporarily to see if I
can connect to the G3 server, and I was able to connect with no problem.
Unfortunately, they are required to block UDP 1434 so I have to deal with
that.
Does anybody have any idea that could help? Please let me know.
ThanksHi Danny
A named instance will use a dynamic port by default and UDP 1434 is used to
transmit the name of the instance name back to the client. You will need to
make the port fixed on the server and the corresponding port configured on
the client.
Check out http://support.microsoft.com/kb/287932.
John
"Danny Mansour" wrote:
> I have two instances of SQL 2000 on one of our servers. I can connect to the
> first instance that has the machine name and port 1434 from anywhere I want.
> But when I try to connect to the second instance on the same machine with
> then name of machinename\G3 from a server on a second network where UDP 1434
> port is blocked by the firewall, the connection fail and the second instance
> is not available. I followed this article on Microsoft knowledge base
> http://support.microsoft.com/kb/265808/ where I created an alias for the G3
> server on the client machine using the IP address and the assigned port
> number, but that didnâ't help and I still could not connect to the server. I
> basically followed those steps:
> 2. Configure the server alias on the client computer.
> SQL Server 2000a. Start the Client Network Utility.
> b. On the General tab, verify that TCP/IP appears in the list under Enabled
> protocols by order.
> c. Click the Alias tab, and then click Add.
> d. Under Network libraries, select TCP/IP.
> e. In the Server name text box, type the IP address of the server that is
> running SQL Server 2005.
> Note The IP address that you type here is the one that is configured to use
> the TCP/IP port number.
> f. Click to clear the Dynamically determine port check box, and then type
> the port number of the instance of SQL Server 2005 in the Port number text
> box.
> g. Type a name in the Server alias text box, and then click OK.
>
> I asked the IT department to unblock the UDP 1434 temporarily to see if I
> can connect to the G3 server, and I was able to connect with no problem.
> Unfortunately, they are required to block UDP 1434 so I have to deal with
> that.
> Does anybody have any idea that could help? Please let me know.
> Thanks
>|||One way to avoid the dependency on UDP 1434 is to specify the port number
explicitly on the connection string. So assume that the server name is
ServerA, its IP address is A.B.C.D, and the instance listens on TCP port
1234, you connect to the instance as follows:
ServerA,1234
or
A.B.C.D,1234
When you connect to an instance using the ServerName\InstanceName
convention, the client needs to retrieve the port number first, and it talks
to UDP 1434 to get the port number.
Linchi
"Danny Mansour" wrote:
> I have two instances of SQL 2000 on one of our servers. I can connect to the
> first instance that has the machine name and port 1434 from anywhere I want.
> But when I try to connect to the second instance on the same machine with
> then name of machinename\G3 from a server on a second network where UDP 1434
> port is blocked by the firewall, the connection fail and the second instance
> is not available. I followed this article on Microsoft knowledge base
> http://support.microsoft.com/kb/265808/ where I created an alias for the G3
> server on the client machine using the IP address and the assigned port
> number, but that didnâ't help and I still could not connect to the server. I
> basically followed those steps:
> 2. Configure the server alias on the client computer.
> SQL Server 2000a. Start the Client Network Utility.
> b. On the General tab, verify that TCP/IP appears in the list under Enabled
> protocols by order.
> c. Click the Alias tab, and then click Add.
> d. Under Network libraries, select TCP/IP.
> e. In the Server name text box, type the IP address of the server that is
> running SQL Server 2005.
> Note The IP address that you type here is the one that is configured to use
> the TCP/IP port number.
> f. Click to clear the Dynamically determine port check box, and then type
> the port number of the instance of SQL Server 2005 in the Port number text
> box.
> g. Type a name in the Server alias text box, and then click OK.
>
> I asked the IT department to unblock the UDP 1434 temporarily to see if I
> can connect to the G3 server, and I was able to connect with no problem.
> Unfortunately, they are required to block UDP 1434 so I have to deal with
> that.
> Does anybody have any idea that could help? Please let me know.
> Thanks
>|||Thanks a bunch for the reply.
I followed the article you sent me and configured a static port and I
configured the client machine to point to the port. Somehow this still
didn't work for me. The article mentions to set a static Port before
configuring the firewall. I wonder if I need to open the new static port on
the firewall to make it work?
Please let me know what you think.
Thanks,
Danny
"John Bell" wrote:
> Hi Danny
> A named instance will use a dynamic port by default and UDP 1434 is used to
> transmit the name of the instance name back to the client. You will need to
> make the port fixed on the server and the corresponding port configured on
> the client.
> Check out http://support.microsoft.com/kb/287932.
> John
>
> "Danny Mansour" wrote:
> > I have two instances of SQL 2000 on one of our servers. I can connect to the
> > first instance that has the machine name and port 1434 from anywhere I want.
> > But when I try to connect to the second instance on the same machine with
> > then name of machinename\G3 from a server on a second network where UDP 1434
> > port is blocked by the firewall, the connection fail and the second instance
> > is not available. I followed this article on Microsoft knowledge base
> > http://support.microsoft.com/kb/265808/ where I created an alias for the G3
> > server on the client machine using the IP address and the assigned port
> > number, but that didnâ't help and I still could not connect to the server. I
> > basically followed those steps:
> >
> > 2. Configure the server alias on the client computer.
> >
> > SQL Server 2000a. Start the Client Network Utility.
> > b. On the General tab, verify that TCP/IP appears in the list under Enabled
> > protocols by order.
> > c. Click the Alias tab, and then click Add.
> > d. Under Network libraries, select TCP/IP.
> > e. In the Server name text box, type the IP address of the server that is
> > running SQL Server 2005.
> >
> > Note The IP address that you type here is the one that is configured to use
> > the TCP/IP port number.
> > f. Click to clear the Dynamically determine port check box, and then type
> > the port number of the instance of SQL Server 2005 in the Port number text
> > box.
> > g. Type a name in the Server alias text box, and then click OK.
> >
> >
> > I asked the IT department to unblock the UDP 1434 temporarily to see if I
> > can connect to the G3 server, and I was able to connect with no problem.
> > Unfortunately, they are required to block UDP 1434 so I have to deal with
> > that.
> >
> > Does anybody have any idea that could help? Please let me know.
> >
> > Thanks
> >|||thank you for your reply. The intersting thing is that I have been trying to
connect to the second instance through the Enterprise Manager using an alias
name through the Client Network Utility where I specified the IP address and
the static port number, but I was unable to make a connection. On the other
hand, trying to connect using OSQL by doing "OSQL /E servername,port as you
suggeted works fine and I'm able to query the server. I wonder what the
difference is in the way the Enterprise Manger tries to make the connection.
I'm trying to establish replication between servers thus I need the
Enterprise Manager to be able to connect.
Please let me know what you think.
Thanks a million.
Danny
"Linchi Shea" wrote:
> One way to avoid the dependency on UDP 1434 is to specify the port number
> explicitly on the connection string. So assume that the server name is
> ServerA, its IP address is A.B.C.D, and the instance listens on TCP port
> 1234, you connect to the instance as follows:
> ServerA,1234
> or
> A.B.C.D,1234
> When you connect to an instance using the ServerName\InstanceName
> convention, the client needs to retrieve the port number first, and it talks
> to UDP 1434 to get the port number.
> Linchi
> "Danny Mansour" wrote:
> > I have two instances of SQL 2000 on one of our servers. I can connect to the
> > first instance that has the machine name and port 1434 from anywhere I want.
> > But when I try to connect to the second instance on the same machine with
> > then name of machinename\G3 from a server on a second network where UDP 1434
> > port is blocked by the firewall, the connection fail and the second instance
> > is not available. I followed this article on Microsoft knowledge base
> > http://support.microsoft.com/kb/265808/ where I created an alias for the G3
> > server on the client machine using the IP address and the assigned port
> > number, but that didnâ't help and I still could not connect to the server. I
> > basically followed those steps:
> >
> > 2. Configure the server alias on the client computer.
> >
> > SQL Server 2000a. Start the Client Network Utility.
> > b. On the General tab, verify that TCP/IP appears in the list under Enabled
> > protocols by order.
> > c. Click the Alias tab, and then click Add.
> > d. Under Network libraries, select TCP/IP.
> > e. In the Server name text box, type the IP address of the server that is
> > running SQL Server 2005.
> >
> > Note The IP address that you type here is the one that is configured to use
> > the TCP/IP port number.
> > f. Click to clear the Dynamically determine port check box, and then type
> > the port number of the instance of SQL Server 2005 in the Port number text
> > box.
> > g. Type a name in the Server alias text box, and then click OK.
> >
> >
> > I asked the IT department to unblock the UDP 1434 temporarily to see if I
> > can connect to the G3 server, and I was able to connect with no problem.
> > Unfortunately, they are required to block UDP 1434 so I have to deal with
> > that.
> >
> > Does anybody have any idea that could help? Please let me know.
> >
> > Thanks
> >|||I wonder if I need to open the new static port on
> the firewall to make it work?
Yes, whatever port SQL Server is listening on must be open in order for
clients to connect over the network.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Danny Mansour" <DannyMansour@.discussions.microsoft.com> wrote in message
news:6F17AAA9-D82F-41CB-B1DA-2AD431FC86AA@.microsoft.com...
> Thanks a bunch for the reply.
> I followed the article you sent me and configured a static port and I
> configured the client machine to point to the port. Somehow this still
> didn't work for me. The article mentions to set a static Port before
> configuring the firewall. I wonder if I need to open the new static port
> on
> the firewall to make it work?
> Please let me know what you think.
> Thanks,
> Danny
> "John Bell" wrote:
>> Hi Danny
>> A named instance will use a dynamic port by default and UDP 1434 is used
>> to
>> transmit the name of the instance name back to the client. You will need
>> to
>> make the port fixed on the server and the corresponding port configured
>> on
>> the client.
>> Check out http://support.microsoft.com/kb/287932.
>> John
>>
>> "Danny Mansour" wrote:
>> > I have two instances of SQL 2000 on one of our servers. I can connect
>> > to the
>> > first instance that has the machine name and port 1434 from anywhere I
>> > want.
>> > But when I try to connect to the second instance on the same machine
>> > with
>> > then name of machinename\G3 from a server on a second network where UDP
>> > 1434
>> > port is blocked by the firewall, the connection fail and the second
>> > instance
>> > is not available. I followed this article on Microsoft knowledge base
>> > http://support.microsoft.com/kb/265808/ where I created an alias for
>> > the G3
>> > server on the client machine using the IP address and the assigned port
>> > number, but that didn't help and I still could not connect to the
>> > server. I
>> > basically followed those steps:
>> >
>> > 2. Configure the server alias on the client computer.
>> >
>> > SQL Server 2000a. Start the Client Network Utility.
>> > b. On the General tab, verify that TCP/IP appears in the list under
>> > Enabled
>> > protocols by order.
>> > c. Click the Alias tab, and then click Add.
>> > d. Under Network libraries, select TCP/IP.
>> > e. In the Server name text box, type the IP address of the server that
>> > is
>> > running SQL Server 2005.
>> >
>> > Note The IP address that you type here is the one that is configured to
>> > use
>> > the TCP/IP port number.
>> > f. Click to clear the Dynamically determine port check box, and then
>> > type
>> > the port number of the instance of SQL Server 2005 in the Port number
>> > text
>> > box.
>> > g. Type a name in the Server alias text box, and then click OK.
>> >
>> >
>> > I asked the IT department to unblock the UDP 1434 temporarily to see if
>> > I
>> > can connect to the G3 server, and I was able to connect with no
>> > problem.
>> > Unfortunately, they are required to block UDP 1434 so I have to deal
>> > with
>> > that.
>> >
>> > Does anybody have any idea that could help? Please let me know.
>> >
>> > Thanks
>> >
Showing posts with label 2nd. Show all posts
Showing posts with label 2nd. Show all posts
Tuesday, 20 March 2012
Monday, 19 March 2012
Connect to a 2nd instance of SQL server while UDP 1434 is blocked
I have two instances of SQL 2000 on one of our servers. I can connect to the
first instance that has the machine name and port 1434 from anywhere I want.
But when I try to connect to the second instance on the same machine with
then name of machinename\G3 from a server on a second network where UDP 1434
port is blocked by the firewall, the connection fail and the second instance
is not available. I followed this article on Microsoft knowledge base
http://support.microsoft.com/kb/265808/ where I created an alias for the G3
server on the client machine using the IP address and the assigned port
number, but that didn’t help and I still could not connect to the server.
I
basically followed those steps:
2. Configure the server alias on the client computer.
SQL Server 2000a. Start the Client Network Utility.
b. On the General tab, verify that TCP/IP appears in the list under Enabled
protocols by order.
c. Click the Alias tab, and then click Add.
d. Under Network libraries, select TCP/IP.
e. In the Server name text box, type the IP address of the server that is
running SQL Server 2005.
Note The IP address that you type here is the one that is configured to use
the TCP/IP port number.
f. Click to clear the Dynamically determine port check box, and then type
the port number of the instance of SQL Server 2005 in the Port number text
box.
g. Type a name in the Server alias text box, and then click OK.
I asked the IT department to unblock the UDP 1434 temporarily to see if I
can connect to the G3 server, and I was able to connect with no problem.
Unfortunately, they are required to block UDP 1434 so I have to deal with
that.
Does anybody have any idea that could help? Please let me know.
ThanksHi Danny
A named instance will use a dynamic port by default and UDP 1434 is used to
transmit the name of the instance name back to the client. You will need to
make the port fixed on the server and the corresponding port configured on
the client.
Check out http://support.microsoft.com/kb/287932.
John
"Danny Mansour" wrote:
> I have two instances of SQL 2000 on one of our servers. I can connect to t
he
> first instance that has the machine name and port 1434 from anywhere I wan
t.
> But when I try to connect to the second instance on the same machine with
> then name of machinename\G3 from a server on a second network where UDP 14
34
> port is blocked by the firewall, the connection fail and the second instan
ce
> is not available. I followed this article on Microsoft knowledge base
> http://support.microsoft.com/kb/265808/ where I created an alias for the G
3
> server on the client machine using the IP address and the assigned port
> number, but that didn’t help and I still could not connect to the server
. I
> basically followed those steps:
> 2. Configure the server alias on the client computer.
> SQL Server 2000a. Start the Client Network Utility.
> b. On the General tab, verify that TCP/IP appears in the list under Enabl
ed
> protocols by order.
> c. Click the Alias tab, and then click Add.
> d. Under Network libraries, select TCP/IP.
> e. In the Server name text box, type the IP address of the server that is
> running SQL Server 2005.
> Note The IP address that you type here is the one that is configured to us
e
> the TCP/IP port number.
> f. Click to clear the Dynamically determine port check box, and then type
> the port number of the instance of SQL Server 2005 in the Port number text
> box.
> g. Type a name in the Server alias text box, and then click OK.
>
> I asked the IT department to unblock the UDP 1434 temporarily to see if I
> can connect to the G3 server, and I was able to connect with no problem.
> Unfortunately, they are required to block UDP 1434 so I have to deal with
> that.
> Does anybody have any idea that could help? Please let me know.
> Thanks
>|||One way to avoid the dependency on UDP 1434 is to specify the port number
explicitly on the connection string. So assume that the server name is
ServerA, its IP address is A.B.C.D, and the instance listens on TCP port
1234, you connect to the instance as follows:
ServerA,1234
or
A.B.C.D,1234
When you connect to an instance using the ServerName\InstanceName
convention, the client needs to retrieve the port number first, and it talks
to UDP 1434 to get the port number.
Linchi
"Danny Mansour" wrote:
> I have two instances of SQL 2000 on one of our servers. I can connect to t
he
> first instance that has the machine name and port 1434 from anywhere I wan
t.
> But when I try to connect to the second instance on the same machine with
> then name of machinename\G3 from a server on a second network where UDP 14
34
> port is blocked by the firewall, the connection fail and the second instan
ce
> is not available. I followed this article on Microsoft knowledge base
> http://support.microsoft.com/kb/265808/ where I created an alias for the G
3
> server on the client machine using the IP address and the assigned port
> number, but that didn’t help and I still could not connect to the server
. I
> basically followed those steps:
> 2. Configure the server alias on the client computer.
> SQL Server 2000a. Start the Client Network Utility.
> b. On the General tab, verify that TCP/IP appears in the list under Enabl
ed
> protocols by order.
> c. Click the Alias tab, and then click Add.
> d. Under Network libraries, select TCP/IP.
> e. In the Server name text box, type the IP address of the server that is
> running SQL Server 2005.
> Note The IP address that you type here is the one that is configured to us
e
> the TCP/IP port number.
> f. Click to clear the Dynamically determine port check box, and then type
> the port number of the instance of SQL Server 2005 in the Port number text
> box.
> g. Type a name in the Server alias text box, and then click OK.
>
> I asked the IT department to unblock the UDP 1434 temporarily to see if I
> can connect to the G3 server, and I was able to connect with no problem.
> Unfortunately, they are required to block UDP 1434 so I have to deal with
> that.
> Does anybody have any idea that could help? Please let me know.
> Thanks
>
first instance that has the machine name and port 1434 from anywhere I want.
But when I try to connect to the second instance on the same machine with
then name of machinename\G3 from a server on a second network where UDP 1434
port is blocked by the firewall, the connection fail and the second instance
is not available. I followed this article on Microsoft knowledge base
http://support.microsoft.com/kb/265808/ where I created an alias for the G3
server on the client machine using the IP address and the assigned port
number, but that didn’t help and I still could not connect to the server.
I
basically followed those steps:
2. Configure the server alias on the client computer.
SQL Server 2000a. Start the Client Network Utility.
b. On the General tab, verify that TCP/IP appears in the list under Enabled
protocols by order.
c. Click the Alias tab, and then click Add.
d. Under Network libraries, select TCP/IP.
e. In the Server name text box, type the IP address of the server that is
running SQL Server 2005.
Note The IP address that you type here is the one that is configured to use
the TCP/IP port number.
f. Click to clear the Dynamically determine port check box, and then type
the port number of the instance of SQL Server 2005 in the Port number text
box.
g. Type a name in the Server alias text box, and then click OK.
I asked the IT department to unblock the UDP 1434 temporarily to see if I
can connect to the G3 server, and I was able to connect with no problem.
Unfortunately, they are required to block UDP 1434 so I have to deal with
that.
Does anybody have any idea that could help? Please let me know.
ThanksHi Danny
A named instance will use a dynamic port by default and UDP 1434 is used to
transmit the name of the instance name back to the client. You will need to
make the port fixed on the server and the corresponding port configured on
the client.
Check out http://support.microsoft.com/kb/287932.
John
"Danny Mansour" wrote:
> I have two instances of SQL 2000 on one of our servers. I can connect to t
he
> first instance that has the machine name and port 1434 from anywhere I wan
t.
> But when I try to connect to the second instance on the same machine with
> then name of machinename\G3 from a server on a second network where UDP 14
34
> port is blocked by the firewall, the connection fail and the second instan
ce
> is not available. I followed this article on Microsoft knowledge base
> http://support.microsoft.com/kb/265808/ where I created an alias for the G
3
> server on the client machine using the IP address and the assigned port
> number, but that didn’t help and I still could not connect to the server
. I
> basically followed those steps:
> 2. Configure the server alias on the client computer.
> SQL Server 2000a. Start the Client Network Utility.
> b. On the General tab, verify that TCP/IP appears in the list under Enabl
ed
> protocols by order.
> c. Click the Alias tab, and then click Add.
> d. Under Network libraries, select TCP/IP.
> e. In the Server name text box, type the IP address of the server that is
> running SQL Server 2005.
> Note The IP address that you type here is the one that is configured to us
e
> the TCP/IP port number.
> f. Click to clear the Dynamically determine port check box, and then type
> the port number of the instance of SQL Server 2005 in the Port number text
> box.
> g. Type a name in the Server alias text box, and then click OK.
>
> I asked the IT department to unblock the UDP 1434 temporarily to see if I
> can connect to the G3 server, and I was able to connect with no problem.
> Unfortunately, they are required to block UDP 1434 so I have to deal with
> that.
> Does anybody have any idea that could help? Please let me know.
> Thanks
>|||One way to avoid the dependency on UDP 1434 is to specify the port number
explicitly on the connection string. So assume that the server name is
ServerA, its IP address is A.B.C.D, and the instance listens on TCP port
1234, you connect to the instance as follows:
ServerA,1234
or
A.B.C.D,1234
When you connect to an instance using the ServerName\InstanceName
convention, the client needs to retrieve the port number first, and it talks
to UDP 1434 to get the port number.
Linchi
"Danny Mansour" wrote:
> I have two instances of SQL 2000 on one of our servers. I can connect to t
he
> first instance that has the machine name and port 1434 from anywhere I wan
t.
> But when I try to connect to the second instance on the same machine with
> then name of machinename\G3 from a server on a second network where UDP 14
34
> port is blocked by the firewall, the connection fail and the second instan
ce
> is not available. I followed this article on Microsoft knowledge base
> http://support.microsoft.com/kb/265808/ where I created an alias for the G
3
> server on the client machine using the IP address and the assigned port
> number, but that didn’t help and I still could not connect to the server
. I
> basically followed those steps:
> 2. Configure the server alias on the client computer.
> SQL Server 2000a. Start the Client Network Utility.
> b. On the General tab, verify that TCP/IP appears in the list under Enabl
ed
> protocols by order.
> c. Click the Alias tab, and then click Add.
> d. Under Network libraries, select TCP/IP.
> e. In the Server name text box, type the IP address of the server that is
> running SQL Server 2005.
> Note The IP address that you type here is the one that is configured to us
e
> the TCP/IP port number.
> f. Click to clear the Dynamically determine port check box, and then type
> the port number of the instance of SQL Server 2005 in the Port number text
> box.
> g. Type a name in the Server alias text box, and then click OK.
>
> I asked the IT department to unblock the UDP 1434 temporarily to see if I
> can connect to the G3 server, and I was able to connect with no problem.
> Unfortunately, they are required to block UDP 1434 so I have to deal with
> that.
> Does anybody have any idea that could help? Please let me know.
> Thanks
>
connect to 2nd intance of SQL Server
Hi all,
I am very new to SQL world. I was wondering if someone could help me connect to a 2nd instance to a SQL server. I need to get a application that connects back to our main SQL server. This server has only 1 ip...but 2 instances, how can I get the app. to connect to the second instance. I have tried using server name\instance_name but get error...HELP!!!
Any helpwould be greatly appreciatedWhat error are you getting? Can you connect to the second instance from
Query Analyzer or Enterprise Manager?
"George" <anonymous@.discussions.microsoft.com> wrote in message
news:C499634C-3A4E-471F-94F7-C556E47F6B1A@.microsoft.com...
> Hi all,
> I am very new to SQL world. I was wondering if someone could help me
connect to a 2nd instance to a SQL server. I need to get a application that
connects back to our main SQL server. This server has only 1 ip...but 2
instances, how can I get the app. to connect to the second instance. I have
tried using server name\instance_name but get error...HELP!!!
> Any helpwould be greatly appreciated|||George wrote:
> Hi all,
> I am very new to SQL world. I was wondering if someone could help me
> connect to a 2nd instance to a SQL server. I need to get a
> application that connects back to our main SQL server. This server
> has only 1 ip...but 2 instances, how can I get the app. to connect
> to the second instance. I have tried using server name\instance_name
> but get error...HELP!!!
> Any helpwould be greatly appreciated
you dont say exactly what the application is etc, however see this link
for a vb code sample
http://61.171.118.222/netbook/sqlserver2000/adosql/adoprg01_3auq.htm
--
Br,
Mark Broadbent
mcdba , mcse+i
=============|||Make sure you choose right names.
Run osql -L to obtain the whole name of instances that you have.
Regards
---
All information provided above AS IS.
"George" <anonymous@.discussions.microsoft.com> wrote in message
news:C499634C-3A4E-471F-94F7-C556E47F6B1A@.microsoft.com...
> Hi all,
> I am very new to SQL world. I was wondering if someone could help me
connect to a 2nd instance to a SQL server. I need to get a application that
connects back to our main SQL server. This server has only 1 ip...but 2
instances, how can I get the app. to connect to the second instance. I have
tried using server name\instance_name but get error...HELP!!!
> Any helpwould be greatly appreciated|||Thank you all for the response...first off, what im tasked
to do is I have a application ERS which is a environmental
app that is housed on another sever that acts as gthe
front end for the app...the sql server houses the database
of course LOL...but the developers stated that windows
authentication would not work...so I created the 2nd
instance with a sa authentication...
Now the app. will work if I install the front piece on the
sql server in IIS. but I cannot get to run from the front
end server that also has the app. installed in IIS on it.
I hope this info helps..
PS I also remember reading that you would get the 2nd
instance to work if you enabled another IP to the
server.., Not sure how I would do that and make the 2nd
instance bind to it' Any Thought'
Thanks guys let me know. I appreciate it.
>--Original Message--
>George wrote:
>> Hi all,
>> I am very new to SQL world. I was wondering if someone
could help me
>> connect to a 2nd instance to a SQL server. I need to
get a
>> application that connects back to our main SQL server.
This server
>> has only 1 ip...but 2 instances, how can I get the
app. to connect
>> to the second instance. I have tried using server
name\instance_name
>> but get error...HELP!!!
>> Any helpwould be greatly appreciated
>you dont say exactly what the application is etc, however
see this link
>for a vb code sample
>http://61.171.118.222/netbook/sqlserver2000/adosql/adoprg0
1_3auq.htm
>--
>Br,
>Mark Broadbent
>mcdba , mcse+i
>=============>.
>|||<anonymous@.discussions.microsoft.com> wrote:
> Thank you all for the response...first off, what im tasked
> to do is I have a application ERS which is a environmental
> app that is housed on another sever that acts as gthe
> front end for the app...the sql server houses the database
> of course LOL...but the developers stated that windows
> authentication would not work...so I created the 2nd
> instance with a sa authentication...
> Now the app. will work if I install the front piece on the
> sql server in IIS. but I cannot get to run from the front
> end server that also has the app. installed in IIS on it.
> I hope this info helps..
> PS I also remember reading that you would get the 2nd
> instance to work if you enabled another IP to the
> server.., Not sure how I would do that and make the 2nd
> instance bind to it' Any Thought'
> Thanks guys let me know. I appreciate it.
> > --Original Message--
> > George wrote:
> >
> >> Hi all,
> >>
> >> I am very new to SQL world. I was wondering if someone
> could help me
> >> connect to a 2nd instance to a SQL server. I need to
> get a
> >> application that connects back to our main SQL server.
> This server
> >> has only 1 ip...but 2 instances, how can I get the
> app. to connect
> >> to the second instance. I have tried using server
> name\instance_name
> >> but get error...HELP!!!
> >>
> >> Any helpwould be greatly appreciated
> >
> > you dont say exactly what the application is etc, however
> see this link
> > for a vb code sample
> > http://61.171.118.222/netbook/sqlserver2000/adosql/adoprg0
> 1_3auq.htm
> >
> > --
> >
> > Br,
> > Mark Broadbent
> > mcdba , mcse+i
> > =============> > .
> >
Im not quite sure I am fully understanding your post, however this is
what I think you are saying..
You have a client front end application. This connects to a middleware
application which in turn connects to a sql server (which in your case
is installed as a seperate instance).
So I am guessing that you are having trouble getting the middleware app
to connect to the sql instance? If this is so, then what you could do
is create a server alias for the instance (create on the middleware app
server).
To do this open up the sql client network utility and click on the
alias tab, and Add. Create it using the network library that you are
using to connect to the SQL server.
Make sure the server alias name you create does not actually exist in
dns/wins etc since it is a "theoretical" name, the server name text box
should have the actual server\instance name in it.
Once you have configured it, test it via query anal specifying your
alias name as the connect to item. When you are happy this is working
ok you should get your middleware app to use this aliasname.
Hope all this made sense and hope it solves your prob!
--
Br,
Mark Broadbent
mcdba , mcse+i
==============
I am very new to SQL world. I was wondering if someone could help me connect to a 2nd instance to a SQL server. I need to get a application that connects back to our main SQL server. This server has only 1 ip...but 2 instances, how can I get the app. to connect to the second instance. I have tried using server name\instance_name but get error...HELP!!!
Any helpwould be greatly appreciatedWhat error are you getting? Can you connect to the second instance from
Query Analyzer or Enterprise Manager?
"George" <anonymous@.discussions.microsoft.com> wrote in message
news:C499634C-3A4E-471F-94F7-C556E47F6B1A@.microsoft.com...
> Hi all,
> I am very new to SQL world. I was wondering if someone could help me
connect to a 2nd instance to a SQL server. I need to get a application that
connects back to our main SQL server. This server has only 1 ip...but 2
instances, how can I get the app. to connect to the second instance. I have
tried using server name\instance_name but get error...HELP!!!
> Any helpwould be greatly appreciated|||George wrote:
> Hi all,
> I am very new to SQL world. I was wondering if someone could help me
> connect to a 2nd instance to a SQL server. I need to get a
> application that connects back to our main SQL server. This server
> has only 1 ip...but 2 instances, how can I get the app. to connect
> to the second instance. I have tried using server name\instance_name
> but get error...HELP!!!
> Any helpwould be greatly appreciated
you dont say exactly what the application is etc, however see this link
for a vb code sample
http://61.171.118.222/netbook/sqlserver2000/adosql/adoprg01_3auq.htm
--
Br,
Mark Broadbent
mcdba , mcse+i
=============|||Make sure you choose right names.
Run osql -L to obtain the whole name of instances that you have.
Regards
---
All information provided above AS IS.
"George" <anonymous@.discussions.microsoft.com> wrote in message
news:C499634C-3A4E-471F-94F7-C556E47F6B1A@.microsoft.com...
> Hi all,
> I am very new to SQL world. I was wondering if someone could help me
connect to a 2nd instance to a SQL server. I need to get a application that
connects back to our main SQL server. This server has only 1 ip...but 2
instances, how can I get the app. to connect to the second instance. I have
tried using server name\instance_name but get error...HELP!!!
> Any helpwould be greatly appreciated|||Thank you all for the response...first off, what im tasked
to do is I have a application ERS which is a environmental
app that is housed on another sever that acts as gthe
front end for the app...the sql server houses the database
of course LOL...but the developers stated that windows
authentication would not work...so I created the 2nd
instance with a sa authentication...
Now the app. will work if I install the front piece on the
sql server in IIS. but I cannot get to run from the front
end server that also has the app. installed in IIS on it.
I hope this info helps..
PS I also remember reading that you would get the 2nd
instance to work if you enabled another IP to the
server.., Not sure how I would do that and make the 2nd
instance bind to it' Any Thought'
Thanks guys let me know. I appreciate it.
>--Original Message--
>George wrote:
>> Hi all,
>> I am very new to SQL world. I was wondering if someone
could help me
>> connect to a 2nd instance to a SQL server. I need to
get a
>> application that connects back to our main SQL server.
This server
>> has only 1 ip...but 2 instances, how can I get the
app. to connect
>> to the second instance. I have tried using server
name\instance_name
>> but get error...HELP!!!
>> Any helpwould be greatly appreciated
>you dont say exactly what the application is etc, however
see this link
>for a vb code sample
>http://61.171.118.222/netbook/sqlserver2000/adosql/adoprg0
1_3auq.htm
>--
>Br,
>Mark Broadbent
>mcdba , mcse+i
>=============>.
>|||<anonymous@.discussions.microsoft.com> wrote:
> Thank you all for the response...first off, what im tasked
> to do is I have a application ERS which is a environmental
> app that is housed on another sever that acts as gthe
> front end for the app...the sql server houses the database
> of course LOL...but the developers stated that windows
> authentication would not work...so I created the 2nd
> instance with a sa authentication...
> Now the app. will work if I install the front piece on the
> sql server in IIS. but I cannot get to run from the front
> end server that also has the app. installed in IIS on it.
> I hope this info helps..
> PS I also remember reading that you would get the 2nd
> instance to work if you enabled another IP to the
> server.., Not sure how I would do that and make the 2nd
> instance bind to it' Any Thought'
> Thanks guys let me know. I appreciate it.
> > --Original Message--
> > George wrote:
> >
> >> Hi all,
> >>
> >> I am very new to SQL world. I was wondering if someone
> could help me
> >> connect to a 2nd instance to a SQL server. I need to
> get a
> >> application that connects back to our main SQL server.
> This server
> >> has only 1 ip...but 2 instances, how can I get the
> app. to connect
> >> to the second instance. I have tried using server
> name\instance_name
> >> but get error...HELP!!!
> >>
> >> Any helpwould be greatly appreciated
> >
> > you dont say exactly what the application is etc, however
> see this link
> > for a vb code sample
> > http://61.171.118.222/netbook/sqlserver2000/adosql/adoprg0
> 1_3auq.htm
> >
> > --
> >
> > Br,
> > Mark Broadbent
> > mcdba , mcse+i
> > =============> > .
> >
Im not quite sure I am fully understanding your post, however this is
what I think you are saying..
You have a client front end application. This connects to a middleware
application which in turn connects to a sql server (which in your case
is installed as a seperate instance).
So I am guessing that you are having trouble getting the middleware app
to connect to the sql instance? If this is so, then what you could do
is create a server alias for the instance (create on the middleware app
server).
To do this open up the sql client network utility and click on the
alias tab, and Add. Create it using the network library that you are
using to connect to the SQL server.
Make sure the server alias name you create does not actually exist in
dns/wins etc since it is a "theoretical" name, the server name text box
should have the actual server\instance name in it.
Once you have configured it, test it via query anal specifying your
alias name as the connect to item. When you are happy this is working
ok you should get your middleware app to use this aliasname.
Hope all this made sense and hope it solves your prob!
--
Br,
Mark Broadbent
mcdba , mcse+i
==============
Sunday, 11 March 2012
Connect from Databases in 1st Instance to Databases in 2nd Instance
This is the scenario. Is it possible to create views or something (like Oracle DB Links) in a database in Instance 1 which can show data from another database in 2nd Instance ?
I want to do this to create reports.you want to create a linked server with sp_addlinkedserver|||thanks. it worked.
I want to do this to create reports.you want to create a linked server with sp_addlinkedserver|||thanks. it worked.
Subscribe to:
Posts (Atom)