First Time Installation of SQL Server 2005 Develop

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

First Time Installation of SQL Server 2005 Develop

Author

Topic

akhlaq768
Starting Member

12 Posts

Posted - 2007-10-13 : 15:54:10

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 systems
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

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-10-13 : 15:55:53

You would install x86 since you have an x86 OS on your home machine.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Kristen
Test

22859 Posts

Posted - 2007-10-13 : 15:57:14

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

You need to install the "32-bit (x86)" version.

Kristen

akhlaq768
Starting Member

12 Posts

Posted - 2007-10-13 : 16:04:25

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

Kristen
Test

22859 Posts

Posted - 2007-10-13 : 16:10:00

This is a public forum. We post messages so that other people can follow the thread, learn from it, or use it as a basis for problem solving in the future.

You can also hire my services if you so wish

Kristen

funketekun
Constraint Violating Yak Guru

491 Posts

Posted - 2007-10-13 : 19:54:45

Just reinstall it if u do it wrong...its your home pc anyway.

http://www.sqlserverstudy.com

akhlaq768
Starting Member

12 Posts

Posted - 2007-10-14 : 14:43:00

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

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-10-14 : 14:46:44

use the built-in system account.
also check all 3 checkboxes on the bottom

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
SSMS Add-in that does a few things: www.ssmstoolspack.com

akhlaq768
Starting Member

12 Posts

Posted - 2008-11-23 : 12:18:21

when i first load sql management studio, its ask me to enter the Server Name...

what do i enter here?

im running it off my home PC

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-11-23 : 12:29:56

Mariam-PC

akhlaq768
Starting Member

12 Posts

Posted - 2008-11-23 : 12:41:25

thanks for the promt reply but unfortunatel
y i get the following error

TITLE: Connect to Server
------------------------------

Cannot connect to Mariam-PC.

------------------------------
ADDITIONAL INFORMATION:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=2&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

akhlaq768
Starting Member

12 Posts

Posted - 2008-11-23 : 13:18:05

any body please?

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2008-11-23 : 15:37:31

You can open the combo-box and choose search...

Webfred

No, you're never too old to Yak'n'Roll if you're too young to die.

akhlaq768
Starting Member

12 Posts

Posted - 2008-11-24 : 07:36:17