Tag Archives: Installation

Installing .NET 3.5 Framework in Windows Server 2008 R2

Posted on by
5

This article will guide through the steps to install .NET Framework 3.5 on a Windows Server 2008 R2.

I recently installed and started working on a Windows Server 2008 R2 Enterprise. I started installing SQL Server and I knew SQL Server 2008 requires the Microsoft .NET Framework 3.5 to be installed on the machine. The installation wizard displayed the following message box (picture below), which is common. (as I had previously installed SQL Server 2008).

I clicked OK button and the setup started loading the required components and immediately displayed the error message (picture below), asking to install .NET Framework from Role Management Tool.

To install roles on a Windows Server the roles have to be added in the Server Manager. So I opened the Roles node from the tree structure in the Server Manager and what you see below is what it looks like (only required portion of the screen is shown to make the images smaller and tidy). On the right side, Add Roles is available and we need to select / click that.

Upon selecting Add Roles, the Add Roles Wizard is displayed as shown below. I selected Application Server and on selecting it, there is a description available on the right side, what that role is going to provide or include.

The following information message box is displayed informing that to install an Application Server, there are certain other required features we need to include. All we need to do is to click the Add required features button in the message box.

It would then display the dialog box giving a short information of what an Application Server does. Click Next to continue.

I choose some additional roles apart from Application Server role, and the dialog box below is a confirmation of all the selections, click install to start the installation process.

The Installation begins. (Picture Below)

The installation is successful and the picture below is the dialog box confirming the success of the installation of the roles that we have chosen.

With that, the prerequisite for installing a SQL Server 2008 Instance is met, and we can continue installing SQL Server 2008.

Do you like this site? Like our FB page @ Facebook.com\LearnSQLWithBru that let’s you know when there is a new blog post.

–Bru Medishetty

Installing SQL Server 2005 Service Pack 3

Posted on by
6

In this Blog we shall take a look at the steps to be carried out for Installing Service Pack 3 for SQL Server 2005.

Before Installing SP3

Keep in mind to read the Microsoft Technet Articles related to Installing Service Pack 3 for SQL Server 2005. Once installed, the SP3 cannot be uninstalled, you need to completely install SQL Server 2005 Instance from the ground up. Keeping this in mind, always take a Backup of all the System and User Databases on that instance for rollback purpose.

A copy of the Service Pack 3 can be downloaded from the link. SQL SERVER 2003 SP3

Look at the list of bugs that are fixed in SQL Server 2005 SP3 Here

After downloading the executable, go to the directory where it has been downloaded / copied. Double click the executable or right click the Exe File and choose Open in the menu as shown below.

The program finds the Instances installed on the Server.

After the step, the following Dialog box is displayed which is a welcome screen. Click Next to continue…

The Next screen is the License terms for SQL Server 2005 SP3. Choose the option I accept the agreement upon which, the Next Button will be active. (The image below was a screen shot of the default screen of the dialog box)

The next dialog (which is displayed above) provides a list of the Installed components which are available on the current Server. You can make a selection of only those required components to which you need to install the Service Pack. Here, I selected INSTANCE1 which is the Database Engine and other individual components such as Integration Services, Client Utilities etc.

This is one of the advantages in installing a Service Pack in SQL Server. It enables to you apply the Service Pack on a test Instance and test it thoroughly without affecting the other Instance on the same Physical machine.

After making selection of the components to be applied, click Next.

Choose the Authentication Mode to apply the Service Pack, you can choose either Windows Authentication or Mixed Mode, either way the Login needs to have administrative rights on the Server. Click Next

The Error and Usage Reporting Settings are the similar settings you find when Installing a initial Installation of SQL Instance.. Choose what ever applies.

The above dialog displays all the Services that related to SQL Server and running currently, It is suggested that the services are stopped in order not to have a reboot of the SQL Server. I remember, I choose not to stop the Services, and resulted in a reboot., so keep in mind the selection of the choice..

The above dialog box is a summary information box indicating it is ready to start the installation of the service pack. By clicking on the Install Button, you are going to start the Installation, it would not be possible to stop the installation after you click on the Install Button.

The Installation would continue to update the Service Pack for the Individual components as shown in the pictures, above and below.

That concludes the Installation process of Service Pack 3 for SQL Server 2005. Restart the Server to complete the SP3 installation to take effect.

Note: The steps described in this blog are generic, it may be different depending on your environment.

Word of caution: Always perform the installation in test environment and check the SQL Server functionalities and applications that are depending on the SQL Server.

Do you like this site? Like our FB page @ Facebook.com\LearnSQLWithBru to know when there is new content.

–Bru Medishetty

Installing Sample Databases in SQL Server 2005

Posted on by
Reply

You can install sample Databases when Installing SQL Server Instance,  if that was not done, you need to install Sample Databases separately.

In this blog, we will look at the steps in doing that.

As the first step, download the Sample Database that would like to install, I chose AdventureWorks for SQL 2005 in this example.

You can follow this link to download the Sample Databases

Remember the path you downloaded the file to.

Browse the directory where you have downloaded the file, select the .msi file , right click and choose Install. (Picture Below)

The Installation process starts and we will look at each of those steps.

If the Security warning Dialog Box appears, choose Run. (Picture Below)

The welcome screen for the Installation Wizard is displayed, click Next. (Picture Below)

In the License Agreement Dialog, Choose I accept the terms to continue.

The Next Screen displays, the Destination Directory where the Sample Database would be installed to.
By default it will be Data Directory of SQL Server.  Click Next to continue and Install in the default Directory.

Click Install to begin the Installation.

When the Installation is completed, the below shown dialog Box is displayed and click Finish to complete the Installation.

Once you finish this step, you can check whether the Sample Database is installed by going to the Data Directory of your SQL Instance.

Both the Data and Log files are placed in the Data Directory of the SQL Server Instance by the installation that we performed.

Once this part is done, the next thing we have to do is open SQL Server Management Studio (SSMS). In the Object Explorer, Right click on the Databases Node and select Attach.

The attach databases dialog box appears and click Add Button.

When you click the Add button, there will be a window that requires us to locate the .MDF File. By default, it opens the Data Directory of the SQL Instance, so if the AdventureWorks Database Data File (.MDF) is available, select that .MDF File.

After the MDF file is chosen click OK, it will show the Attach Databases dialog box with the details of the MDF file and also the details of all the Database files (Both Data and Log)

Click OK to complete the attaching the Database.

Now you should be able to see the Database in the Databases Node in Object Explorer.

Do you like this site? Like our FB page @ Facebook.com\LearnSQLWithBru to know when there is new content.

— Bru Medishetty

http://learnsqlwithbru.com/images/Adventure10.jpg