SSRS

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.

Share tech news, updates, or what's on your mind.

Sign up to Post

I haven't worked with SQL Server since 2001. Now I'm trying to configure SQL Server Reporting Services. I keep getting an error when I try to create a database in Report Server Configuration Manager or when I try to access the URLs in Web Service URL & Web Portal URL. The following is from ReportingServicesService_2018 log file. Do I need to uninstall SQL Server & SSRS & just start over? Is there a book out there that is for a beginner (which I am after a 17 year break)?  Thank you!

One more thing, the version is 2017. SQL Server Express = 14.0.600.906

library!ReportServer_0-1!665c!12/21/2018-14:14:55:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: No DSN present in configuration file, Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ;


When trying to change database in the database section in SSRS Config manager, I get this - error 40 - could not open a connection to SQL Server. Thank you

Test Connection Error
0

Author Comment

by:Dolores Hardy
Tried another account & the connections work. Thank you for your help!
0
LVL 5

Expert Comment

by:Pratik Somaiya
Hey. That's great your issue is resolved. Sorry was too much occupied with office work ☺️
0
JavaScript Best Practices
LVL 13
JavaScript Best Practices

Save hours in development time and avoid common mistakes by learning the best practices to use for JavaScript.

In SSRS reports, when selecting a parameter, I am unable to use the slide bar to scroll down and view all selections available. I can use the roll button to scroll. It works in Firefox, but not in IE. Anyone have any ideas how to resolve this?
0
LVL 28

Expert Comment

by:Brian B
You have entered this as a post, but it looks like it is a question. To get the best response from the Experts, you should probably re-submit this as a question using the "ask a question" button at the top of the screen, or this link: https://www.experts-exchange.com/askQuestion.jsp

Please see here for further details: http://support.experts-exchange.com/customer/portal/articles/756544-how-to-succeed-at-ee-as-an-asker
0
v2-native-ad-no-button.pngDo you work with and analyze data? Enroll in October’s Course of the Month to get step-by-step SQL training. Learn SQL to quickly and efficiently store and retrieve data!
0
I have designed SSRS Report and Once I click on preview it is asking SQL Login details first time. I entered login details (sa, 123) after it was showed  report. On the DataSource double click => credential saved. Again it is asking to enter SQL Login credentials but I am not able to see any boxes on the top, it is showing only View Report.  
0

SSRS

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.