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 3

Expert Comment

by:Pratik Somaiya
Hey. That's great your issue is resolved. Sorry was too much occupied with office work ☺️
0
OWASP Proactive Controls
LVL 12
OWASP Proactive Controls

Learn the most important control and control categories that every architect and developer should include in their projects.

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 27

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.