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]
[Click On Images to See Larger Image]
Reference : Pinal Dave (http://blog.SQLAuthority.com)
Thanks for the screenshots
Now in future when anybody asks anything about 2008 installation, provide them with a link to here
[...] 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 [...]
@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
I installed sql server with these instructions. If I want to access the sql server db using sql developer tool, what should i do?
Hi Pinal,
How do we find out the installed SQL is Client or Server?
select @@VERSION
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?
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
[...] Install SQL Server 2008 – How to Upgrade to SQL Server 2008 – Installation Tutorial This was indeed one of the most popular articles in SQL Server 2008. Lots of people wanted to learn how to install SQL SErver 2008 but they were facing various issues while installation. I build this tutorial which becomes reference points for many. [...]
the screenshots are very useful! thanks