Cannot update SQL Server 2008 R2 version

Trying to update our SQLTEST server to match our SQL Production server version.  Screen shots below.  I have tried several updates, service patches and they have not worked.

This is very urgent, we cannot progress with the upgrade we are working on until we can restore the bak file from Production SQL to SQL TEST

They are both Standard SQL Server 2008 R2 but different versions.

Thanks

Production SQL Server
Screen shot of Production SQL Server
SQLTEST SQL Server
Screen shot of SQL TEST Server
LVL 1
apollo7Asked:
Who is Participating?
 
Vitor MontalvãoConnect With a Mentor MSSQL Senior EngineerCommented:
Both servers are running on very old updates.
Best thing to do is to install the last service pack (SQL Server 2008R2 SP3) in both servers. Start with the Test environment first and do not forget to backup everything before applying the SP3.
0
 
Gaurav SinghConsultantCommented:
what error are you getting while updating the SQL server?
0
 
apollo7Author Commented:
I can restore the SQL Production backup to SQLTEST but when I try to import the org using CRM 2011 deployment manager I get the following error:

Setup failed to validate specified Reporting Services Report Server http://sqltest/ReportServer. Error: Error occurred while finding an item on the report server.
The request failed with HTTP status 401: Unauthorized.
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
apollo7Author Commented:
Vitor,

Installing the last service pack (SQL Server 2008R2 SP3) on both servers is not an option on the Production SQL Server.  There are third party apps that would break.

Do you have another suggestion to get these servers on the same service pack?

Thanks
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
There are third party apps that would break.
Uh? Do you want to explain this? Why a SQL Server service pack would break a 3rd party app? Is the app checking for the SQL Server service packs?
0
 
apollo7Author Commented:
I suggested using the latest service pack to the sys admin and that was what he told me.  I took this upgrade over from some one that left, so I am somewhat unfamiliar what they are doing.

Today I talked to the project manager and suggested we follow your suggestion, so maybe I will close out this ticket.

I have another ticket open concerning SSRS if you want to take a look at that.

Thanks for following up.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Good. Service Packs shouldn't affect how applications are working with databases.
About the SSRS, isn't my expertise.
Cheers
0
 
apollo7Author Commented:
Thanks for your help.
0
 
apollo7Author Commented:
This worked like a charm, thanks very much
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.