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

« SQL SERVER – Roadmap of Microsoft Certifications – SQL Server Certifications

SQL SERVER – Default Collation of SQL Server 2008 »

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

December 2, 2008 by pinaldave

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 wrote 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.

[Click On Images to See Larger Image]

Reference : Pinal Dave (http://blog.SQLAuthority.com)

Posted in Database, Pinal Dave, SQL, SQL Authority, SQL Documentation, SQL Download, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology | Tagged Howto | 7 Comments

7 Responses

on December 2, 2008 at 9:16 pm | Reply Jerry Hung

Thanks for the screenshots

Now in future when anybody asks anything about 2008 installation, provide them with a link to here
on December 3, 2008 at 10:00 am | Reply SQL SERVER - Default Collation of SQL Server 2008 Journey to SQL Authority with Pinal Dave

[...] 3, 2008 by pinaldave Recently I wrote article about SQL SERVER – 2008 – Install SQL Server 2008 – How to Upgrade to SQL Server 2008 – Installation Tutor…, I received couple of comment suggesting that I did not talk about SQL Server default collation [...]
on October 30, 2009 at 2:12 am | Reply Anil Mahadev

@Jerry,

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

http://msdn.microsoft.com/en-us/library/ms143393(SQL.90).aspx

Thanks
on June 27, 2010 at 11:27 am | Reply sa

I installed sql server with these instructions. If I want to access the sql server db using sql developer tool, what should i do?
on July 15, 2011 at 5:13 pm | Reply Shaiju CK

Hi Pinal,

How do we find out the installed SQL is Client or Server?
- on July 18, 2011 at 5:03 pm | Reply madhivanan
  
  select @@VERSION
on November 9, 2011 at 8:10 pm | Reply Paul Fenstermacher

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?