Solved

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

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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Help with t-sql finding "latest" record in table 10 40
Job - date manual 1 35
Are triggers slow? 7 12
SQL Server Shrink hurting performance? 4 21
After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

829 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