Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


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


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

Author
Message
nana.asare
nana.asare
Grasshopper
Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)

Group: General Forum Members
Points: 11 Visits: 193
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
NJ-DBA
NJ-DBA
SSC Eights!
SSC Eights! (911 reputation)SSC Eights! (911 reputation)SSC Eights! (911 reputation)SSC Eights! (911 reputation)SSC Eights! (911 reputation)SSC Eights! (911 reputation)SSC Eights! (911 reputation)SSC Eights! (911 reputation)

Group: General Forum Members
Points: 911 Visits: 1546
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)?
Brandie Tarvin
Brandie Tarvin
SSCertifiable
SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)

Group: General Forum Members
Points: 7821 Visits: 8752
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 AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
alen teplitsky
alen teplitsky
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1595 Visits: 4621
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
nana.asare
nana.asare
Grasshopper
Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)

Group: General Forum Members
Points: 11 Visits: 193
i have attached a screen shot of the error i got to my reply

Thx
Attachments
sqlserver_error.jpg (34 views, 22.00 KB)
NJ-DBA
NJ-DBA
SSC Eights!
SSC Eights! (911 reputation)SSC Eights! (911 reputation)SSC Eights! (911 reputation)SSC Eights! (911 reputation)SSC Eights! (911 reputation)SSC Eights! (911 reputation)SSC Eights! (911 reputation)SSC Eights! (911 reputation)

Group: General Forum Members
Points: 911 Visits: 1546
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?
Brandie Tarvin
Brandie Tarvin
SSCertifiable
SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)

Group: General Forum Members
Points: 7821 Visits: 8752
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 AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
VastSQL
VastSQL
Hall of Fame
Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)

Group: General Forum Members
Points: 3034 Visits: 5022
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?
brownrr
brownrr
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
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.
rbragg
rbragg
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search