Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Report Manager DSN Problem Expand / Collapse
Author
Message
Posted Tuesday, May 14, 2013 3:47 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, May 22, 2014 2:35 AM
Points: 17, Visits: 79
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



  Post Attachments 
DataSource.jpg (7 views, 68.33 KB)
Post #1452466
Posted Tuesday, May 14, 2013 12:52 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:22 PM
Points: 11,148, Visits: 12,889
Have you created the DSN on the report server?

Does the report server have the Sybase ODBC driver?




Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

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
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #1452783
Posted Wednesday, May 15, 2013 12:38 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, May 22, 2014 2:35 AM
Points: 17, Visits: 79
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
Post #1453252
Posted Monday, June 10, 2013 5:30 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, July 10, 2014 5:39 PM
Points: 40, Visits: 79
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
Post #1461818
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse