Report Manager DSN Problem

• jayanta.sarkar01

  SSC Veteran

  Points: 251

  More actions

  May 14, 2013 at 3:47 am

  #293786

  Hi

  I have created a DSN (using sybse db) and develop report in SSRS 2008R2. Reports working fine in BIDS. Now I have uploaded RDL in Report Manager. Create a ODBC DataSource in Report Manager.

  I am getting below error message

  An error has occurred during report processing. (rsProcessingAborted)

  Cannot create a connection to data source 'dsTransaction'. (rsErrorOpeningConnection)

  ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

  Attached screnshot for reference.

  Please guide to to create a DSN DataSource in SSRS Manager.

  Do I have any permission issues in report server?

  --

  Thanks & Regards

  Jayanta Sarkar

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  May 14, 2013 at 12:52 pm

  #1615157

  Have you created the DSN on the report server?

  Does the report server have the Sybase ODBC driver?

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question

• jayanta.sarkar01

  SSC Veteran

  Points: 251

  More actions

  May 15, 2013 at 12:38 pm

  #1615553

  Hi

  Thanks for your response.

  Yes I have created DSN in Server. Now my problem is solved. It was due to access limitation

  Thanks & Regards

  Jayanta

• mysorian

  Ten Centuries

  Points: 1048

  More actions

  June 10, 2013 at 5:30 pm

  #1622666

  Deploy the Report as well as the data source from SSDT to report server.

  2nd edition of my book on SSRS2012 to be released on June 20, 2013

  http://hodentek.blogspot.com