Aim: To migrate from SQL2005 to SQL 2017
Details: We have an old SQL server 2005 that also has SSRS, SSIS and SSAS components.I am trying to migrate SSIS and SSRS from one SQL server to another. The new server is going to be a shared SQL server and is already running an instance of SSRS and SSIS.
I've installed a second instance of SQL server on the new server and have restored databases on that server. However, I don't have a clue if we can actually have two instances of SSRS and SSIS on the same server?
In terms of setting up SSRS, I've installed IIS on the new server and configured websites with virtual directories similar to SQL2005. However, there are some SQL jobs with long random characters which were created via SSRS. How do I recreate those jobs?
JobID : 86D685E6-F353-46A1-9D1F-0B0EC1336B6E
JobName : 09DF1436-A5C6-4FE8-B325-5C47710E138B
JobOwner : NT AUTHORITY\NETWORK SERVICE
JobCategory : Report Server
JobDescription : This job is owned by a report server process. Modifying this job could result in database incompatibilities. Use Report Manager or Management Studio to update this job.
Any pointers on SSRS migration would really help.