Installing SQL Server 2012 on a VM
We are now ready to install SQL Server 2012. Carry out the following steps:
Launch VMWare Player.
Play SQL2012VM and login.
Go to VM | Removable Devices | CD/DVD | Settings.
Change the ISO image file path to the SQL Server 2012 ISO file, and click on OK.
Once you click on OK, the Autoplay window should appear. Click on Run SETUP.EXE as shown in the following screenshot:
Select Installation from the left-hand pane, and choose New SQL Server stand-alone installation or add features to an existing installation, as shown in the following screenshot:
Run Setup Support Rules and click on Next.
For the trial edition, we want to keep the default Evaluation product key selected.
In the License Terms window, select I accept the license terms, and click on Next as shown in the following screenshot:
Possible issues will be flagged in the next window. For our purposes, we expect to see a warning because of the domain controller and the firewall, as shown in the following screenshot:
For security reasons, it is recommended to not install SQL Server on top of the domain controller, as discussed in the article at http://msdn.microsoft.com/en-us/library/ms143506.aspx. For our purposes, this is just a test machine that will not be used as a production box, we can ignore this warning.
In the Setup Role screen, select SQL Server Feature Installation as shown in the following screenshot:
In the feature selection, be sure to choose:
Database Engine Services (all components)
Analysis Services
Reporting Services - Native
SQL Server Data Tools
Integration Services
Documentation Components
Management Tools - Basic
Management Tools - Complete
Feel free to choose additional features you want to try and then click on Next.
The install wizard will now check Installation Rules. If there are any errors reported, be sure to resolve them before continuing with the installation. Click on Next.
In the Instance Configuration window, choose to install Default instance.
The next screen shows the disk space summary for all the features we've chosen so far; click on Next.
In the Server Configuration screen, change the account settings for all services except Full-text Filter Daemon Launcher and SQL Server browser; for other services:
Use
QUERYWORKS\sqlagentand corresponding password for SQL Server Agent.Use
QUERYWORKS\sqlserviceand corresponding password for remaining services.
For the database engine configuration, choose Windows authentication mode. Be sure to click on the Add Current User button to add QUERYWORKS\Administrator as sysadmin to your default instance.
In Analysis Services Configuration, select Multidimensional and Data Mining mode. Click on Add Current User again for users that will have administrative privileges over Analysis Services.
For Reporting Services Configuration, select Install only. We will configure reporting services later.
On the Error Reporting window, leave the checkbox unchecked. Click on Next.
Review your settings in the Ready to Install screen, and click on Install.
Once installation is finished, click on Close.
Now, we need to configure Reporting Services in the native mode. Go to Start | All Programs | SQL Server 2012 | Configuration Tools | Reporting Services Configuration Manager.
Connect to the default instance.
Click on Service Account. Double-check the service account assigned to run Reporting Services. If it is properly set, we do not need to make any changes in this window.
Click on Web Service URL; we will accept the default values. Click on Apply.
Click on Database and then click on the Change Database button. This will launch another set of windows.
Select Create a new report server database.
Leave the default database name as ReportServer, and click on Next.
For Authentication Type, use Service Credentials. Click on Next.
Review your Summary and click on Next.
When the configurations have been successfully applied, click on Finish.
Note that the original Report Server Database screen will now be populated with the newly configured values.
Click on Report Manager URL, and click on Apply.
Test the URL by launching Internet Explorer. In the browser, type
http://localhost/Reports(this is the same URL ashttp://KERRIGAN:80/Reports):
