SSRS 2019 not able to connect to Oracle 2019

• patdev00

  SSC Enthusiast

  Points: 174

  More actions

  April 6, 2023 at 6:26 pm

  #4170167

  Hello,

  I have issues with SSRS 2019. I moved SSRS 2012 to 2019 on OS 2019,.

  after restoring key ssrs comes up fine. But when i try to create oracle data source it errors out with TNS: could not resolve the connection identifier specified.

  I have oracle 2019 client installed. also installed ODP 19(64 bit).

  I can tnsping to db server at oracle. but cannot create data source on ssrs?

  any suggestion would help to solve appriciated.

  Thanks

• Site Owners

  SSC Guru

  Points: 80320

  More actions

  April 7, 2023 at 7:10 pm

  #4170657

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• edora19

  Newbie

  Points: 1

  More actions

  April 19, 2023 at 8:49 am

  #4176157

  Did you JUST updated the SQL Server server and not the connector? Or you updated both?