June 6, 2013 at 7:14 am
How do i know reporting services and analysis services are installed or not in my sql server.
June 6, 2013 at 7:26 am
How do i know reporting services and analysis services are installed or not in my sql server.=>
1) services.msc => SQL Server Anlysis services(Instance Name).
SQL Server REporting Services (Instance name)
2)There will folder in Drive:\Program File\Microsoft SQL Server => MSAS10.MSSQLSERVER and MSRS10.MSSQLSERVER
3) There will Start => Program => MSSQL server (version ) => Report Services Configration Manager.
June 6, 2013 at 7:34 am
Thanks dineshvishe.
Got it on configuration 🙂
June 6, 2013 at 10:59 am
It's possible for the reporting services service to be installed on another machine (webserver) and the databases to be hosted on your database server. If you patch your db server but not the RS service, bad things can happen.
Try looking for the associated default databases on the db server too:
ReportServer
ReportServerTempDB
June 6, 2013 at 11:29 am
select SQL server Management Studio =>
then select server type----
select Reporting Services/Analysis Services =>
then select Browse from more
Local Server => 1) Analysis Services.
2) Reporting Services.
select one by one and check.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply