Post reply

Can SSRS 2019 and SQL Server 2019 access a 2012 SQL Service database

  • April 1, 2021 at 2:43 pm

    Answer

    #3864441

    Yes - you can use SSRS 2019 and connect to your 2012 instance as well as any other instance in your domain.  Create a new server, install the database engine and SSRS components - and configure as needed.

    Deploy your reports that use a connection to the 2012 instance and they will work just fine.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

  • April 1, 2021 at 2:46 pm

    #3864443

    We don't have SQL server 2019 but if you are accessing data from SQL server 2019 it should be backward compatible.  Using linked server to access data from one server to the other should work.

  • April 1, 2021 at 5:37 pm

    #3864508

    Thank you!  How do I mark this as answer too?

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply