Sql-server – SQL Server 2016 – SSRS Unable to Upload Report Models – smdl Files

reportingsql serversql-server-2016ssrs-2016

SSRS 2016 has major improvements and we've decided to migrate our 2008 servers. However, we and ran into a issue where we can't upload our old Report Models (.smdl files) via the web interface. All of the documentation states that these old models are deprecated, but will continue to work in SQL 2016.

Has anyone been able to figure this out? Can we use the SOAP web service to upload them? If so, do you have an example script?

Thanks

Best Answer

This worked for me --> creating an SSRS 2008 project and add the Report Models in there. Then deploy the report models to the SSRS 2016 server.

Related Solutions

Sql-server – Can’t uninstall Microsoft SQL Server 2016 RC3

Thanks to Aaron Bertrand, I was able to resolve the issue following the manual steps outlined in his blog:

Fun with software : uninstalling SQL Server 2008 R2 Evaluation Edition

...in spite of the title, it's not just for 2008 R2 or Evaluation Edition.

In case the link ever stops working, the essential steps are:

Locate SQL Server related GUIDs under:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\

Also look for GUIDs in folders under Uninstall called e.g. "Microsoft SQL Server 2008 R2"
Run for each item:
```
msiexec /x "{guid}"
```

SSRS 2016 Report Server – How to Start

I found the solution. There is a "SQL Server Reporting Services (MSSQLSERVER)" service that manages, executes, renders, schedules and delivers reports. It was set with an "Automatic" Startup Type. After a reboot the service was indeed running but I was still getting a 503 Service unavailable error. I found a blog that says the Startup Type needs to be "Automatic (Delayed Start)". Once I changed the Startup Type to "Automatic (Delayed Start)" and restarted the service the report server started working.

Best Answer

Related Solutions

Sql-server – Can’t uninstall Microsoft SQL Server 2016 RC3

SSRS 2016 Report Server – How to Start

Related Question