In November, I upgraded a laptop from Windows XP to Windows Vista. I installed SQL Server 2005 Express. Earlier this week, I installed SQL Server 2005 and installed Service Pack 2. None of the SQL Server tools appear in the start menu, but Add/Remove Programs show that they are installed. What can I do?
When you install SQL Server 2005 the client tools are not installed automatically. You will need to run the installer again and on the list of services select the last option on the list which is the "Client Tools." It is also possible that the tools are installed but the shortcut didn't get created. Check in c:Program FilesMicrosoft SQL Server90toolsbinn and see if sqlwb.exe exists. If it does, the tools are there and you can just create the shortcuts manually.
Dig deeper on Microsoft SQL Server 2005
Related Q&A from Denny Cherry, Contributor
To avoid performance problems when running multiple instances of SQL Server 2005 with Exchange on Windows SBS, refer to these expert best practices.continue reading
Learn how to troubleshoot SQL Server 2005 temporary table performance problems when a stored procedure execution time is slower than usual.continue reading
Troubleshoot long running stored procedures with SQL Server Profiler by adding events to find the command with high run time.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.