question

PS-2147 avatar image
0 Votes"
PS-2147 asked jimas1991 commented

SQL Server 2008 R2 SP1 Native Client

Does anyone have a working link where I can download the SQL Server 2008 R2 SP1 Native Client?

Thanks in advance!

sql-server-general
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.

LeonLaude avatar image
0 Votes"
LeonLaude answered LeonLaude commented

Hi @PS-2147,

I have uploaded the SQL Server 2008 R2 SP1 Native Client for you to my Google Drive:
https://drive.google.com/file/d/1pa0LBbkehk5nisP62nUiK07Az7YdOSJS/view?usp=sharing


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.

Thank you!

0 Votes 0 ·

You're welcome.

0 Votes 0 ·
PS-2147 avatar image
0 Votes"
PS-2147 answered

Thanks for the quick response, but that is SP3. I specifically need SP1.

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.

Cathyji-msft avatar image
1 Vote"
Cathyji-msft answered jimas1991 commented

Hi @PS-2147,

Please check the reply from Leon.

SQL Server 2008 R2 SP1 Native Client is too old, the oldest SQL server 2008 R2 native client that we can get from MS download link is SP3 . You can get it from here. It seems you are using SQL server 2008 R2 SP1, suggest you applying the latest SP3 for SQL server 2008 R2. Or if possible, please upgrade your SQL server to a newer version of SQL server. SQL server 2008 R2 is out of supported for a long time. Don't let your infrastructure and applications go unprotected.


If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.



· 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.

Thanks for the feedback. I should have put some context around this, but this isn't anything production. It is being used for an extract from an old restored environment.

0 Votes 0 ·

Thanks @Cathyji-msft!

Your answer really helped a lot!
Yes, it is true that SP1 cannot be found but @Cathyji-msft is correct.
If you download the sqlcli.msi package from the SQL Server 2008 r2 sp3 the installation procedure will continue.
At least, thats what the prerequisites installer did in my situation.
And after the installation of the prerequisites packages was completed, i got the below message

"Microsoft SQL Server 2008 R2 SP1 Native Client: equivalent products already installed (no action taken)"

0 Votes 0 ·