How do I know what my Report Server is called (i.e. when prompted in Report Builder)
-
This is a dumb question from a newbie .. sorry ..
How do I know what my Report Server is called?
(i.e. when prompted in Report Builder)I can see various possibilities in Report Server Configuration Manager.
Is there an instruction set /tutorial for config of SSRS?
Maybe I have two ...?
Should I use a virtual service account or a domain/user account (on home notebook) ?
I get this log upon change from virtual to domain/user account:
Starting report server "SQLServerReportingServices" on ASUS_NOTEBOOK.
The task completed successfully.Stopping report server "SQLServerReportingServices" on ASUS_NOTEBOOK.
The task completed successfully.Reserving url http://+:80
The url was successfully reserved.Removing url http://+:80
The url was successfully removed.Starting report server "SSRS" on ASUS_NOTEBOOK.
The task completed successfully.Setting Windows Service Identity to Windows Account
The Windows account information used to run the Windows service has been updated.Stopping report server "SSRS" on ASUS_NOTEBOOK.
The task completed successfully.When I try to create a new reporting services database in ASUS_NOTEBOOK\MSSQLSERVER01 I get this error which I do not know how to resolve:
Microsoft.ReportingServices.WmiProvider.WMIProviderException: An error occurred when attempting to connect to the report server remote procedure call (RPC) end point. Verify that the Report Server Windows service is running, and then retry the operation.---> System.Runtime.InteropServices.COMException: The RPC server is not listening. (Exception from HRESULT: 0x800706B3)
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.WmiProvider.RSWmiAdmin.ThrowOnError(ManagementBaseObject mo)
at Microsoft.ReportingServices.WmiProvider.RSWmiAdmin.GenerateDatabaseScript(String databaseName, Int32 lcid, Boolean isSharePointIntegrated, String& script)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.GenerateDatabaseScript(String databaseName, Int32 lcid, Boolean isSharePointIntegrated, String& script)I have both SQL*Server 2012 and SQL*Server 2017 installed on same notebook ..
Am starting to think I should remove both and just install a new clear SQL*Server 2017 (only) .. - allan.ford17 - Thursday, October 18, 2018 5:59 PMThis is a dumb question from a newbie .. sorry ..
How do I know what my Report Server is called?
(i.e. when prompted in Report Builder)I can see various possibilities in Report Server Configuration Manager.
Is there an instruction set /tutorial for config of SSRS?
Maybe I have two ...?
Should I use a virtual service account or a domain/user account (on home notebook) ?
I get this log upon change from virtual to domain/user account:
Starting report server "SQLServerReportingServices" on ASUS_NOTEBOOK.
The task completed successfully.Stopping report server "SQLServerReportingServices" on ASUS_NOTEBOOK.
The task completed successfully.Reserving url http://+:80
The url was successfully reserved.Removing url http://+:80
The url was successfully removed.Starting report server "SSRS" on ASUS_NOTEBOOK.
The task completed successfully.Setting Windows Service Identity to Windows Account
The Windows account information used to run the Windows service has been updated.Stopping report server "SSRS" on ASUS_NOTEBOOK.
The task completed successfully.When I try to create a new reporting services database in ASUS_NOTEBOOK\MSSQLSERVER01 I get this error which I do not know how to resolve:
Microsoft.ReportingServices.WmiProvider.WMIProviderException: An error occurred when attempting to connect to the report server remote procedure call (RPC) end point. Verify that the Report Server Windows service is running, and then retry the operation.---> System.Runtime.InteropServices.COMException: The RPC server is not listening. (Exception from HRESULT: 0x800706B3)
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.WmiProvider.RSWmiAdmin.ThrowOnError(ManagementBaseObject mo)
at Microsoft.ReportingServices.WmiProvider.RSWmiAdmin.GenerateDatabaseScript(String databaseName, Int32 lcid, Boolean isSharePointIntegrated, String& script)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.GenerateDatabaseScript(String databaseName, Int32 lcid, Boolean isSharePointIntegrated, String& script)I have both SQL*Server 2012 and SQL*Server 2017 installed on same notebook ..
Am starting to think I should remove both and just install a new clear SQL*Server 2017 (only) ..You have two reporting services - one is running, one is not.
For Report Builder, you would want to use the Report Server Web Service URL
Did you install and leave to where you need to configure? The one you tried to create new databases doesn't look to be running.
If you are having a hard time figuring out the different services and which is 2012 and which is 2017, you may want to have just one install to use and get more familiar with each of the services. There are articles on configuring Reporting Services but I suspect some of what you are running into is related to having two sets (2012 and 2017) installed.
The different configuration steps are listed in the following documentation:
Configure and Administer a Report ServerSue
-
I wondered what account the service is meant to be running as?
(if people can check / advise ? I would be most grateful )thanks
-
I managed to get SSRS working on home notebook, in terms of Web Browser display.
I uninstalled SQL*Server 2012 .. just leaving me with SQL*Server 2017.
I uninstalled "Microsoft SQL Server Reporting Services" via Control Panel and "programs and features" option ..
I re-installed "Microsoft SQL Server Reporting Services" (i.e. I downloaded and ran item SQLServerReportingServices.exe )After this fresh install ... the account that the "SQL Server Reporting Services" service runs as is: "NT SERVICE\SQLServerReportingServices" .. i'm not sure what the password for this is .. or if I am meant to know (or need to know) what the password for this account is ..(?)
The URL (for me) is http://ASUS_NOTEBOOK:80/ReportServer
(which changes to http://asus_notebook/Reports/browse/ upon choosing this) .. - allan.ford17 - Thursday, November 29, 2018 8:43 PM
NT SERVICE\SQLServerReportingServices is a virtual account which is used when you use one of the built in local accounts (you used local system). In the previous screenshot, you were looking at it in Services. You never want to mess with the SQL Server service accounts using this. For Reporting Services, use the Reporting Services Configuration Manager. Otherwise for the others, use SQL Server Configuration manager. When you use those tools, it will manage the necessary permissions.
When you use builtin accounts, you don't need to specify passwords as you won't have those - it's managed by the OS. For more information on the service accounts, check this document:
Configure Windows Service Accounts and PermissionsSue
-
Thanks for this reply Sue.
An excellent online training course for SSRS by Lynda.com is ":Advanced SQL Server: Reporting Services"
I completed this one and I have learnt SSRS quite well by now. SSRS is running fine on home notebook including the web console part of SSRS.status bar at bottom shows:
SSRS web console is like this:
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply