Thanks Fred for your suggestions  and KingswaySoft for the good software info ..

I followed these steps and it worked like a charm but i would not say this would work...

Thanks Fred, that was my last option but looks like its my only option.

Forgot to add this error message too

This occurs when CPackage::LoadFromXML fails.

HTTP Error 503. The service is unavailable.

This is out dev box and has no access to Internet , have installed the .net framework 4.8 and reboot the server .

Restarted the...

Bernard,

Thnx for your solution , we did an upgrade from 2012 Developer to 2016 Standard . I have never did SSRS earlier (Data Driven subscriptions part). So i might need...

@palandri does that cause an issue its the truncation error we can ignore.

I can go to advanced and get rid of truncation errors .. but still not loading

@blakemcneill

Thanks for the awesome post , i followed the step by step you mentioned but i have a question ..let me explain my steps

Guide me to migrate reports...

• This reply was modified 5 years, 3 months ago by  JSB_89.

Thanx Jeff will check with the SAN team, but going back to my original question views and synonyms are a big no no correct??

That’s a long process to get approval from IT manager and jump thru all the hoops.

That’s for a later day

Full backups

Well like I mentioned in the original post, we have 2 domains and we perform a backup in prod and copy to dev environment and then perform the restore.so a...

The company is driven by business so whatever the business needs we need to provide, evn for setting up the QA test env they need the latest prod data not...

objects exposing columns with clr types are not allowed in distributed queries, we have linked servers to join tables so whenever we perform that operation or try running a query...

It is mostly financial information and they need it matched to exact $ amount , it is critical . BTW forgot to mention there are 3 nodes (SQL Server 2014...