Groups | Blog | Home
all groups > sql server connect > october 2003 >

sql server connect : Can't connect to SQL over VPN


kelnic
10/17/2003 7:41:42 AM
I have SP3 for SQL installed on my server. When connect
over a VPN and then try to find the computer that is
connected, I get Sql server does not exist or access is
denied error. Now, I read that there is a known issue
with VPNs connecting after the SQL service has been
started and they say to install SP3a, but I already have
SP3 installed. Has anyone seen this before and will it
hurt if I install the 3a over the 3 as I also know that it
says that I don't need it if I have 3. Any help would be
appreciated.

thanks
kelnic
10/17/2003 12:48:32 PM
Hi,

I tried that and it didn't work still. Any other
suggestions, should I put sp3a on, even though I have SP3?

thanks

Kelnic
[quoted text, click to view]
Ray Higdon
10/17/2003 1:31:09 PM
I use Cisco's VPN software to access SQL servers with sp3 and sp3a with no
problems, it might be more related to your DNS setup, try connecting by
using the IP address of your SQL Servers.

HTH

--
Ray Higdon MCSE, MCDBA, CCNA
--
[quoted text, click to view]

Ray Higdon
10/17/2003 10:03:15 PM
You could try that, again, I hit servers with sp3 on with no problems. Are
you using Cisco VPN software? If so what version?

--
Ray Higdon MCSE, MCDBA, CCNA
---
[quoted text, click to view]

Neil Pike
10/20/2003 10:10:33 AM
Kelnic,

Does the VPN terminate on the SQL Server itself? Try connecting to the IP
address of it's ethernet interface rather than it's VPN Interface.

[quoted text, click to view]

Neil Pike MVP/MCSE. Protech Computing Ltd
Reply here - no email
SQL FAQ (484 entries) see
http://forumsb.compuserve.com/gvforums/UK/default.asp?SRV=MSDevApps
(faqxxx.zip in lib 7)
or www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
or www.sqlserverfaq.com
or www.mssqlserver.com/faq
AddThis Social Bookmark Button