Access MSSQL on diffrent port

Hi,
Im trying to access MSSQL 2000 instance on diffrent port using Query analyzer
is this possible?
--
Marcin S.You can only connect through the port SQL Server is listening on...are you
wanting to change the port at the server level?
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
news:6FD75159-C14C-435C-880C-435CA35C2818@.microsoft.com...
> Hi,
> Im trying to access MSSQL 2000 instance on diffrent port using Query
> analyzer
> is this possible?
>
> --
> Marcin S.|||Hi,
I'm running two instances om the MSSQL server och they have differnt ports
1434 and 1435
I want to remotly to connect to 192.168.0.150:1434 and/or 192.168.0.150:1435
the both servers are on separeta DMZ and the SQL connection passing thru an
Firewall. I can telnet to this ports so the fire wall is working correct by i
dont know how to specify a port in QA an in the connection string.
Marcin S.
"Kevin3NF" wrote:
> You can only connect through the port SQL Server is listening on...are you
> wanting to change the port at the server level?
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> www.experts-exchange.com - experts compete for points to answer your
> questions
>
> "Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
> news:6FD75159-C14C-435C-880C-435CA35C2818@.microsoft.com...
> > Hi,
> >
> > Im trying to access MSSQL 2000 instance on diffrent port using Query
> > analyzer
> > is this possible?
> >
> >
> > --
> > Marcin S.
>
>|||assuming you have a vpn connection established to get you on the local LAN:
tcp:192.168.0.150,1434
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
news:6914E943-4C67-43D9-A094-E4060570AFF4@.microsoft.com...
> Hi,
> I'm running two instances om the MSSQL server och they have differnt ports
> 1434 and 1435
> I want to remotly to connect to 192.168.0.150:1434 and/or
> 192.168.0.150:1435
> the both servers are on separeta DMZ and the SQL connection passing thru
> an
> Firewall. I can telnet to this ports so the fire wall is working correct
> by i
> dont know how to specify a port in QA an in the connection string.
>
> --
> Marcin S.
>
> "Kevin3NF" wrote:
>> You can only connect through the port SQL Server is listening on...are
>> you
>> wanting to change the port at the server level?
>> --
>> Kevin Hill
>> President
>> 3NF Consulting
>> www.3nf-inc.com/NewsGroups.htm
>> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
>> www.experts-exchange.com - experts compete for points to answer your
>> questions
>>
>> "Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
>> news:6FD75159-C14C-435C-880C-435CA35C2818@.microsoft.com...
>> > Hi,
>> >
>> > Im trying to access MSSQL 2000 instance on diffrent port using Query
>> > analyzer
>> > is this possible?
>> >
>> >
>> > --
>> > Marcin S.
>>|||No there is no VPN the SQL server is just separated from the webserver by a
firewall.
--
Marcin S.
"Kevin3NF" wrote:
> assuming you have a vpn connection established to get you on the local LAN:
> tcp:192.168.0.150,1434
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> www.experts-exchange.com - experts compete for points to answer your
> questions
>
> "Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
> news:6914E943-4C67-43D9-A094-E4060570AFF4@.microsoft.com...
> > Hi,
> >
> > I'm running two instances om the MSSQL server och they have differnt ports
> >
> > 1434 and 1435
> >
> > I want to remotly to connect to 192.168.0.150:1434 and/or
> > 192.168.0.150:1435
> > the both servers are on separeta DMZ and the SQL connection passing thru
> > an
> > Firewall. I can telnet to this ports so the fire wall is working correct
> > by i
> > dont know how to specify a port in QA an in the connection string.
> >
> >
> > --
> > Marcin S.
> >
> >
> > "Kevin3NF" wrote:
> >
> >> You can only connect through the port SQL Server is listening on...are
> >> you
> >> wanting to change the port at the server level?
> >>
> >> --
> >> Kevin Hill
> >> President
> >> 3NF Consulting
> >>
> >> www.3nf-inc.com/NewsGroups.htm
> >>
> >> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> >>
> >> www.experts-exchange.com - experts compete for points to answer your
> >> questions
> >>
> >>
> >> "Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
> >> news:6FD75159-C14C-435C-880C-435CA35C2818@.microsoft.com...
> >> > Hi,
> >> >
> >> > Im trying to access MSSQL 2000 instance on diffrent port using Query
> >> > analyzer
> >> > is this possible?
> >> >
> >> >
> >> > --
> >> > Marcin S.
> >>
> >>
> >>
>
>|||Hi,
this is almost working but i think i must specify the instance how to do tha
192.168.0.150\MSSQL2,1435 '
My instancename is MSSQL1 and MSSQL2
Marcin S.
"Kevin3NF" wrote:
> assuming you have a vpn connection established to get you on the local LAN:
> tcp:192.168.0.150,1434
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> www.experts-exchange.com - experts compete for points to answer your
> questions
>
> "Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
> news:6914E943-4C67-43D9-A094-E4060570AFF4@.microsoft.com...
> > Hi,
> >
> > I'm running two instances om the MSSQL server och they have differnt ports
> >
> > 1434 and 1435
> >
> > I want to remotly to connect to 192.168.0.150:1434 and/or
> > 192.168.0.150:1435
> > the both servers are on separeta DMZ and the SQL connection passing thru
> > an
> > Firewall. I can telnet to this ports so the fire wall is working correct
> > by i
> > dont know how to specify a port in QA an in the connection string.
> >
> >
> > --
> > Marcin S.
> >
> >
> > "Kevin3NF" wrote:
> >
> >> You can only connect through the port SQL Server is listening on...are
> >> you
> >> wanting to change the port at the server level?
> >>
> >> --
> >> Kevin Hill
> >> President
> >> 3NF Consulting
> >>
> >> www.3nf-inc.com/NewsGroups.htm
> >>
> >> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> >>
> >> www.experts-exchange.com - experts compete for points to answer your
> >> questions
> >>
> >>
> >> "Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
> >> news:6FD75159-C14C-435C-880C-435CA35C2818@.microsoft.com...
> >> > Hi,
> >> >
> >> > Im trying to access MSSQL 2000 instance on diffrent port using Query
> >> > analyzer
> >> > is this possible?
> >> >
> >> >
> >> > --
> >> > Marcin S.
> >>
> >>
> >>
>
>|||192.168.0.150\MSSQL2,1435 is correct.
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
news:4818A5FC-FE43-4C54-ABF9-25FA67B4C23D@.microsoft.com...
> Hi,
> this is almost working but i think i must specify the instance how to do
> tha
> 192.168.0.150\MSSQL2,1435 '
> My instancename is MSSQL1 and MSSQL2
>
> --
> Marcin S.
>
> "Kevin3NF" wrote:
>> assuming you have a vpn connection established to get you on the local
>> LAN:
>> tcp:192.168.0.150,1434
>> --
>> Kevin Hill
>> President
>> 3NF Consulting
>> www.3nf-inc.com/NewsGroups.htm
>> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
>> www.experts-exchange.com - experts compete for points to answer your
>> questions
>>
>> "Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
>> news:6914E943-4C67-43D9-A094-E4060570AFF4@.microsoft.com...
>> > Hi,
>> >
>> > I'm running two instances om the MSSQL server och they have differnt
>> > ports
>> >
>> > 1434 and 1435
>> >
>> > I want to remotly to connect to 192.168.0.150:1434 and/or
>> > 192.168.0.150:1435
>> > the both servers are on separeta DMZ and the SQL connection passing
>> > thru
>> > an
>> > Firewall. I can telnet to this ports so the fire wall is working
>> > correct
>> > by i
>> > dont know how to specify a port in QA an in the connection string.
>> >
>> >
>> > --
>> > Marcin S.
>> >
>> >
>> > "Kevin3NF" wrote:
>> >
>> >> You can only connect through the port SQL Server is listening on...are
>> >> you
>> >> wanting to change the port at the server level?
>> >>
>> >> --
>> >> Kevin Hill
>> >> President
>> >> 3NF Consulting
>> >>
>> >> www.3nf-inc.com/NewsGroups.htm
>> >>
>> >> www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area
>> >> DBAs.
>> >>
>> >> www.experts-exchange.com - experts compete for points to answer your
>> >> questions
>> >>
>> >>
>> >> "Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
>> >> news:6FD75159-C14C-435C-880C-435CA35C2818@.microsoft.com...
>> >> > Hi,
>> >> >
>> >> > Im trying to access MSSQL 2000 instance on diffrent port using Query
>> >> > analyzer
>> >> > is this possible?
>> >> >
>> >> >
>> >> > --
>> >> > Marcin S.
>> >>
>> >>
>> >>
>>