Can't lauch SQL Server Managment Studio after i am connected via VPN

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Can't lauch SQL Server Managment Studio after...

13 posts, Page 1 of 2

1 2 »»

Can't lauch SQL Server Managment Studio after i am connected via VPN

Rate Topic

Display Mode

Topic Options

Author

Message

nana.asare

Posted Wednesday, April 28, 2010 2:53 PM

Grasshopper

Group: General Forum Members
Last Login: Friday, June 07, 2013 2:16 PM
Points: 11, Visits: 148

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

NJ-DBA

Posted Thursday, April 29, 2010 6:15 AM

SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 12:36 PM
Points: 858, Visits: 1,332

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

Brandie Tarvin

Posted Thursday, April 29, 2010 6:25 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 11:45 AM
Points: 6,717, Visits: 5,788

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, MCDBA, MCSA

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

alen teplitsky

Posted Thursday, April 29, 2010 6:30 AM

Ten Centuries

Group: General Forum Members
Last Login: Monday, June 10, 2013 10:43 AM
Points: 1,411, Visits: 4,517

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

nana.asare

Posted Wednesday, May 05, 2010 2:31 PM

Grasshopper

Group: General Forum Members
Last Login: Friday, June 07, 2013 2:16 PM
Points: 11, Visits: 148

i have attached a screen shot of the error i got to my reply

Thx

Post Attachments

sqlserver_error.jpg (29 views, 22.08 KB)

Post #916478

NJ-DBA

Posted Wednesday, May 05, 2010 2:50 PM

SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 12:36 PM
Points: 858, Visits: 1,332

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

Brandie Tarvin

Posted Thursday, May 06, 2010 4:27 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 11:45 AM
Points: 6,717, Visits: 5,788

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, MCDBA, MCSA

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

Ratheesh.K.Nair

Posted Thursday, May 06, 2010 4:48 AM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 9:39 AM
Points: 2,425, Visits: 3,401

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

brownrr

Posted Thursday, May 06, 2010 5:08 AM

Forum 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

rbragg

Posted Friday, May 07, 2010 1:06 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, April 19, 2012 9:00 AM
Points: 2, Visits: 21

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 »

13 posts, Page 1 of 2

1 2 »»

Permissions