→ installing sql server management studio with sql server on a 2008 box
Recently I started working as a .NET developer… Here we are mostly working with SQL 2005 and C# for developing enterprise web apps. Therefore, I decided to install the whole development environment in my personal computer. (When I work with windows machines I prefer the server OS). So, this post is about a problem that I had setting up the SQL environment.
When I installed SQL Server 2005 and SQL Server Management Studio on my computer it did not install SSMS or any of the other Client Tools. When running the installation of SQL Server 2005 I followed along with the instructions. I individually selected each component to install including the Client Tools for SQL Server. When the installation finished there was no SQL Server Management Studio.
Upon scouring the folders on the disc, I discovered that the default setup file is coming from a server’s folder. I tried using the setup file from the tools folder. This should have worked, but I had a slight problem. Since I had told SQL Sever to install the client tools from the wrong setup file it now believed I had them installed already and would not install them.
Since the installation defaults to the Servers setup file, I never even saw the tools install. There was also no reason to even suspect one since the primary setup file claimed to be able to install the client tools.
I had to uninstall and reinstall SQL Server without the Client tools and then the setup file from the client tools would install SQL Server Management Studio. This was quite a pain, and I don’t understand why the client tools are listed as options in a setup file which cannot install them. I think this is a bit crazy, but at least now when I install it I don’t have this problem anymore.
blog comments powered by Disqus