I cant install the server components

Question

Post reply

I cant install the server components

cmrhema

SSCommitted

Points: 1558
More actions
April 12, 2009 at 12:31 am

#203374

I installed sql server 2005, but unfortunately although i loaded sql server components, it did not get installed.
All i got was start-programs-sqlserver2005- configuration tools----
Now further i have already installed visual studio 2005.
I want to remove and install again the sql server
I have in my control panel
Microsoft sql server 2005 630 mb
Microsoft sql server 2005 backward compatibility 26.6 mb
Microsoft sql server 2005 mobile [ENU] developer tools 67.89 mb
Microsoft sql server native client 4.25
Microsoft sql server setup support files(english) 21.03
Microsoft sql server 2005 vss writer 0.69
SQLXML4 2.72 mb
Should I uninstall all the above and reinstall again
Kindly help pls
regards
cmrhema

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

What operating system?

What edition of SQL were you installing?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

cmrhema SSCommitted Points: 1558 More actions · Answer 2

My OS--Windows xp professional

Installling --Sql server 2005 Enterprise Edition

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

You can't install the server components of Enterprise edition on a non-server OS. Basically, to install the server components of SQL Enterprise edition, you need Windows Server 2003 or Windows Server 2008.

If you're working on a dev machine (non-server OS), install developer edition. The server components of developer edition can be installed on any OS. Alss, bear in mind that if you install Enterprise, it has to be licensed and it's not cheap. Developer however is.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

cmrhema SSCommitted Points: 1558 More actions · Answer 4

Thanks Gila .Can I have a free download of Developer Edition.

And in case I have to install Developer, do I need to uninstall those mentioned in my first post

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

cmrhema (4/12/2009)
Thanks Gila .Can I have a free download of Developer Edition.

No. It's $50. Buy it from Amazon if you don't have an MSDN subscription

And in case I have to install Developer, do I need to uninstall those mentioned in my first post

Probably a good idea.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

cmrhema SSCommitted Points: 1558 More actions · Answer 6

Hi,

I installed the SQL Server Management Studio Express from

http://www.microsoft.com/express/sql/previous/default.aspx

I have installed that successfully.

But when I start the, I have that dialog box that asks for the Server Name from the drop down box, I gave local, and gave . and also tried giving my computer name.

But to no avail.

What could be my problem

Regards

cmrhema

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 7

Management Studio Express is, as the name implies, just Management Studio, ie the client components. If you want SQL Server Express Edition, it's a separate download.

It's on the same page that you downloaded management studio from, it's the link right above the one for management Studio Express

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

cmrhema SSCommitted Points: 1558 More actions · Answer 8

Thanks for the prompt reply

But one question(sorry if its too silly),

should i install

SQL Server 2005 Express Edition,

or

SQL Server Management Studio Express,

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 9

cmrhema (4/13/2009)
Thanks for the prompt reply
But one question(sorry if its too silly),
should i install
SQL Server 2005 Express Edition,
or
SQL Server Management Studio Express,

SQL Server 2005 Express Edition is just the Express database engine with no client tools

SQL Server Management Studio Express is just the client tools, no database engine.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

cmrhema SSCommitted Points: 1558 More actions · Answer 10

Thanks

After installing the problem has been solved

Many many thanks

niteesh_changra2008 Newbie Points: 1 More actions · Answer 11

cmrhema (4/12/2009)
I installed sql server 2005, but unfortunately although i loaded sql server components, it did not get installed.
All i got was start-programs-sqlserver2005- configuration tools----
Now further i have already installed visual studio 2005.
I want to remove and install again the sql server
I have in my control panel
Microsoft sql server 2005 630 mb
Microsoft sql server 2005 backward compatibility 26.6 mb
Microsoft sql server 2005 mobile [ENU] developer tools 67.89 mb
Microsoft sql server native client 4.25
Microsoft sql server setup support files(english) 21.03
Microsoft sql server 2005 vss writer 0.69
SQLXML4 2.72 mb
Should I uninstall all the above and reinstall again
Kindly help pls
regards
cmrhema