Home > SQL Server > Installation SQL Server Part 2

Installation SQL Server Part 2


STEP 13 : Server Configuration

This step allows you to set up the service accounts that will be used to run SQL Server. If you have created Windows NT or Active Directory accounts for use with services, use these.

If not, then just to get the installation up and working, use the built-in Network Service account for all three services listed (this account does not require a password).

This allows SQL Server to start up after installation. However, it can be easily changed later to another account through the Services applet (Control Panel -> Administrator Tools -> Services):

In addition, remember to change the Startup Type to Automatic, for all three services. This automatically starts the SQL Server database engine, SQL Agent and SQL Browser services when the server is re-booted.

The first service runs the SQL Server database engines executable process. The other two services allow scheduled jobs to run after installation (and after a re-boot), and allow the SQL Server to be found by clients on the network.

Do not worry about changing the collation tab, unless there is a specific requirement for anything other than the default collation sequence. Finally, click on Next.

STEP 14 : Database Engine Configuration – Account Provision

This screen allows you to set up database engine security.

Change the Authentication Mode to Mixed Mode unless you are certainyou only need Windows-only authentication.

  • Many third party applications rely on SQL Server logins to operate correctly, so if you are setting up a server for a third party application, rather than one developed in-house, enabling Mixed Mode authentication is a good idea.

If you pick Mixed Mode security, you must also enter a password for the sysadmin account (sa).

Enter and confirm a secure password for the sa account and keep it somewhere safe. Do not give it to any one you do not want to have access to the SQL Server.

Note that you MUST also provide a Windows NT account on the local machine as a SQL Server administrator. If you do not want Windows system administrators to be able walk up to the box and login to SQL Server, create a new, local, dummy Windows user and add this account instead. Otherwise, add in the local administrator account, or your own Windows account on the domain in which the SQL Server will reside.

STEP 15 : Database Engine Configuration – Data Directories

Click on the Data Directoriestab.

Change the directories to specify which drives in your system will be used for the various types of database files.

Generally it’s advisable to put the User database directory and User log directory on separate physical drives for performance, but it will depend on how Windows has been configured and how many disk drives you have available.

If you are installing on a single drive laptop or desktop, then simply specify:

Data root directory
C:\Program Files\Microsoft SQL Server

User database directory
C:\Data

User log directory
C:\Logs

Temp DB directory
C:\TempDB

Temp Log directory
C:\TempDB

Backup directory
C:\Backups

Do not click on the FILESTREAM tab unless you know you need to change these options, as it is not generally required for most installations, but can easily be changed by using sp_configure ‘filestream_access_level’, ”after SQL Server has been installed. Click on Next.

STEP 16 : Error Usage Reporting

This screen simply asks if you want to send error information to Microsoft and can safely be skipped if you do not want to share any information.

Click boxes if you want to help Microsoft help you.
Click on Nextagain…

STEP 16 : Installation Rules

This screen simply checks if there are any processes or other installations running which will stop the installation of SQL Server 2008.

Click on Nextagain – you’re almost ready to install:

STEP 17 : Ready to Install

This screen summarises what you are about to install and gives you a last chance to cancel or change anything that’s wrongly configured:

Check that what’s being installed is what you want and then click on Installwhen you’re sure you want to start the installation process:

Installation Progress

SQL Server 2008 will now install. How long it takes depends on the speed of your machine, what load it’s under, the installation media (CD is slower) and what you’ve chosen to install.

…More Installation Progress

… and Finally
Finally, the installation will complete:

…and the following dialog box will appear:

Click on OK, the machine will NOT reboot.
The following will appear:

…followed by:

Click on the Next button again…

STEP 18 : Installation Complete

The following screen appears:

It may be worth clicking on the installation log at the top of the screen to check everything’s gone as expected. Not that this is MUCH smaller than the usual SQL Server installation log files of old.

Finally, click on the Close button. The following dialog will appear:

Click on OK – your server will NOT re-boot at this point.

The dialog box will disappear and you will be returned to the Installation Center:

Link Related : http://www.sqlserverclub.com/essentialguides/how-to-install-sql-server-2008-step-by-step-guide-part-2.aspx

Advertisements
Categories: SQL Server
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: