Creating a SQL Server 2012 playground (part X)

Introduction

SSDT is the replacement of BIDS and Visual Studio for Database developers. Also, it includes features from SSMS (James Serra). There seems some confusion about the installation of SSDT BIDS version and the SSDT Database developer version. Somehow some parts are not installed depending on the way you install SSDT. As James states, when you install SSDT during the feature selection window in the installation process of SQL Server 2012 only the BIDS version is installed and not the Database Developer version. If you didn't install SSDT with the SQL Server installation iso and downloaded it from Microsoft then it will install the Database developer functionality, only. So watch out and be careful with this installation of SSDT. 

During the installation of SQL Server 2012 I've selected the SSDT BIDS Version and therefore I need to install the SSDT DB Developer functionality too. This will be explained in this blogpost and I'll show the installation of SSDT Power tools.



This blogpost is one in a series of blogposts:

• Creating a VM environment with virtualbox (part I).

• Configuration of the domain controller (part II).

• Creating AD users and installing SQL Server 2012 (part III).

• Installation of Sharepoint (part IV).

• Adding the tabular mode instance to the SQL Server installation (part V).

• Adding the powerpivot mode instance to the SQL Server installation (part VI).

• Configuring SharePoint Central Administration (part VII).

• Installing Reporting Services Sharepoint mode as Single Server Farm (part VIII).

• Installing MS SQL Server Powerpivot for Excel 2010 (part IX).
• Installation of SSDT and the SSDT Power tools (part X).
• Installation of Contoso and AdventureWorks databases (part XI).
• Installation of Master Data Services (part XII).
• Installation of Data Quality Services (part XIII).
• etc.

Installation of SSDT DB Developer functionality

Download the SSDT DB Developer software from the Microsoft download center. I've used the web installer but it's also possible to download the software and install this on multiple machines.

The first screen is like below.

Press Install and the installation of SSDT takes place.

Installation of SSDT Power tools

The next thing to do is the installation of SSDT power tools. You can download this from Microsoft.

But, if you start up Visual studio 2010 and click on Tools, Extension manager and Updates, you'll get a list of all kind of extension for Visual Studio that can be download from Microsoft. When you scroll down a bit the SSDT Powertools is listed.

Press install and after a restart of Visual Studio the extenstion is installed:

It has been a while we have run Windows Update. Let's do it now before we proceed installing more software.

Conclusion

This blogpost is about the installation og SSDT and SSDT Powertools

Greetz,
Hennie

Creating a SQL Server 2012 playground (part IX)

Introduction

In this blogpost I'll explain the installation of Powerpivot for Excel installation (download the 64 bit version). You can download the software from MSDN. Powerpivot is an add-in for Excel 2010 and  can be used to include Powerpivot data in Excel. There is also the ability to share the analysis with Microsoft Sharepoint 2010.

This blogpost is one in a series of blogposts:

• Creating a VM environment with virtualbox (part I).

• Configuration of the domain controller (part II).

• Creating AD users and installing SQL Server 2012 (part III).

• Installation of Sharepoint (part IV).

• Adding the tabular mode instance to the SQL Server installation (part V).

• Adding the powerpivot mode instance to the SQL Server installation (part VI).

• Configuring SharePoint Central Administration (part VII).

• Installing Reporting Services Sharepoint mode as Single Server Farm (part VIII).

• Installing MS SQL Server Powerpivot for Excel 2010 (part IX).
• Installation of SSDT and the SSDT Power tools (part X).
• Installation of Contoso and AdventureWorks databases (part XI).
• Installation of Master Data Services (part XII).
• Installation of Data Quality Services (part XIII).
• etc.

Installation of Powerpivot for Excel

Installation of Microsoft office
The first step in this blogpost is installing  Microsoft Office 2010. If you run the setup process automatically it will install the 32 bit version. Therefore execute the setup in the 64 bits subfolder of the installation iso.  

Install .net framework 4.0
The next step is the installation of .net Framework 4.0. You can download this from the microsoft download center. There is not much to say about the installation. Just install the .net framework and you're done.

Installation of Visual Studio 2010 Tools for Office Runtime
The installation of Visual Studio 2010 Tools for Office Runtime is also very straightforwared. The Visual Studio 2010 Tools for Office Runtime can be downloaded from Microsoft download center too.

Installation of Powerpivot for Excel
The installation of Powerpivot for Excel is also a very straightforward process and easily done

Check it out
Finally, let's check the installation of powerpivot by opening Excel and click on the Powerpivot ribbon.

Conclusion

In this blogpost I've described an easy installation of Microsoft Office and Powerpivot

Greetz,
Hennie

Creating a SQL Server 2012 playground (part VIII)

Introduction

In this blogpost I'll show the installation you  the Reporting Services Sharepoint mode as a Single Farm. The steps include installation of some Features of SQL Server 2012 and a configuration of Sharepoint 2010 Central administration. I've used an article on MSDN for this blogpost.


This blogpost is one in a series of blogposts:

• Creating a VM environment with virtualbox (part I).

• Configuration of the domain controller (part II).

• Creating AD users and installing SQL Server 2012 (part III).

• Installation of Sharepoint (part IV).

• Adding the tabular mode instance to the SQL Server installation (part V).

• Adding the powerpivot mode instance to the SQL Server installation (part VI).

• Configuring SharePoint Central Administration (part VII).

• Installing Reporting Services Sharepoint mode as Single Server Farm (part VIII).

• Installing MS SQL Server Powerpivot for Excel 2010 (part IX).
• Installation of SSDT and the SSDT Power tools (part X).
• Installation of Contoso and AdventureWorks databases (part XI).
• Installation of Master Data Services (part XII).
• Installation of Data Quality Services (part XIII).
• etc.

Installing RS Sharepoint in Single Server Mode

Run the SQL Server 2012 installation wizard again and click on "installation".  Choose New SQL Server stand alone installation or add features to an existing installation. Press a couple of times on "OK", "Next" and "Install" until you reach the following window.

Confirm that the options are selected in the red box of the window below.

If they are unchecked install them.

Configuring SharePoint Central Administration

Now the necessary files are already installed during the installation process of SQL Server 2012 ( (part III).  But, the Services need to be registered into the Sharepoint Farm. Therefore some cmdlets needs to be run. Goto Start, Microsoft SharePoint 2010 Products and right click on SharePoint 2010 Management Shell and Click Run as Administrator.

If you haven't configured Sharepoint 2010 the following information is shown. Go to the blogpost VII for configuration of Sharepoint 2010.

Here the error again:


Error "The local farm is not accessible. Cmdlets with FeatureDependencyId are not registered.".

I checked whether the integration of SQL Server Reporting Services Service Application in sharepoint  has happened by opening Central Administration and press on  Manage Service Applications > New and it didn't show up here. If you have configured Sharepoint properly then the error message is not presented. Run the following code

Install -SPRSService

This gives an error because there is a space between Install and -SPRSService.

Correct this to

Install-SPRSService

The following result is shown.

Then execute the following code

Install-SPRSServiceProxy

And

get-spserviceinstance -all |where {$_.TypeName -like "SQL Server Reporting*"} | Start-SPServiceInstance

Now check the Service applications in the Aplication Management section and now the Application is present.

Create a Reporting Service Service Application

In this paragraph I'll explain the basic configuration of the SQL Server Reporting Services Service Application.  As with most of Service Applications you need to provide some base configuration 

Now it's time to watch whether the configuration succeeds.

Once it is finished it will show the following window.

Now check whether the application is installed correctly. 

Conclusion

This blogpost is about installing a single server installation of a Reporting Services report server in SharePoint mode.

Greetz,
Hennie

Creating a SQL Server 2012 playground (part VII)

Introduction 

In this blogpost I'll guide you through a single server installation of a Reporting Services Report Server in SharePoint mode. The steps include running the SQL Server installation wizard as well as additional configuration tasks that use SharePoint 2010 central administration. A single farm is meaningful for a test or a development environment. This is not recommended  for a production environment.



This blogpost is one in a series of blogposts:

• Creating a VM environment with virtualbox (part I).

• Configuration of the domain controller (part II).

• Creating AD users and installing SQL Server 2012 (part III).

• Installation of Sharepoint (part IV).

• Adding the tabular mode instance to the SQL Server installation (part V).

• Adding the powerpivot mode instance to the SQL Server installation (part VI).

• Configuring SharePoint Central Administration (part VII).

• Installing Reporting Services Sharepoint mode as Single Server Farm (part VIII).

• Installing MS SQL Server Powerpivot for Excel 2010 (part IX).
• Installation of SSDT and the SSDT Power tools (part X).
• Installation of Contoso and AdventureWorks databases (part XI).
• Installation of Master Data Services (part XII).
• Installation of Data Quality Services (part XIII).
• etc.

Configuring Microsoft Sharepoint 2010  

Go to start Microsoft Sharepoint 2010 Products and click on Central administration. That will show the following starting screen of the configuration wizard. You are asked to particpate in a Custom experience improvement program.  Press Next.

A warning show up that some services are about to restart on the server.

On the "Specify Configuration Database Settings" page enter your database server name. Enter the required database name for the SharePoint Configure database. Type the Username and Password to access the Database.

Press Yes.

In the "Connect to a Server farm" choose to create a new server farm.

On the "Configure SharePoint Central Administration Web Application" page, you can accept the randomly generated port number or click the checkbox against Specify port number to enter required port number. Specify the Configuration Security Settings. I choose to use Kerberos.

Press Yes.

Review the configuration settings defined in previous steps will be displayed on "Completing the SharePoint Products Configuration Wizard". Click the Next button to continue.

Wait until the configuration is finished.

And the configuration was succesful.

Then internet explorer pops up and where the configuring goes further:

When the configuring is done the processing screen is shown. It takes a lot of processing time.

After a while the VM reboots and in my case the screen stayed black (with the Winodws startup progress bar) for hours. I checked the processing and the disk usage and that indicated there was activity. But after a hour or something i decided to a "cold reboot". Windows checked up and everything seems normal.

Conclusion

This blogpost was about the configuration of Sharepoint 2010 SP1. Most of the configuration is simple and straight forward.

Greetz,
Hennie

Resize a fixed harddisk (.vhd) in VirtualBox

Introduction

I'm using VirtualBox for a while now and it's an easy to use product. But, there are some things that can be done easier with VMWare. For instance resizing a disk. There seems to be a problem with the disk I've created (during the blogpost serie of "Creating a SQL Server 2012 Playground").  I've selected the fixed instead of dynamic one. And now I've found out that my diskspace is to small to install more software. In this blogpost I'll describe a solution for enlarging a VirtualBox static disk.

The problem

An error appears when you try enlarge the disk with the commandline command "VBoxManage" :

       
VBoxManage modifyhd "D:\VirtualBox VMs\NewSQL
Server2012Playground\NewSQLServer2012Playground.vhd" --resize 30000

results in

0%...
Progress state: VBOX_E_NOT_SUPPORTED
VBoxManage.exe: error: Resize hard disk operation
for this format is not implemented yet!
       
 

Solution

Great! Well there seems to be a solution. Someone has built a small tool to turn the static disk into a dynamic disk and it enlarges the disk too. The tool is named Clonevdi.

It will recreate another disk (clone). Therefore you need to change the disk from the old disk to the cloned disk. On the host system, start VirtualBox, and select the virtual machine whose hard disk you are expanding, and navigate to Settings, Storage. Change the SATA Controller so that it uses the new virtual disk file instead of the old one.

When this is ready it's possible to expand the disk with computermanagement (extend volumne)

Conclusion

In this blogpost i've described a solution for enlarging the static disks in Virtual Box. I thought I was in trouble but thankfully a tool helped me out.

Greetz,
Hennie

Creating a SQL Server 2012 playground (part VI)

Introduction

In this blogpost I'll describe the installation of SSAS for powerpivot for Sharepoint.  Installation of Powerpivot provides the ability to view and store workbooks in sharepoint 2010.


This blogpost is one in a series of blogposts:

• Creating a VM environment with virtualbox (part I).

• Configuration of the domain controller (part II).

• Creating AD users and installing SQL Server 2012 (part III).

• Installation of Sharepoint (part IV).

• Adding the tabular mode instance to the SQL Server installation (part V).

• Adding the powerpivot mode instance to the SQL Server installation (part VI).

• Configuring SharePoint Central Administration (part VII).

• Installing Reporting Services Sharepoint mode as Single Server Farm (part VIII).

• Installing MS SQL Server Powerpivot for Excel 2010 (part IX).
• Installation of SSDT and the SSDT Power tools (part X).
• Installation of Contoso and AdventureWorks databases (part XI).
• Installation of Master Data Services (part XII).
• Installation of Data Quality Services (part XIII).
• etc.

Installation of SSAS for powerpivot for Sharepoint

In one of my earlier blogposts (part V) I've already described the installation of the Tabular mode and  these steps taken are almost equal to the installationsteps of the SQL Server Powerpivot for Sharepoint. Therefore I'll not show all the windows but only a selection of the most important windows.

So startup the setup of the SQL Server 2012 installation and choose for a new installation, run the setup support rules and press a couple of times on Next and you'll see the following window. There is an option on the Setup Role screen to add a SQL Server database engine to the installation. Since we already have a brand new instance of SQL Server Relational Engine installed earlier, I unselect this option. Press Next...

The following window appear

If you don't have Sharepoint Enterprise installed you'll get an error.

A more detailed message

When you have installed the Sharepoint Enterprise version you're allowed to pass and install the Powerpivot instance. Successful!

Conclusion

Important to notice is the inevitable Enterprise edition of Sharepoint 2010 (and not standard).  Generally speaken, the installation is smooth and easy.

Hennie