Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Can't lauch SQL Server Managment Studio after i am connected via VPN Expand / Collapse
Author
Message
Posted Wednesday, April 28, 2010 2:53 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, July 1, 2014 8:13 PM
Points: 11, Visits: 186
All
our remote developers cannot launch SQL Server management studio after they establish VPN connection.
we have developers who must connect to our sql servers in our network in order to do some work but for some reason after they establish VPN connect they are not able to launch Management Studio.

I tried myself and i have the same error message, so that only way for me to have access to the SQL servers is for me to RDP into my desktop at work and them launch it
i have look around the web and not seems to find any solutions to this

I have asked my network engineers to check the VPN profile and there is nothing blocking sql port

Any tips
Post #912380
Posted Thursday, April 29, 2010 6:15 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, April 28, 2014 7:14 AM
Points: 881, Visits: 1,404
How about posting that error message?

first thought is that this is probably network related. Can you telnet to the sqlserver over port 1433... i.e. if you execute the following from a command prompt:

telnet servernameyouuseexactlyasinmgmtstudio 1433

Do you get a "could not connect" (bad) or black screen (good)?
Post #912742
Posted Thursday, April 29, 2010 6:25 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 8:57 AM
Points: 7,112, Visits: 6,280
Are there global policy restrictions on launching applications from entry through a VPN tunnel?

Could the VPN tunnel be such a memory hog that the system doesn't have the resources to launch SSMS? (Start a PerfMon trace and then log into the VPN connection, then try to open SSMS).

Check the Event log to see what's going on also.

EDIT: Check the Surface Area Config to see if SQL *allows* remote activation


Brandie Tarvin, MCITP Database Administrator

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #912749
Posted Thursday, April 29, 2010 6:30 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, July 17, 2014 12:34 PM
Points: 1,414, Visits: 4,539
most likely a DNS issue. is your internal AD DNS zone totally separated from the outside world and not published?

i've had the same problems and i either RDP to an office computer or i have a virtual WIndows 7 instance on VMWare that I use when away from the office


https://plus.google.com/100125998302068852885/posts?hl=en
http://twitter.com/alent1234
x-box live gamertag: i am null
[url=http://live.xbox.com/en-US/MyXbox/Profile[/url]
Post #912752
Posted Wednesday, May 5, 2010 2:31 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, July 1, 2014 8:13 PM
Points: 11, Visits: 186
i have attached a screen shot of the error i got to my reply

Thx


  Post Attachments 
sqlserver_error.jpg (31 views, 22.08 KB)
Post #916478
Posted Wednesday, May 5, 2010 2:50 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, April 28, 2014 7:14 AM
Points: 881, Visits: 1,404
Try using fully qualified server name... error message shows "error connecting to server\instance".

Change connection to look for servername.domain.com\instance

(of course by domain.com, I mean whatever the fully qualified name of the server is)

Also- get down to basics. Set aside managment studio for now and go to the command line. Can you ping the server? can you ping it using fully qualified name? can you telnet to it over port 1433? It's a named instance, what port is it listening on if not default?

Post #916494
Posted Thursday, May 6, 2010 4:27 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 8:57 AM
Points: 7,112, Visits: 6,280
nana.asare (5/5/2010)
i have attached a screen shot of the error i got to my reply


Read the error carefully. See where it says "or Remote connections are not allowed?"

Brandie Tarvin (4/29/2010)

Check the Surface Area Config to see if SQL *allows* remote activation


In case you don't know what this means, log into the server itself (NOT through the VPN), and navigate to this path: Start -> Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> SQL Server Surface Area Configuration.

A window will pop up. Choose Surface Area Configuration for Services and Connections. Another window will pop up. Open up Database Engine. Click on Remote Connections. The right hand pane will change. Make sure the "Local and remote connections" radio button is picked. Then verify which network protocols you want to use and click that.

If VPN is using Named Pipes and you've got "Using TCP/IP only" checked, you won't be able to use VPN to connect to the server. Reverse that and the same is true. So make sure whatever network protocols you're using for VPN is what's chosen here.


Brandie Tarvin, MCITP Database Administrator

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #916784
Posted Thursday, May 6, 2010 4:48 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, July 17, 2014 6:40 AM
Points: 2,567, Visits: 3,799
Are u able to open any website from ur local machine while RDP?

Are u using any cencrypted login or any other security device for RDP?

Post #916800
Posted Thursday, May 6, 2010 5:08 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, May 21, 2010 11:31 AM
Points: 1, Visits: 1
Try right mouse click on the short cut for SSMS and choose run as administrator. When you VPN, the network does not recognize you and being on that domain so windows authentication does not work. You remain on what ever domain you are remote connecting from.
Post #916810
Posted Friday, May 7, 2010 1:06 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, May 9, 2014 8:46 AM
Points: 2, Visits: 22
When we have this issue it's due to the firewall rules not allowing any netbois name queries to pass the connection. Try connecting with the local IP of the server.

Or make sure you have the local AD DNS and/or WINS server pointing correctly.

Sometimes you may need a route statement on the server to route traffic back to the VPN subnet as they are usually a seperate subnet from the internal.

Post #918302
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse