December 29, 2009 at 6:19 am
The former DBA responsible for SQL Server 2005 left the organization unexpectedly, and, sadly, he was allergic to writing documentation. We work in a very secure environment, without local console access to the SQL Server machines, but we have SQL Server sa accounts.
Is there a query that we can run to determine if Reporting Services, etc. is installed on a given instance?
December 29, 2009 at 6:28 am
Only thing I could recollect is to run the following command.
Select [NAME] ,DATABASE_ID from Master.sys.databases where [Name] like '%$%TempDB'
If the command returns any rows, then it would be an indication that Reporting Server is installed. the reason I say it is an indication is, it may also be a user created database.
But I tried looking in all of my Reporting Server TempDB's the Database_ID in the above mentioned table is 6. Hope it may be useful.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 29, 2009 at 7:29 am
Thanks. This helps. I see a couple databases named ReportServerTempDB and one named MossReportTempDB. I'm not sure what MossReportTempDB is. Is that a "standard" database name for Microsoft Office SharePoint?
December 29, 2009 at 7:49 am
May be, I have not worked on Sharepoint, but MOSS usually indicates that.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
January 15, 2010 at 2:11 pm
You could also list the services through SQL as well, this will tell you if the reporting services portion was installed, won't tell you if it is configured\used
create table #test (test nvarchar(max))
insert into #test
exec master..xp_cmdshell 'net start'
select * from #test
drop table #test
Andrew
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply