Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Express Edition and Compact Edition (2005)
 Connect MSSQL without VPN

Author  Topic 

SiaugauZ
Starting Member

2 Posts

Posted - 2007-05-24 : 01:36:48
Hi All,

I have a mssql server that is located somewhere and i can only able to access it with my pc mssql when VPN is connected. Is there any solution/configuration that can let me to access the it without connecting to the VPN?
Please advice.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-05-24 : 01:40:58
You need to talk to your network admins to see what they have available. There isn't anything in SQL Server to configure excent to choose which protocols for SQL Server to listen on and which protocol the client will use.

Tara Kizer
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-05-24 : 01:59:43
This is has nothing to do with SQL Server. It is basically network configuration and security issue. For security purposes, it only allows connection from remote site to be via VPN.
quote:
Is there any solution/configuration that can let me to access the it without connecting to the VPN?

Yes. Basically this will involved configuration of firewall, router etc and will be compromising on the security aspect.


KH

Go to Top of Page

SiaugauZ
Starting Member

2 Posts

Posted - 2007-05-24 : 03:30:52
ok i got what you mean.
Thanks guys. Thanks alot.
Go to Top of Page

ciki022
Starting Member

6 Posts

Posted - 2009-06-03 : 07:37:04
I have same needs, and I posted this :

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=126962

I am system administrator, can You explain step-by-step connecting to MSSQL server 2000 without VPN connection ?

Thanks in advance,

Goran
Go to Top of Page
   

- Advertisement -