RE: Connecting remotely through VPN

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Charles,

Thanks for the info. I have gone through all of the steps. The SQL Server
Configuration manager shows that it is using dynamic port 1107. The 'netstat
-nba' shows that indeed sqlservr.exe is listening on this port (and some
others as well).

When I telnet to the IP and port, nothing happens (the screen command prompt
disappears and the window just sits there doing nothing).

I will send the error logs to you momentarily and will include the
portlog.txt as well.

Dale

""Charles Wang [MSFT]"" wrote:

Hi Dale,
Thank you for using Microsoft MSDN Managed Newsgroup.

From your description, I understand that you could not connect to your SQL
Express 2005 via VPN.
If I have misunderstood, please let me know.

First I recommend that you check what the TCP port is being used by your
SQL Server Express instance. You can check this via the following steps:
1. Open Configuration Manager, expand "SQL Server 2005 Network
Configration", and select "Protocols for SQLEXPRESS";
2. Double click TCP/IP, switch to the IP Addresses tab and check what the
TCP port is listening by your SQL Server.

After that run "netstat -nba >C:\portlog.txt" to print the TCP ports used
by your processes in the file C:\portlog.txt. Open the file and find the
TCP port. Check if it is being used by your SQL Server process
(sqlservr.exe).

If it is used by your SQL Server process, it indicates that your SQL Server
process successfully listens on the TCP port, then run "telnet <server ip
address> <tcp port>" from command prompt on your client computer to see if
it succeeds.

If the it fails, please check if there is a firewall on your server. If so,
check the firewall settings on your server and ensure that the TCP port is
added into the exception list.

If this issue persists, please also send the SQL error logs to me
(changliw_at_microsoft_dot_com) for further research. By default the logs
are located in the folder %ProgramFiles%\Microsoft SQL
Server\MSSQL(.n)\MSSQL\LOG\.

Hope this helps. If you have any other questions or concerns, please feel
free to let me know.

Best regards,
Charles Wang
Microsoft Online Community Support
===========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg@xxxxxxxxxxxxxx
===========================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 2 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions. Issues of this
nature are best handled working with a dedicated Microsoft Support Engineer
by contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/en-us/subscriptions/aa948874.aspx.
============================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================


.

Relevant Pages

  • RE: View cune in Enterprise Manager
    ... I think that you referred to how to connect to SQL Server 2005 Analysis ... Microsoft Online Community Support ... Please feel free to let my manager ... or a Microsoft Support Engineer within 1 business day is acceptable. ...
    (microsoft.public.sqlserver.olap)
  • Re: Auch kein Connect zu SQL Server 2005 Instanz
    ... man aus dem Configuration Manager aufrufen kann. ... Unter IP Adresses habe ich bei TCP Port 1433 eingetragen. ... Ich stand auch vor dem Problem, dass ich nur von dem Rechner/Server selbst auf den SQL Server zugreifen konnte aber noch von "extern". ...
    (microsoft.public.de.sqlserver)
  • Re: Connecting to Sql Server using an IP address
    ... using IP address without port number (default port number ... of SQL Server is 1433) cannot connect to the SQL Server on a remote ... name in the connection string can connect the remote machine successfully. ... Microsoft Online Community Support ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Web.config update to allow remote connection to sql server 200
    ... I will check with our network manager to configure it in sql server ... The issue is basically a SQL Server connection issue. ... Microsoft Online Community Support ...
    (microsoft.public.vsnet.general)
  • Re: Failed to connect to SQL express on LAN
    ... Welcome to Microsoft MSDN Managed Newsgroup. ... Server 2005-> SQL Server Surface Area Configuration, ... Open SQL Server Configuration Manager or Services panel to restart your ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.connect)