questions with a 2019 SQL server with reporting services installed.

Question

Hi everyone,

Hope you can help to share your opinion. I start this new job without being inherited with good info.

I have two SQL servers. One is a sql server with sql 2014, which is used for a 3rd application (another app server in another box).

Then there is another SQL server with 2019. This one there is a SQL reporting services. I think there are some data exported from the 1st sql server and stored in some table in this server so the users can retrieve it and run custom reports.

Now I plan to upgrade the sql server with SQL 2014 to 2019. Before the upgrade, what settings I need to review. Do you think the upgrade will mess up anything (for example, the report service on the server will stop working or lose connection or any configurations to the first SQL server or database there?)?

I am not a real sql admin and hope you can help me to investigate this further so I can provide a good planning on the upgrade (although I can always take a snapshot to roll back, which will not get to the point to upgrade it successfully).

Thank you for your help in advance.

Takami Chiro

Answer 1

Hi @Takami Chiro

you should not have any issues. I have combination of SSRS and SQL server on different versions

Answer 2

Hello @Takami Chiro

First of all, if you are planning to upgrade a SQL server which is used to run a 3rd party application, I will strongly suggest you to get in touch with the vendor and make sure the app supports SQL 2019. Most of the times vendor would like to stick to specific SQL versions.

After that, if you finally will upgrade make sure your SQL 2014 has installed SP2 or later. it is necessary for the in-place upgrade

https://learn.microsoft.com/en-us/sql/database-engine/install-windows/supported-version-and-edition-upgrades-2019?view=sql-server-ver16

after that, make sure you have a backup of the system databases (master , model, msdb). as well as all the user databases. It is important you have a plan B in case the upgrade fails

https://learn.microsoft.com/en-us/sql/database-engine/install-windows/upgrade-sql-server?view=sql-server-ver16

Hope this helps

Regards

Javier

Answer 3

Hi @Takami Chiro,

To perform a successful SQL Server upgrade, regardless of approach, appropriate planning is required.

Check it out here Plan and test the database engine upgrade plan.

It is highly suggested that you may test in your test environment to monitor the progress to see if it will affect your reports.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 4

HI Both,

Thank you for your response! I really appreciate it. I have already run an in-place upgrade in a test environment. I am sorry if I did not ask clearly my question and let me clarify little.

There are two SQL servers. One is used by application server. That is the one with SQL 2014 I have already verified with the vendor about the SQL upgrade. This one I do not have any questions on.

There is another 2019 SQL server with reporting services installed, and this is the server I am asking about. I am not sure what relationship between this server and the SQL 2014 and I am worried about upgrading the other server will mess up existing "relationship".

As for the second 2019 SQL server, there is a reporting services setup by the previous admin who did not transfer any info to us. I think there are some data exported from the 1st sql server and stored in some table in this server so the users can retrieve it and run custom reports. And this is the server I am asking about. I am not sure what relationship between this server and the SQL 2014 and I am worried about upgrading the other server will mess up existing "relationship".

In summary, I definitely upgrade the SQL 2014 to 2019 without any problem. I just want to make sure the upgrade would not ruin any configurations that set to the 2nd 2019 SQL server. I would like to see how I can check the configurations on the 2nd SQL server with reporting services installed.

Hope this helps clarifying little.

Thank you again! Hope you can help.

Takami Chiro

Answer 5

Hi @Takami Chiro,

check the configurations on the 2nd SQL server with reporting services

You may check Report Server Configuration Manager to see if it used the SQL 2014 database.

In addition, you may check the DataSource of your reports which is possible to use the data on SQL 2014.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.