SQL SERVER – 2008 – Install SQL Server 2008 – How to Upgrade to SQL Server 2008 – Installation Tutorial

SQL SERVER 2008 RTM has been released for some time and I have got numerous request about how to install SQL Server 2008. I have created this step by step guide Installation Guide. Images are used to explain the process easier. I had previously written the same article earlier. It seemed necessary to re post it again as request of me posting Step by Step tutorial has increased for quite some time.

Please follow all the steps as it is important that you do not miss any details as this is a very comprehensive tutorial.

SQL SERVER - 2008 - Install SQL Server 2008 - How to Upgrade to SQL Server 2008 - Installation Tutorial 20081

SQL SERVER - 2008 - Install SQL Server 2008 - How to Upgrade to SQL Server 2008 - Installation Tutorial 20082

SQL SERVER - 2008 - Install SQL Server 2008 - How to Upgrade to SQL Server 2008 - Installation Tutorial 20083

SQL SERVER - 2008 - Install SQL Server 2008 - How to Upgrade to SQL Server 2008 - Installation Tutorial 20084

SQL SERVER - 2008 - Install SQL Server 2008 - How to Upgrade to SQL Server 2008 - Installation Tutorial 20085

SQL SERVER - 2008 - Install SQL Server 2008 - How to Upgrade to SQL Server 2008 - Installation Tutorial 20086

SQL SERVER - 2008 - Install SQL Server 2008 - How to Upgrade to SQL Server 2008 - Installation Tutorial 20087

Solarwinds

SQL SERVER - 2008 - Install SQL Server 2008 - How to Upgrade to SQL Server 2008 - Installation Tutorial 20088

SQL SERVER - 2008 - Install SQL Server 2008 - How to Upgrade to SQL Server 2008 - Installation Tutorial 20089

SQL SERVER - 2008 - Install SQL Server 2008 - How to Upgrade to SQL Server 2008 - Installation Tutorial 200810

SQL SERVER - 2008 - Install SQL Server 2008 - How to Upgrade to SQL Server 2008 - Installation Tutorial 200811

SQL SERVER - 2008 - Install SQL Server 2008 - How to Upgrade to SQL Server 2008 - Installation Tutorial 200812

SQL SERVER - 2008 - Install SQL Server 2008 - How to Upgrade to SQL Server 2008 - Installation Tutorial 200813

SQL SERVER - 2008 - Install SQL Server 2008 - How to Upgrade to SQL Server 2008 - Installation Tutorial 200814

SQL SERVER - 2008 - Install SQL Server 2008 - How to Upgrade to SQL Server 2008 - Installation Tutorial 200815

SQL SERVER - 2008 - Install SQL Server 2008 - How to Upgrade to SQL Server 2008 - Installation Tutorial 200816

SQL SERVER - 2008 - Install SQL Server 2008 - How to Upgrade to SQL Server 2008 - Installation Tutorial 200817

SQL SERVER - 2008 - Install SQL Server 2008 - How to Upgrade to SQL Server 2008 - Installation Tutorial 200818

SQL SERVER - 2008 - Install SQL Server 2008 - How to Upgrade to SQL Server 2008 - Installation Tutorial 200819

SQL SERVER - 2008 - Install SQL Server 2008 - How to Upgrade to SQL Server 2008 - Installation Tutorial 200820

SQL SERVER - 2008 - Install SQL Server 2008 - How to Upgrade to SQL Server 2008 - Installation Tutorial 200821

SQL SERVER - 2008 - Install SQL Server 2008 - How to Upgrade to SQL Server 2008 - Installation Tutorial 200822

SQL SERVER - 2008 - Install SQL Server 2008 - How to Upgrade to SQL Server 2008 - Installation Tutorial 200823

SQL SERVER - 2008 - Install SQL Server 2008 - How to Upgrade to SQL Server 2008 - Installation Tutorial 200824

SQL SERVER - 2008 - Install SQL Server 2008 - How to Upgrade to SQL Server 2008 - Installation Tutorial 200825

SQL SERVER - 2008 - Install SQL Server 2008 - How to Upgrade to SQL Server 2008 - Installation Tutorial 200826

SQL SERVER - 2008 - Install SQL Server 2008 - How to Upgrade to SQL Server 2008 - Installation Tutorial 200827

SQL SERVER - 2008 - Install SQL Server 2008 - How to Upgrade to SQL Server 2008 - Installation Tutorial 200828

I hope you find this tutorial helpful. If you are working with the latest version of the SQL Server, still this tutorial of installing SQL Server is valid as most of the steps are still the same.

The one thing I really like about SQL Server is the most is that it is very easy to install. I have personally installed multiple SQL Server in the past and most of them, I have installed in less than 1 hour. If you have experience with other popular RDBMS which serves the enterprise, it is quite possible that the installation will take over a day sometimes.

Reference: Pinal Dave (https://blog.sqlauthority.com)

Solarwinds
, ,
Previous Post
SQL SERVER – Roadmap of Microsoft Certifications – SQL Server Certifications
Next Post
SQL SERVER – Default Collation of SQL Server 2008

Related Posts

10 Comments. Leave new

  • Thanks for the screenshots

    Now in future when anybody asks anything about 2008 installation, provide them with a link to here

    Reply
  • @Jerry,

    Also you may wanna take a look @ the primer resource @ MSDN, when upgrading

    https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2005/ms143393(v=sql.90)

    Thanks

    Reply
  • I installed sql server with these instructions. If I want to access the sql server db using sql developer tool, what should i do?

    Reply
  • Hi Pinal,

    How do we find out the installed SQL is Client or Server?

    Reply
  • Paul Fenstermacher
    November 9, 2011 8:10 pm

    We develop applications that use SQL Server, Oracle (Linux, Windows), Sybase (Solaris) and other DBMS.

    I wish there was some way to install the SQL Server 2008 R2 Enterprise product without creating any instance.

    This is because when we build up a new system from scratch, at the point where we perform commercial software installs, our standard is that none of our in-house developed software is installed at that time. It gets installed later, after all the commercial software, via an in-house aotumated process.

    So for example, with Sybase and Oracle, we install only the COTS product during an early stage of the system build-up. The installation of the COTS products is the responsibility of System Administrator, not the DBAs.

    Much later in system build-up, our scripts that create the Sybase server/databases and Oracle instance/schemas are installed. Creating the Sybase server/databases and Oracle instance/schemas are DBAs responsibility.

    With MS SQL Server there does not seem to be to any way to avoid creating a database instance when the MS SQL Server COTS is installed.

    Does anyone know of a method to do this?

    Reply
  • Hi,
    I wonder if you seen this before. We recently upgraded to sql 2008 r2 (From 2000 instance). Very few stored procedures broke. The reason is, in the select statement it has two periods.

    For example: Select p..ProjectsNumber From Project

    Do you think it;s upgrade issue? I didn’t find any details about it so far :(

    Thanks
    Vikas

    Reply
  • the screenshots are very useful! thanks

    Reply
  • after installing sql 2008 evaluation. ram doesn’t get released it keeps fill after all users logged out. Physical memory gets full and users get database not connected. no more users can log in or work. Please give me a solution for this problem. i cant restrict memory usage performance will go down.

    Reply
  • But you didn’t put any link to download it !!

    Reply

Leave a Reply

Menu