Installing SQL Server 2005 Standard | The Coffeehouse

gatesgosling

Thanks for the post.

I would like to add 1 more thing :

For my case I also unistalled the "Sql server 2005 common components"
To reinstall it : just put cd1 to install only the "workstation, online books and client tools"

And it works : the management studio is ready to be used.

I suspect that uninstalling of SQL server express wouldn't be needed if just uninstall-install of "common components" enough.
Glad that it works. Wink

tpeterka

I had the same problem until I followed the posting that said this...

Insert disk 2, and execute the sqlrun_tools.msi that is in the Setup folder.

You tell it to install the Management Tools when using the Change Components option button, then under the client components section, Management Tools.

Tony

Fiske

I tried some of the options above, none of which fixed the install problem on my box (used for development, not a server). I didn't feel like uninstalling and reinstalling VS2005 (life is too short). So, instead, I tried using the Install/Remove Programs utility on the Control Panel under Settings, chose the change option for SQL Server 2005 and selected the SS Management Studio, Books, etc. It installed the options from the DVD without a hitch.

Why the Setup.exe on the DVD doesn't work, I don't know. Using the System Install/Remove utility is a quick easy solution though.

Fiske

PhongZ

When I ran install, I selected all the options, including Workstation Components, which has the Management Tools. The fact is...it only marked as the Management tools as being installed but no file of such were created. I had to go in and change the installation option and have it remove the Workstation Components (Add/Remove Program...Select Microsoft SQL 2005 Server...click Change) then i ran the setup from Tools/ in the [CD/Install folder]. All the tools are now installed.

fulano2

This will do it: (The post above is basically the same thing)

1. In the Control Panel go to "Add Remove Programs"
2. Find "Microsoft Sql Server 2005" and select it
3. Click "Change" button that appears when selected
4. Check the bubble that says "Workstation Components"
5. Click Next and again...
6. Click the "Change installed Compnents" big square button
7. Expand Client Components on the install and select "Management Tools"
8. ... you know the rest...

I had the same issue happen to me and this did the job Smiley

Good Luck!

gavinlee

i face the same problem when i install the 2005 express edition,i slove it after i changed the named instance as "express2005".

because i find that i have installed a named instance as the default instance.

i hope it can help u.

Colombo

Thank you alot, your post solve the issue, i did as follow:

1- Open Add/Remove Programs
2- Choose "Microsoft SQL Server 2005" and Press "Change"
3- From "SQL Server Common Components" choose "Workstation Components" Radio Button, then Next.
4- After Removal complete.
5- open setup exe from folder "~\SQL 2005\SQL Server x86\Tools\"
6- Accept and Next, Next, ...
7- In Feature Selection Tab, you can activate
"Client Components -> Management Tools" only or Activate All.
8- Next, to Finish.

it Works.

Smiley

nthpixel

Setup.exe UPGRADE=1 didn't work for me.

I used Setup.exe SKUUPGRADE=1

Big Smile

ggodwin

OK folks I just found this website by googling this same problem.

Here is my deal. I have had the SQL 2005 Dev. Installed on my machine for 6 mos or so. I have had an issue with VS2003,VS 2005 and attempting to get VS2008 to use some Silverlight applications...

Long story short...Nothing is working for me and I now want to get my system back to ground zero (Prior to Silverlight desires) I have had to un-install several items. I am also trying to regain the VS2005 that came in my SQL2005 install.

Anyway - I can not un-install my SQL2005 stuff from my PC?
I can't connect to my SQL sever...I swear if I had dynamite I would blow this PC up!!! Sad :(

When I do everything is still there and that is by using the add/remove programs from the control panel.

I am using the SQL 2005 Developer DVD.

I have no idea which solution would be best for me?

ggodwin

For what ever reason. I continue to have an express instance on this machine.

I have uninstalled everything I can find. But for whatever reason. The express is a tough SOB and it appears that this instance is not allowing me to install everything from the 2005 developer DVD?

any sugestions?