Connecting to SQL 2005 Server via VPN

Hi all,
I am unable to connect to SQL2005 server using the Management Studio. i can
however connect to SQL2000 using EM. Has anyone else encoutered this issue?
if so could you please share the solution? what is ti that i need to enable
on the firewall?
Thanks
JoresIs SQL Server 2005 enabled for remote connections?
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"joresm" <joresm@.hotmail.com> wrote in message
news:ODgXkoKaGHA.1220@.TK2MSFTNGP02.phx.gbl...
> Hi all,
> I am unable to connect to SQL2005 server using the Management Studio. i
> can however connect to SQL2000 using EM. Has anyone else encoutered this
> issue? if so could you please share the solution? what is ti that i need
> to enable on the firewall?
> Thanks
> Jores
>|||Yes, it is enabled and the Browser sevice is also running. i canconnect to
it using the query analyzer. the only problem is with Management studio.
Thanks
Jores
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:uBvNIgLaGHA.1348@.TK2MSFTNGP05.phx.gbl...
> Is SQL Server 2005 enabled for remote connections?
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "joresm" <joresm@.hotmail.com> wrote in message
> news:ODgXkoKaGHA.1220@.TK2MSFTNGP02.phx.gbl...
>> Hi all,
>> I am unable to connect to SQL2005 server using the Management Studio. i
>> can however connect to SQL2000 using EM. Has anyone else encoutered this
>> issue? if so could you please share the solution? what is ti that i need
>> to enable on the firewall?
>> Thanks
>> Jores
>|||Hi I have experienced this problem also. Spent best part of a day trying to
resolve this to no avail. We have a VPN connection to our data center. The
database server has an instance of SQL 2000 which runs fine locally and
remotely from my desk. Recently we installed SQL 2005 and want to migrate
stuff to this new named instance. I can connect to the database fine locally
(on the database server itself and from other colocated machines (via
ADO.net). However I cannot access SQL 2005 over the VPN connection using
either ADO.net test app or SQL Management Studio. Is there some kind of port
blocking going on?
I don't know anything about Named Pipes, but I've tried the SQL
Configuration tool as suggested in some articles and have tried setting the
port to 1433 and turning of SQL 2000 to no avail. Would the VPN somehow be
blocking some ports - it appears that way, but my administrator assures me
that I should have full spectrum of ports available. WHATS GOING ON' Is the
SQL browser getting blocked or what? What button do I need to push to get
access to my database server from my development machine located over the
VPN?
Thanks Rob
"joresm" wrote:
> Yes, it is enabled and the Browser sevice is also running. i canconnect to
> it using the query analyzer. the only problem is with Management studio.
> Thanks
> Jores
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:uBvNIgLaGHA.1348@.TK2MSFTNGP05.phx.gbl...
> > Is SQL Server 2005 enabled for remote connections?
> >
> > --
> > Hilary Cotter
> > Director of Text Mining and Database Strategy
> > RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> >
> > This posting is my own and doesn't necessarily represent RelevantNoise's
> > positions, strategies or opinions.
> >
> > Looking for a SQL Server replication book?
> > http://www.nwsu.com/0974973602.html
> >
> > Looking for a FAQ on Indexing Services/SQL FTS
> > http://www.indexserverfaq.com
> >
> >
> >
> > "joresm" <joresm@.hotmail.com> wrote in message
> > news:ODgXkoKaGHA.1220@.TK2MSFTNGP02.phx.gbl...
> >> Hi all,
> >> I am unable to connect to SQL2005 server using the Management Studio. i
> >> can however connect to SQL2000 using EM. Has anyone else encoutered this
> >> issue? if so could you please share the solution? what is ti that i need
> >> to enable on the firewall?
> >>
> >> Thanks
> >> Jores
> >>
> >
> >
>
>sqlsql