Jump to content




anyweb

how can I install SQL Server 2008 in Windows Server 2008



Recommended Posts

In this guide I have used the 180 Evaluation version of Microsoft SQL Server 2008 Enterprise Edition, this was installed on a Windows Server 2008 which had been pre-configured with AD, DHCP, WDS, IIS. This is a LAB environment, and for the purpose of this guide it's irrelevant that AD,DHCP and WDS are running on this server. in production of course you would want to separate server roles.

 

 

Your results may vary, try this on a lab computer to verify the steps needed and how they work for you. This Post is NOT SCCM specific and is provided as is to help you get up and running in a lab environment. The specific roles installed in this sample install are not in any way customised for an SCCM install. In a Production environment, you should consult Technet to verify best practices for where to install SQL and to separate the DB and LOG files to SAN drives if appropriate. If you are installing SQL for SCCM then install it on the same server that you will install SCCM on..

 

 

Insert the DVD or mount the iso (SQLFULL_ENU.iso), once done double click on setup.exe in case it doesn't autorun.

 

sql_requires.jpg

 

If you get a requirements needed message click ok so that it can install them (updated .NET framework and Windows Installer)

 

 

Microsoft .NET Framework 3.5 SP1 update

 

Accept the license agreement for the .NET update and click install

 

 

 

dotnetagree.jpg

 

The actual installation seems to take a few minutes.... if it fails it will give you an error log, you can try installing it again or read the installation issues readme.

 

 

dotnetdone.jpg

 

Windows Installer 4.5 Update

 

Next you may be promted to install a hotfix (KB942288), click Ok.

 

hotfix_ok.jpg

 

if you were prompted to install the hotfix then you'll be asked to Restart, so lets do that...

 

restart_now.jpg

 

after the restart and now that we've updated those two components run setup.exe again from the SQL 2008 iso (dvd). You should see the following

 

sqlsplash.jpg

 

Planning phase

 

click on System Configuration Checker to check our system for any problems that may prevent SQL 2008 from installing/working.

 

In my case i got one warning (telling me that installing SQL server on a domain controller is not recommended) but I choose to ignore that warning.

 

check_done.jpg

 

Clicking ok brings you back to the SQL 2008 main menu, here you can see many more options for your SQL server (hardware requirements, security documentation, release notes, upgrade advisor and more).

 

Installation

 

Click on Installation in the left pane, in the new window that appears, choose the first option which is a new SQL server stand-alone installation.

 

new_install.jpg

 

setup support rules

 

this is turn will do a quick test for setup support rules,

 

setup_support_rules.jpg

 

click ok to continue

 

at this point you can use the drop down menu to select a different SQL version (we dont need to) or input your SQL Server product key, click next when done.

 

product_key.jpg

 

accept the license terms and click next

 

eula.jpg

 

click install to install setup support files...

 

setup_install_files.jpg

 

once again, I was presented with another setup support rules test result this time with two warnings, the domain controller one (safe to ignore) and my windows firewall telling me that the appropriate ports should be opened

 

 

setup_warning2.jpg

 

I clicked next.

 

Feature Selection

 

I chose to Select All and left the path of the install as default.

 

sql_feature_selection.jpg

 

 

Instance Configuration

 

I left these options as default

 

instance.jpg

 

Disk Space Requirements

 

The disk space requirements gave me a green ok arrow, so I clicked next to continue

 

disk_space.jpg

 

Server Configuration

 

Note: if you need to change collation, or verify it then click on the Collation Tab.

 

Otherwise, click on Account Name to the right of SQL Server Agent and enter your the administrator/password values

 

server_config_perms.jpg

 

click next

 

 

Database Engine Configuration

 

You can adjust the user settings here depending on your security preferences

 

Beginning in SQL Server 2005, significant changes were implemented to help ensure that SQL Server was more secure than previous versions. Changes included a “secure by design, secure by default, and secure in deployment” strategy designed to protect the server instance and its databases from security attacks.

 

SQL Server 2008 continues the security hardening process by introducing more changes to the server and database components. SQL Server 2008 leverages the User Account Control (UAC) found in Windows Vista and Windows Server 2008.

 

The changes introduced in SQL Server 2008 further decrease the surface and attack areas for the server and its databases by instituting a policy of “Least Privileged Authority.” This means that internal accounts are protected and separated into operating system functions and SQL Server functions. These measures include:

 

The ability to provision one or more Windows principals into the Sysadmin server role inside SQL Server. This option is available during SQL Server Setup.

 

 

The Surface Area Configuration (SAC) tool has been removed, and replaced by poliyc-based management and changes in the Configuration Manager tool.

 

 

These changes will affect your security planning for SQL Server, and help you create a more complete security profile for your system.

 

for the purpose of this guide, we will add the local administrator by clicking on Add Current User, if this or any options confuse you then click on help in the bottom right corner of the installer.

 

add_current_user.jpg

 

 

For Analysis Services configuration, enter the same value (add current user, assuming you are doing this as local administrator...)

 

analysis_conf.jpg

 

for the Reporting Services configuration, I left the default value (native)

 

reporting.jpg

 

choose your Error and Usage reporting settings and click next

 

error_and_usage.jpg

 

your installation Rules will get a quick check...

 

inst_rules.jpg

 

click next to see 'Ready to install' summary'

 

ready_to_install.jpg

 

click install to start the installation...

 

(time for lots of coffee..)

 

setup_progress.jpg

 

After dinner it was completed

 

sql_server_success.jpg

 

one more click and then it's all completed.

 

completed.jpg

 

:-)

 

sql_2008.jpg

 

Note: This step is optional for troubleshooting Kerberos authentication issues. The named pipes protocol is not required for Configuration Manager 2007 site database operations and should only be used for troubleshooting kerberos authentication problems.

 

Enable Named Pipes and TCP/IP in your SQL server protocols (by default they are disabled), start up your SQL Server Configuration Manager, expand SQL Server Network Configuration in the left pane, and choose Protocols for MSSQLSERVER (or whatever your SQL server instance is called).

 

named_pipes.jpg

 

Right click on named pipes and set to enable, do the same for TCP/IP,

 

named_pipes_and_tcpip_enabled.jpg

 

once done you must Restart the SQL server service (click on SQL Server Services in the left pane, and in the right pane right click on SQL Server (MSSQLSERVER), choose restart

 

sqlserverconfigmanager.jpg

Share this post


Link to post
Share on other sites


Final configuration

 

Give the site server computer account Admin rights to the site system

 

Note: if you have setup SQL on a server which is NOT the active directory domain controller, then merely add the Computer account as a member of the Local Administrators group on that server as in the screenshot below.

 

local_admin_computer_account.jpg

 

However, if you are installing an All In One server (DC with SQL etc...) then do as follows:

 

Start up Active Directory Users and Computers, and verify that Advanced Features are selected under View

 

advanced_features.jpg

 

Select Builtin in the Left pane, highlight Administrators in the right pane and right click, choose properties and click on the Members Tab, click Add.

 

 

add_computer_account.jpg

 

when the Select Users, Contacts, Computers or Groups window appears, choose Object Types

 

select.jpg

 

when the Object Types window appears, put a checkmark in the Computers option

 

object_types.jpg

 

click Advanced, followed by Find Now

 

advanced.jpg

 

find_now.jpg

 

add the computer account by clicking it's name and Ok.

 

computer_account.jpg

 

Click Ok again and now you should see the computer account added

 

added.jpg

 

 

Check TCPIP properties for listening IP address in SQL Server Configuration Manager

 

Start up the SQL Server Configuration Manager, and expand SQL Server Network Configuration on the left pane, highlight Protocols for <Instancename> and double click on TCPIP in the right pane

 

check_ip_in_sql_manager.jpg

 

Click on the IP Addresses tab

 

ip_addresses.jpg

 

change the Status from Disabled (default) to Enabled for both the Servers local ip and localhost values (see screenshots)

 

disabled.jpg

 

enabled.jpg

 

restart the SQL service to make the changes work

 

restart_sql.jpg

 

restart.jpg

 

that's it ! all Done.

 

Side note: To open the firewall for Windows Server 2008 read this post

Share this post


Link to post
Share on other sites

Hi,

 

Could you let me know how to bring up "SQL Server Configuration Manager". I could not find it in All programs menu. SQL Server 2008 was successfully installed on my Windows 2008 Server SP2.

 

Thanks

Share this post


Link to post
Share on other sites

this screenshot is from my sql 2005 lab but it should help you find what you are looking for

sql_server_config.jpg

Share this post


Link to post
Share on other sites

Sorry I did see the "SQL Server Configuration Manager". It is just mixed with other folders and I did not notice it before.

 

Thanks

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×