Access to SQL Express connection string

I need to hardcode my TCP port to a SQL Server Express named instance. You guys have any examples I could see. I keep getting an error when I try to connect:

Run-time error 2147467259 BBNETLIB connection open parse connection paramaters, invalid connection. I'm trying to connect to a local instance on a Windows 2003 server.

Please post your connection string.|||

CONNECTION=Provider=SQLOLEDB;Data Source=SQCTLxp1\C1SQLEXPRESS;User ID=sa;Password=!!Gulpp1!!;Initial Catalog=@.DBNAME;

I removed the semicolon at the end of the connection string and it worked. Thank You.

Access to SQL Express connection string

I need to hardcode my TCP port to a SQL Server Express named instance. You guys have any examples I could see. I keep getting an error when I try to connect:

Run-time error 2147467259 BBNETLIB connection open parse connection paramaters, invalid connection. I'm trying to connect to a local instance on a Windows 2003 server.

Please post your connection string.|||

CONNECTION=Provider=SQLOLEDB;Data Source=SQCTLxp1\C1SQLEXPRESS;User ID=sa;Password=!!Gulpp1!!;Initial Catalog=@.DBNAME;

I removed the semicolon at the end of the connection string and it worked. Thank You.

Access MSSQL on diffrent port

Hi,
Im trying to access MSSQL 2000 instance on diffrent port using Query analyze
r
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:
>

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:

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