This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 37%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
One of the prerequisites of my application is SQL Server R2 2008 and it used to be installed with ClickOnce without problems but since last week the installation fails.
I started to look for the cause of this problem and I discovered that in the package manifest of sql server r2 2008's bootstrapper the download links for the packages are down.
<String Name="DisplayName">SQL Server 2008 R2 Express</String>
<String Name="Culture">en</String>
<String Name="SqlExpr32Exe">http://go.microsoft.com/fwlink/?LinkID=230856&clcid=0x409</String>
<String Name="SqlExpr64Exe">http://go.microsoft.com/fwlink/?LinkID=230857&clcid=0x409</String>
these lines of the package.xml have the links where click once should download the packaged from but they are down, how can I solve this?
sql server r2 2008's bootstrapper the download links for the packages are down.
What do you expect, version 2008 R2 is out-of-support since a very long time, even the extended support ended on 7/9/2019?
This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Hi @matias turra ,
You could try using the download links from the SQL Server 2008 R2 SP2 Express from here:
https://www.microsoft.com/en-us/download/details.aspx?id=30438
----------
(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)
Best regards,
Leon
I changed the download links in the manifest and the problem persists!
I tried the download links in Leon's post, and they seem to work.
In any case, you should make sure that you also install SP3, which is the last service pack for SQL 2008.
Or even better move to a newer and supported version of SQL Server. SQL 2008 R2 has been out of support for a few years now.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 78%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECZ%3C/text%3E%3C/svg%3E)
Hi,
Leon has given valid links, I can click on these links to download SQL Server 2008 R2 SP2 Express x86/x64.
As for why you replaced the inaccessible links in the file with these useful links, but the result is the same, now this may be a ClickOnce problem.
How do you replace these links?&clcid=0x409 probably should be reserved.
I think those links are shortened links but changing them should work but they don't. Do you know what can be happening with ClickOnce? Is there a safe alternative to click once?
Hi,
Sorry, I am not familiar with Click Once.
><String Name="SqlExpr32Exe">http://go.microsoft.com/fwlink/?LinkID=230856&clcid=0x409</String>
It’s just that I think the &clcid=0x409 should not be part of the SQL Server download link. It may need to be kept
This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Comments have been turned off. Learn more
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Comments have been turned off. Learn more
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Comments have been turned off. Learn more