Re-installing SQL Server 2005 Developer on Windows XP SP3

Recently I had some issues with an external drive (Seagate FreeAgent) where I had all my software images (SQL Server 2005, Win XP, Visual Studio, etc...). Also the existing and working version of SQL Server 2005 on my machine began to malfunction, thus I opted for a re-install which I've done many a time successfully. Now at the end of installing the workstation components I get a weird error and a rollup is performed which means I do not get the management studio to access SQL Server 2005, Analysis Services, etc... Even though all of the services are installed and started. I wonder if the instal image of CD2 has become corrupt ?

I could not paste a screen image showing the error.

I hope that you can help.

more ▼

asked Jan 29, 2010 at 05:49 PM in Default

avatar image

Medany Cheris
34 2 2 4

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

can you connect to the SQL Server from another machine with SSMS installed? If so you may be able to get away with unistalling and reinstalling the management tools only ..?

more ▼

answered Jan 29, 2010 at 06:24 PM

avatar image

Fatherjack ♦♦
43.8k 79 101 118

(comments are locked)
10|1200 characters needed characters left

It sounds to me like it could well be. Try making a VHD and seeing if you can install SQL on that to test the image. If it works, then you have bigger issues.

more ▼

answered Jan 31, 2010 at 08:07 PM

avatar image

Rob Farley
5.8k 16 22 28

Thanks for your advise, in pursuit of resolving this problem I found an article stating that this is a well known problem and nobody knows its cause. The recommended resolution was/is to install the workstation components one at a time leaving the management console for last install and using SqlRun_Tools.msi instead. Well it works, odd approach but acceptable. THX

Jan 31, 2010 at 09:03 PM Medany Cheris
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jan 29, 2010 at 05:49 PM

Seen: 2421 times

Last Updated: Jan 31, 2010 at 08:06 PM

Copyright 2018 Redgate Software. Privacy Policy