RE: Connecting remotely through VPN
- From: changliw@xxxxxxxxxxxxxxxxxxxx ("Charles Wang [MSFT]")
- Date: Wed, 14 Jan 2009 10:34:31 GMT
Hi Dale,
Thank you for using Microsoft MSDN Managed Newsgroup.
From your description, I understand that you could not connect to your SQLExpress 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.
=========================================================
.
- Follow-Ups:
- RE: Connecting remotely through VPN
- From: BrassicaNigra
- RE: Connecting remotely through VPN
- References:
- Connecting remotely through VPN
- From: BrassicaNigra
- Connecting remotely through VPN
- Prev by Date: Connecting remotely through VPN
- Next by Date: Re: SQL 2008 remote Management Studio connection
- Previous by thread: Connecting remotely through VPN
- Next by thread: RE: Connecting remotely through VPN
- Index(es):
Relevant Pages
|
