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...
>
>
|||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...[vbcol=seagreen]
> 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:
|||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,
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...
>
>
|||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...[vbcol=seagreen]
> 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: