Solved

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

Posted on 2010-09-15
3
1,421 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
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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
GRANT, REVOKE, DENY 4 38
Pivot not using aggregate yield error 3 42
SQL Update Query - What's wrong with this. 18 20
SQL Server - Check Constraint or NOT NULL? 11 69
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

867 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now