Setting up DB Engine/New Server in SQL Server 2005

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

SQL Server 2000 Forums

SQL Server Administration (2000)

Setting up DB Engine/New Server in SQL Server 2005

Author

Topic

dnf999
Constraint Violating Yak Guru

253 Posts

Posted - 2006-12-27 : 19:25:54

Hi

I'm a novice when it comes to setting up SQL Server 2005. I use it at work but the environment is already set up.

The problem I have is when I install SQL Server 2005 at home, I have no database engine/server? that I can use to create tables, db's etc.. to practice my sql on.

Any ideas on how I can set this up??

Thanks

David

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-12-27 : 19:38:56

Well you need to install the engine. You must have only installed the client tools if you don't have the engine as well.

Tara Kizer

dnf999
Constraint Violating Yak Guru

253 Posts

Posted - 2006-12-28 : 07:19:11

Hi

Any ideas how i install the engine?

I've looked on the CD's and can't find an option to do it....

Help!

Cheers!

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2006-12-28 : 07:44:47

Which edition of SQL Server 2005 you are trying to install? If you want merely a database engine, you can install Express edition which is freely downloadable from Microsoft site.

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

dnf999
Constraint Violating Yak Guru

253 Posts

Posted - 2006-12-28 : 07:58:06

Hi

I've just installed the enterprise Edition from two installation CD's and one Service Pack CD.

So I just need to download the engine from the microsoft website?

Thanks

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2006-12-28 : 08:05:25

No, You won't.

If you installed Enterprise edition, you have already installed DB Engine provided you installed it on proper OS. Which OS you are using?

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

dnf999
Constraint Violating Yak Guru

253 Posts

Posted - 2006-12-28 : 08:41:09

Windows XP, Service Pack 2
Media Center Edition.

(will upgrade to Vista next year...)

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2006-12-28 : 08:58:22

I believe on Windows XP you can only install client tools. You need to have Server OS like Windows 2000, 2003 etc.

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-12-28 : 14:29:04

For Windows XP, you can install the developer edition and get the engine.

Tara Kizer

dnf999
Constraint Violating Yak Guru

253 Posts

Posted - 2006-12-28 : 15:11:24

Can the engine be downloaded from a Microsoft website....?

Thanks.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-12-28 : 19:36:05

Well it depends. Are you guys licensed? We download ours from the MSDN site, but that's because we have MSDN licenses.

Developer Edition costs about 50 bucks, I believe.

Express is free though.

Tara Kizer

monty
Posting Yak Master

130 Posts

Posted - 2006-12-29 : 00:39:17

install the express edition which is free to download from microsoft site:

for more details on compatability of diffrent OS with Sql server 2005 refer :

http://www.microsoft.com/sql/prodinfo/sysreqs/default.mspx

its me monty

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources