question

matiasturra-8868 avatar image
0 Votes"
matiasturra-8868 asked Criszhan-msft commented

SQL Server Express R2 2008 download links in bootstrapper are down! what can I do?

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&amp;clcid=0x409</String>
 <String Name="SqlExpr64Exe">http://go.microsoft.com/fwlink/?LinkID=230857&amp;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-generaldotnet-csharp
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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?



1 Vote 1 ·
LeonLaude avatar image
1 Vote"
LeonLaude answered ErlandSommarskog commented

Hi @matiasturra-8868,

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

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

I changed the download links in the manifest and the problem persists!

0 Votes 0 ·

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.

1 Vote 1 ·
Criszhan-msft avatar image
0 Votes"
Criszhan-msft answered Criszhan-msft commented

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?&amp;clcid=0x409 probably should be reserved.

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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?

0 Votes 0 ·

Hi,
Sorry, I am not familiar with Click Once.

<String Name="SqlExpr32Exe">http://go.microsoft.com/fwlink/?LinkID=230856&amp;clcid=0x409</String>;

It’s just that I think the &amp;clcid=0x409 should not be part of the SQL Server download link. It may need to be kept


0 Votes 0 ·