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
==============