Hello All,

I installed VS2005 on my WinXP Pro SP2 machine and SQL Express was installed
at the same time. I did not see SQL Server Management Studio so I tried
installing a Workgroup edition overtop. The install seemed to go okay except
for the Workstation Components and Books Online. These did not install.

I've tried uninstalling all SQL Server components from Control Panel,
deleting the SQL Server registry keys and all files left over after the
uninstall and then running the install for SQL Server 2005 Developer Edition
from my MSDN DVD.

No matter what I try, the blasted Workstation Components and Books Online
fail to install.

Can someone please tell me how to fix this because I would hate to have to
reload the OS just to get the install to work.

Thanks in advance for any or advice you can provide.

Herb

Hello Herb,

Based on my research, please follow these steps to install the Workstation
Component:

1. Use the Windows Installer Cleanup tool to check whether there is any
previous installation of SQL Server installed in the machine and remove it.

http://support.microsoft.com/?scid=kb;en-us;290301

2. If you still could not install the component, please check the MSI
installer in the C:\Windows\System32 folder and then reinstalled it.

3. If you still get the error after reinstall the MSI Installer, please
collect the installation log file:

%ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG\

and post it here.

Thank you!

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Hello Wei Lu, thanks for the reply.

Here is what I did:

1. Used Add/Remove programs to uninstall all instances of SQL Server 2005.

2. Downloaded and installed the Windows Installer Cleanup Tool.

3. Ran the cleanup tool and did not find any instances of an installer for
SQL Server 2005.

4. I'm posting a screenshot from the cleanup tool for your reference.

5. I'm posting one of the log file, the one that I think is relevant, for
your review.

I did not attempt to install SQL Server again because it will fail. I've
done this process several times now.

I do not know the filename for the Windows Installer in the winsys32 folder
so I could not follow your unstructions related to that.

Thanks again for your .

Herb


"Wei Lu [MSFT]" wrote:

> Hello Herb,
>
> Based on my research, please follow these steps to install the Workstation
> Component:
>
> 1. Use the Windows Installer Cleanup tool to check whether there is any
> previous installation of SQL Server installed in the machine and remove it.
>
> http://support.microsoft.com/?scid=kb;en-us;290301
>
> 2. If you still could not install the component, please check the MSI
> installer in the C:\Windows\System32 folder and then reinstalled it.
>
> 3. If you still get the error after reinstall the MSI Installer, please
> collect the installation log file:
>
> %ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG\
>
> and post it here.
>
> Thank you!
>
> Sincerely,
>
> Wei Lu
> Microsoft Online Community Support
>
> ==================================================
>
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
>
> ==================================================
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>

Hello,

I did not get the files. Please email to me.

To reach me, please remove the ONLINE in my email address.

The windows installer is msiexec.exe in the winsys32 folder.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Hello Wei Lu,

Did you get the email that I sent directly to you?

I'm still hopeful that we can resolve this issue.

Thanks for your .

Herb

"Wei Lu [MSFT]" wrote:

> Hello,
>
> I did not get the files. Please email to me.
>
> To reach me, please remove the ONLINE in my email address.
>
> The windows installer is msiexec.exe in the winsys32 folder.
>
> Sincerely,
>
> Wei Lu
> Microsoft Online Community Support
>
> ==================================================
>
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
>
> ==================================================
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>

Hi, Herb,
Since Wei is on Chinese New Year vacation, I would like to work with you on
your issue.

I looked through your conversations and I found that you would like to
install SQL Server Management Studio ( SSMS ) and SQL Server Books Online (
BOL ) only for SQL Server Express at first.
If you just want to install the two components, you can directly download
them from MSDN site:
Microsoft SQL Server Management Studio Express
http://www.microsoft.com/downloads/d...5AE-4BD1-4E3D-
94B8-5A0F62BF7796&displaylang=en
SQL Server 2005 Books Online (July 2006)
http://www.microsoft.com/downloads/d...C5D-00DF-4220-
B133-29C1E0B6585F&displaylang=en

For why the Client Tools were not installed from your SQL Server 2005
Developer Edition Setup CD, could you please mail me
(changliw@microsoft.com) a copy of the logs?
I think that the tools might have been installed on your computer just not
appeared in the Start menu.
Now, I have not made sure if this is related to product ID, but I have a
question:
Did you fully install a new SQL Server instance or just Client Tools from
SQL Server 2005 Developer Edition?

I am afraid that you may need to perform another try of installation if
there is no clue from the error log.
Now, I would like to add the following information for your reference:
1. Ensure that your SQL Server 2005 instance (not SQL Express) has been
installed on your computer Try manually installing the Client Tools from
command prompt:
Start /wait <CD or DVD Drive>\servers\setup.exe /qb
INSTANCENAME=<InstanceName>
ADDLOCAL=SQL_DTS,Client_Components,Connectivity,SQ L_Tools90,SQL_WarehouseDev
Workbench,SQLXML,Tools_Legacy,SQL_Documentation,SQ L_BooksOnline
PIDKEY=<pidkey value with no "-"> SAPWD=<StrongPassword>
( ref: http://msdn2.microsoft.com/en-us/library/ms144259.aspx )

2. After the installation, if SSMS is still not displayed in the SQL Server
2005 group of Start menu, please check if SqlWb.exe ( SSMS ) exists in the
directory "C:\Program Files\Microsoft SQL
Server\90\Tools\Binn\VSShell\Common7\IDE\".

Hope this s. If you have any other questions or concerns, please feel
free to let me know.

Best regards,
Charles Wang
Microsoft Online Community Support
================================================== ===
Get notification to my posts through email? Please refer to:
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications

If you are using Outlook Express, please make sure you clear the check box
"Tools/Options/Read: Get 300 headers at a time" to see your reply promptly.


Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscripti...t/default.aspx.
================================================== ====
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====

Hi,

Just check with you to see if the suggestions were ful. Please let us
know if you would like further assistance.

Have a great day!


Charles Wang
Microsoft Online Partner Support