Re: Connecting remotely through VPN
- From: BrassicaNigra <brassica_nigra@xxxxxxxxxxxxxxxx>
- Date: Mon, 16 Feb 2009 15:19:01 -0800
Charles,
@@VERSION = 9.00.3042.00
I downloaded sp3 from the link provided, but received a message that nothing
had been upgraded. When I drilled down to the details I got to this message;
Name: Microsoft SQL Server 2005 (SQLEXPRESS)
Reason: Your upgrade is blocked. For more information about upgrade support,
see the "Version and Edition Upgrades" and "Hardware and Software
Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books
Online.
Edition check:
Your upgrade is blocked because of edition upgrade rules. For more
information about edition upgrades, see the Version and Edition Upgrades
topic in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.
How do I get to 9.0.4035?
Also, browser service is running fine as evidenced by the fact that I can
connect when using the static IP of the server from outside my network, but
not on the VPN. Also, it has been stopped and restarted numerous times on
all three servers.
This problem only occurs on VPN and it occurs on SQL2005 and 2008. I really
believe it has to be related to VPN settings in SPS2003 R2.
Dale
""Charles Wang [MSFT]"" wrote:
Hi Brassica,.
I think that your SQL Browser Service did not work well. I recommend that
you first stop your SQL Server Browser service and then run it from console
mode as following:
<drive>\<path>\sqlbrowser.exe -c
By default, the SQL Server Browser service is located in the folder
%ProgramFiles%\Microsoft SQL Server\90\Shared.
Please post the output here.
Also I recommend that you try connecting to your SQL Server instance by
explicitly specifying the tcp: prefix. For example:
osql -S tcp:192.168.16.3\SQLEXPRESS -E
Go
If this issue persists, I would like to check with you what the version of
your SQL Server 2005 Express is. You can run SELECT @@VERSION to check it.
If the version number is less than 9.0.4035, I recommend that you try
installing the latest service pack to see if that helps.
Microsoft SQL Server 2005 Express Edition Service Pack 3
http://www.microsoft.com/downloads/details.aspx?FamilyID=3181842a-4090-4431-
acdd-9a1c832e65a6&displaylang=en
If you want a GUI management tool for SQL Server 2005 Express, please
install this package:
Microsoft SQL Server 2005 Express Edition with Advanced Services Service
Pack 3
http://www.microsoft.com/downloads/details.aspx?familyid=b448b0d0-ee79-48f6-
b50a-7c4f028c2e3d&displaylang=en
Thank you!
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
=========================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================
- References:
- RE: Connecting remotely through VPN
- From: BrassicaNigra
- Re: Connecting remotely through VPN
- From: William Vaughn \(MVP\)
- Re: Connecting remotely through VPN
- From: BrassicaNigra
- Re: Connecting remotely through VPN
- From: "Charles Wang [MSFT]"
- RE: Connecting remotely through VPN
- Prev by Date: Re: Connecting remotely through VPN
- Next by Date: Re: Connecting remotely through VPN
- Previous by thread: Re: Connecting remotely through VPN
- Next by thread: Re: Connecting remotely through VPN
- Index(es):
Relevant Pages
|
