First Time Installation of SQL Server 2005 Developer Edition

akhlaq768

Just placed the SQL Server 2005 - Developer Edition into my Drive...

I get prompted with the following options..

This DVD contains 32-bit (x86) and 64-bit versions of this edition of SQL Server 2005. Click the link that matches your environment to begin

x86-based operating systems

x64-based operating systems

Itanuim-based operating syystems

I'm new to SQL Server... I just need to start learning how to use it... because it is being used at work... Don't need the all the features installed, just the normal table and query for the moment...

I will be installing it on my PC... i

Microsoft Windows XP - Home Edition - Version 2 - Service Pack 2

My local Hard Drive remaining capacity is 12.6GB

External Hard Drive remaining capacity is 11.0GB

Tried looking everywhere for the answer... lol (even looked at YouTube for a simple installation video....

Thanks for your help

Caddre

You are running the wrong operating system to install the developer edition because you cannot install reporting services in XP home because it comes without IIS. And I also thinks you need more hard disk space, hard drives are cheap see if you can upgrade the hard drive and at least 1gig of ram. XP home only comes in x86 so that is the version you install SQL Server developer edition x86 but reporting services will be disabled because you don't have IIS. Copy everything to a folder in your c drive it is about 1gig and run set up from the C drive don't answer questions you just answer those relevant to you.

akhlaq768

have you guys have an msn messenger account... you can quickly go through the installation with me.. .many thanks...

Caddre

Copy content to your c drive go to x86 then go to server and on the right is setup double click setup and you go from there it is not complicated. It is the easiest SQL Server to install I have installed 7.0/2000/2005. I don't do IM. Hope this helps.

Ekrem Önsoy

You can install SQL Server Developer Edition on Windows XP Home Edition SP2.

You may refer the following link to be sure of this:
http://msdn2.microsoft.com/en-us/library/ms143506.aspx

12 or 11GB is enough for testing purposes.

You LAPTOP must be 32Bit so you must choose "x86 operations systems" option.

Anything else you wonder

Caddre

You cannot install reporting services without IIS that option will be disabled by the installer, that link will not tell you that.

Ekrem Önsoy

As you know, you do not have to be installed IIS to setup SQL Server. IIS is just used for Reporting Services.

Caddre

(XP home only comes in x86 so that is the version you install SQL Server developer edition x86 but reporting services will be disabled because you don't have IIS. Copy everything to a folder in your c drive it is about 1gig and run set up from the C drive don't answer questions you just answer those relevant to you.)

The above was my first reply to this thread I have covered that.

Ekrem Önsoy

akhlaq768 wrote:

I'm new to SQL Server... I just need to start learning how to use it... because it is being used at work... Don't need the all the features installed, just the normal table and query for the moment...

He says that he is a newbie and wanna learn something about SQL Server and doesn't need all the stuff to be installed. So, he just wants to install this piece of software. I'm sure he can survive without RS.

Not looking for a nonsense discussion and don't have any problem with you. Peace mate.

Caddre

(Copy content to your c drive go to x86 then go to server and on the right is setup double click setup and you go from there it is not complicated. It is the easiest SQL Server to install I have installed 7.0/2000/2005. I don't do IM

Copy content to your c drive go to x86 then go to server and on the right is setup double click setup and you go from there it is not complicated. It is the easiest SQL Server to install I have installed 7.0/2000/2005. I don't do IM)

And I have covered a newbie type instruction including how to get to setup .

akhlaq768

As I only need to install the basic feature...

which one should i click

SQL Server Database Services

Create a SQL Server fallover cluster

Analysus Services

Create an Analysis Server fallover cluster

Notification Services
Integration Services
Workstation components, Books Online development tools

Please help...

Caddre

(SQL Server Database Services and Workstation components, Books Online development tools)

This will give you the relational engine and SMS. Hope this helps.

Ekrem Önsoy

If you want to install the basics, then you'll choose the following:
- SQL Server Database Services
- Integration Services

And then click the Advanced button and do not forget to choose Management Tools from Client Tools. Besides, you better choose Sample databases from the Advanced window.

They'll be enough for a start.

akhlaq768

On the Service Account section...

What should I click / Enter

Username

Password

Domain

Under the.... "Start Services at the end of setup" section, what should I tick

SQL Server (tick already placed)

SQL Server Agent

SQL Brower

Many thanks

Caddre

Choose local system account and also check the box next to the Agent because some operations are Agent dependent like replication.

First Time Installation of SQL Server 2005 Developer Edition

Re: First Time Installation of SQL Server 2005 Developer Edition

Re: First Time Installation of SQL Server 2005 Developer Edition

Re: First Time Installation of SQL Server 2005 Developer Edition

Re: First Time Installation of SQL Server 2005 Developer Edition

Re: First Time Installation of SQL Server 2005 Developer Edition

Re: First Time Installation of SQL Server 2005 Developer Edition

Re: First Time Installation of SQL Server 2005 Developer Edition

Re: First Time Installation of SQL Server 2005 Developer Edition

Re: First Time Installation of SQL Server 2005 Developer Edition

Re: First Time Installation of SQL Server 2005 Developer Edition

Re: First Time Installation of SQL Server 2005 Developer Edition

Re: First Time Installation of SQL Server 2005 Developer Edition

Re: First Time Installation of SQL Server 2005 Developer Edition

Re: First Time Installation of SQL Server 2005 Developer Edition