Solved

How would I know if SQL Server 2008 R2 is installed?

Posted on 2010-09-15
3
1,425 Views
Last Modified: 2012-05-10
We have a SQL Server 2008. We actually have 2 servers and I have both versions below.

We need to have "ReportBuilder 3.0" and based on this link, that comes with SQL Server 2008 R2. http://technet.microsoft.com/en-us/library/dd207038.aspx

"The ClickOnce version of Report Builder is installed with SQL Server 2008 R2 Reporting Services"

But how would I know if SQL Server 2008 R@ Reporting Services is installed to begin with?
0
Comment
Question by:Camillia
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 2

Accepted Solution

by:
cetafudd earned 250 total points
ID: 33686029
Go to START and find/open the SQL Server Configuration Manager
Select SQL Server Services
On the right panel it will show all installed services and their status (Running, Stopped)... Check if SQK Server Reporting Services is there

If your SQL version is 2008 R2 and the REporting Services is running then it is the R2 one.  To check your version run the following query: SELECT @@VERSION

0
 
LVL 8

Assisted Solution

by:dba2dba
dba2dba earned 250 total points
ID: 33686557
You can find the Version of SSRS following the below link:

http://technet.microsoft.com/en-us/library/bb630446.aspx
0
 
LVL 7

Author Comment

by:Camillia
ID: 33686833
thanks, let me check.
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

695 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question