Remote Connection through VPN
-
Hi there,
today I tried for the first time to connect to SQL Server via telephone line and VPN. I received an error like DBNETLIB Server doesn't exists.....
???
Where should I look at?
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
Can you ping your SQL Server?
Can you ping other machines on the network through the VPN?
K. Brian Kelley, GSEC
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
K. Brian Kelley
@kbriankelley -
Yes to both questions!
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
If you know your SQL Server's TCP port, try connecting via: <server>,<port> through QA. Does that work?
K. Brian Kelley, GSEC
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
K. Brian Kelley
@kbriankelley -
Well, I can connect to several other (test)servers on the network. That works without further configuration. I guess I have to talk to the network admin tomorrow.
Thanks anyway!
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
Definitely some network item. The VPNs can be implemented differently and they don't always pass all ports through the tunnel. Are you connecting by IP or name?
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
-
I'm connecting via name.
Interestingly my production server seems to be the only one missing in the list of active servers in the network?
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
Frank,
Maybe they've selected the "Hide Server" option for that server.
Do you know what port it's listening on?
If so, do you get any success with: telnet ip_address portnumber
or
telnet servername portnumber
(eg. telnet prodsvr 1433)
Cheers,
- Mark
Cheers,
- Mark -
Help Mark!
How do I get out of telnet.
It seems to work and now I have a blank screen and no clue what to do??
Frank
Edited by - Frank kalis on 12/08/2003 01:48:15 AM
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
I asked our DBA what could be the cause and he said he has no problems to connect, but it might be an issue with my 'firewall profile' and that I'm not allowed accessing the server. This is an absolute standard installation with nothing special.
Can this be a firewall issue?
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
That's good! The server's listening on that port.
Just close the cmd screen (that little X in the top right corner).
So now, you should also be able to:
OSQL -Sservername,portnumber -Ulogin
If that works too, then a client network utility entry (without "dynamically determine port" checked) should fix things for you.
Cheers,
- Mark
Cheers,
- Mark -
Lots of good suggestions which I can unfortunately first try in the evening from home.
...but if it doesn't work I'll come back anyway
Thanks for now.
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
Sometimes it pays to be tenacious ?!?
Somehow it seems to work only with SQL Server authentication only, not with Windows. Anyway, it's working now. Thanks to you all!
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 13 posts - 1 through 12 (of 12 total)
You must be logged in to reply to this topic. Login to reply