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
certain you 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 Directories tab.
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
Next again…
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
Next again – 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
Install when 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:
Click on the Close button (the “x”) in the top right of the screen.
Finally, manually reboot your machine to complete the SQL Server 2008 installation.
Top Tips :
How to check that SQL Server 2008 has installed correctly
Here are a short number of post-installation checks which are useful to
perform after re-booting your new SQL Server. You don’t have to run
these, and there are other ways to check, but they are very useful for
non-DBAs to be sure that the installation is basically sound and a
connection can be made to the new SQL Server before handing it over to
someone else.
Check 1: Has the SQL Server Service Started?
Check SQL Server 2008 has started.
Check 2: Does Management Studio Work?
Check Management Studio works by firing it up.
Click on NO when you see this dialog box:
Check 3: Can you run a basic query against the new SQL Server?
Check SQL Server works by running a simple query from Management Studio:
Enter the query shown below and hit F5 to run it:
Check 4: Is SQL Server Agent Running?
Check SQL Server Agent is running for scheduled jobs. There should be a
green arrow next to the SQL Server Agent database symbol (it’s small,
you might have to look hard):
Check 5: Can SQL Server be seen from the Network?
Check that the new SQL Server can be seen from another SQL Server on the same domain by running isql –L (or osql –L):
If you can’t see the new SQL Server in this list, check that the SQL
Server Browser service is started on the machine where you have just
installed SQL Server.
Check 6: Has the TCP/IP network protocol library been enabled on the server?
If the browser service is started but you still cannot connect to the server, click on
Start ->Programs -> SQL Server 2008 -> SQL Server Configuration Manager (on the server where SQL Server’s just been installed)
The SQL Server Configuration Manager window opens.
Click on the
SQL Server Network Configuration node and expand it.
In the example below, we have MSSQLSERVER (a base instance of SQL Server), and SQLEXPRESS showing as installed.
If in doubt, click on
Protocols for MSSQLSERVER.
In the above screenshot, the TCP/IP network protocol library is
disabled. We need to enable it in order that remote servers can talk to
the newly installed SQL Server.
- A word of explanation : In most installations, Named Pipes
can be ignored, unless there is a requirement for it. In virtually all
environments, VIA can also be ignored as this protocol requires a
special network card. Shared memory is the “local” protocol that SQL
Server uses when talking to a client application on the same server as
itself, for example when SQL Server Management Studio connects to it. It
is usually best to leave this enabled.
You will need the TCP/IP protocol enabled if you need to connect to your
new SQL Server from a remote client or another server via TCP/IP, which
is what most networks use.
If it shows as
DISABLED (above),
double click on the TCP/IP protocol line, and the following window will appear:
Ensure that
Enabled is set to Yes, and click on OK.
The following warning will appear:
Click on OK, and you will be returned to the Configuration Manager window, where TCP/IP will now be shown as enabled:
Go back to the Services applet, and re-start the MSSQLSERVER service so
that the TCP/IP protocol can be used to connect to your new SQL Server.
Then try to connect to it again from a remote machine.
If you have experienced problems with the previous connectivity tests,
you should now be able to repeat at least some of them successfully.
