JunHOV


Hello,

I have installed SQL server 2005 enterprise edition on Windows 2003 virtual PC (full installation). The installation went through successfully. However, after install completed, I cannot find any of the client tools under the start menu -> all programs -> Microsoft SQL server 2005 menu. The only item listed under the SQL server 2005 is Configuration Tools, which is used to configure the database server.

I have tried to install the client component again (in case I didn't install them at the first place) but the installation process cannot be started since it detected that the client components have been installed already. I can also see the sql server native client running in the services.

The server engine is working fine since I can connect to that sql server using another machine where I have the client tool (SQL server management studio).

One of my friends has exactly the same problem. He installed the sql server 2005 Standard edition on windows 2003 server (full installation), but the client tools are not showing up in the start menu either.

I also checked the location for the SQL server management studio (Microsoft SQL server/90/Tools/Binn/VSShell/Common7/IDE), there is only one folder called publicAssemblies listed under. Is this correct or something is missing

Thanks





Re: SQL server 2005 client tools not shown up in Start menu on Windows 2003 server

Arnie Rowland


Client Tools are not installed by default with a server installation. It requires a second 'run-though' by the installer.

You may need to insert Disk2, and select 'Install Client Tools' from the menu.







Re: SQL server 2005 client tools not shown up in Start menu on Windows 2003 server

JunHOV

Thanks for your input. I tried to run the installation desk (SQL Server 2005 Enterprise Edition on a DVD, no disk 2 for it) again and selected the "client component" only this time. But the installer comes back to say:

Existing components

Components have been found on the machine. Select upgrade option below

I don't see any upgrade option on the window. If I click the "Details" button, then I get the following message:

Name:Microsoft SQL Server 2005 Tools Express Edition

Reason: Your upgrade is blocked, For more information about upgrade support, see .....

Build version check:

Your upgrade is blocked because the existing component is a later version than the version you are trying to upgrade to. ..

----------------------------------------------

I have VS2005 installed before installing the SQL server and I have MOSS installed after installing SQL server. But I don't think those are related to this issue.

I have Microsoft SQL Server Native Client in the Add/Remove program list. Does this mean the client tools are instlled already If so, why the tools are not shown up Please advice.

Thanks,







Re: SQL server 2005 client tools not shown up in Start menu on Windows 2003 server

Arnie Rowland

You may need to remove the SQL Server Client Tools currently installed.

(It appears that you may have the SQL Express version of the client tools).

check using Control Panel, Add/Remove Programs

This may be helpful:

Remove -How to uninstall SQL Server Management Studio
http://support.microsoft.com/default.aspx scid=kb;EN-US;909953






Re: SQL server 2005 client tools not shown up in Start menu on Windows 2003 server

JunHOV

Thanks for your good advice, which pointed me to the right direction. Below is the actual steps used to solve the problem:

I) following the instruction of http://support.microsoft.com/default.aspx scid=kb;EN-US;909953, I uninstalled the entire Client Components, not the "Management Tools" since I only have Connectivity Component and a SDK listed under the Client Components. Looks like the existence of those two components somehow blocked the whole client components to be installed.

2) run the sqlrun_tools.msi from the installation CD to install the entire Client Components. It went through all right this time. It should also be fine to run through the normal installation process to install the Client Components.

Thanks,






Re: SQL server 2005 client tools not shown up in Start menu on Windows 2003 server

Arnie Rowland

Jun,

I'm very glad that the information helped you solve the problem. And thanks for posting your experience -your comments may help the next person with a similar problem.

-Arnie






Re: SQL server 2005 client tools not shown up in Start menu on Windows 2003 server

Ryan Riehle

After following that procedure, does SP2 need to be re-installed





Re: SQL server 2005 client tools not shown up in Start menu on Windows 2003 server

ManikR

Thanks for the instructions. I used the same steps and it worked. Thanks a lot.





Re: SQL server 2005 client tools not shown up in Start menu on Windows 2003 server

Matt_calhoon

great help for me too. thank you.





Re: SQL server 2005 client tools not shown up in Start menu on Windows 2003 server

Eugen F

Same here. Thanks for the help. It took a while to come across this post. Maybe the installer could be updated to point out to the culprit existent version....