Before I actually start explaining and demonstrating how to build SQL Server Reporting Service (SSRS) reports there are few things you must have installed or restored before you can begin. As mentioned in my previous post, SQL Server 2012 for Beginners, this is a journey. While the first part of the journey is focused on SSRS, there is a possibility that we may take short excursions that explain or demonstrate other features and capabilities of SQL Server. As with the case of this post.
Let's get started.
I am going to go against the main purpose of these blog posts by assuming that the first 4 have already been installed, configured, and that you have been given access to the Database Engine and the Report Server. With that said, I am going to back track eventually and explain how to install and configure each in future posts. Hopefully, that is ok for now. If not, please feel free to contact me and I would be happy to direct you to resources that could assist you in getting these set up. One thing that I can suggest is that you go out and pre-order a copy SQL Server 2012 Step By Step (SHAMELESS PLUG), which explains how to setup and configure each.
Now that you have all the required tools in place, the next step is the restore the database that will be used throughout the demonstrations. You can click HERE to download the backup file. Ensure that the account that is specified to run the SQL Server Database engine has access to the download location.
Using SQL Server Management Studio (SSMS) you can restore a database several ways. In this posting I will explain how to restore a database using SSMS Graphical User Interface (GUI) and TSQL. Since these are introductory posts the main focus will be on the GUI, however I will provide a sample (Transact SQL) T-SQL script that restores the database.
Once the database restore is complete you can begin querying its contents. If you receive any errors or have any questions about the contents of this post please feel free to post a comment here.
RESTORE DATABASE [ContosoSchoolsDW]
FROM DISK = N'C:\SQL Server\backup\ContosoSchoolsDW.bak'
FILE = 1,
MOVE N'CrescentSchools' TO N'C:\SQL Server\data\CrescentSchools.mdf',
MOVE N'CrescentSchools_log' TO N'C:\SQL Server\log\CrescentSchools_log.ldf',
STATS = 5
Note: If you have already restored the ContosoSchoolDW you will receive and error if you execute the query.
In the next post, Creating a SQL Server Reporting Service Project, I will discuss the differences between a solution and a project and provide the steps to create both.
Talk to you soon,
Patrick LeBlanc, Microsoft, Technical Solutions Professional SQL Server and Business Intelligence