SQL Server Management Studio not installed
-
I installed SQL Server 2005 Developer Edition and find out that the SQL Server Management Studio did not get installed. What do I needed to do to install this feature.
If this is not the correct forum to post this message then please direct me to the correct forum.
Thanks for your help.
Charlie:
-
Do you mean Express Edition? The Management Studio is not shipped with Express Edition but you can download a scaled down version from Microsoft
http://www.microsoft.com/downloads/details.aspx?FamilyID=82afbd59-57a4-455e-a2d6-1d4c98d4 0f6e&DisplayLang=en
-
I installed the Developer edition which is included with Visual Studion 2005 Professional edition. I thought that you had installed the Developer edition as well.
I wonder if the Express edition would be the same as the developer edition.
Charlie
-
I had a similar problem where installing Dev edition did not install Mgmt Studio. In fact installation sees that it was not installed, gave me the option to install, but then tell me I cannot install it as it is already installed.
In my scenario I had a "botched" install where it did not install all the components, so for me to reinstall it with the Mgmt Studio component was a painful process.
Finally, I reinstalled it using cmd.exe, ran setup.exe SKUUPGRADE=1. This tells SQL to go ahead and proceed with installing everything even though it sees an old install.
Hope this helps someone with a similar problem.
-
Yes, it did help, thx! I was running setup.exe /SKUUPGRADE=1 and it was not working. Removing the slash fixed the problem for me.
-
The install media for SQL 2005 (and SQL 2008!) is split into 2 CDs, or 2 folders if installing from DVD.
CD 2 (\Tools folder) contains just the client tools install media
CD 1 (\Servers folder) contains just the server components install media
If you install from CD, then you get prompted to change to the right CD. However, the install routine cannot cope with looking in different folders if installing from DVD or if you copy the 2 folders to disk. This means that using the media as supplied you often need to do 2 installs: a) for server components, b) for client tools.
However, if you copy CD 2 (\Tools) folder to a \SQL_Install folder, then copy CD 1 (\Servers folder) to the same \SQL_Install folder, you can then install both server and client components in a single install.
(If you copy the \Servers folder before the \Client folder, then you can only do a client install, the order of copying is important!)
This is how we do our SQL 2005 installs, and it works OK.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
-
I'm having problems with this too. Installed Database Services and Books Online from CD1 and when running the setup from CD2, I am not presented with an option for Workstation Components.
Does anyone know the msi that contains the install for SSMS/Profiler etc?
-
I'm guessing, but have you tried the sqlncli.msi? If MS is using proper naming conventions, I would read this as SQL Install Client... But I could be wrong.
The readme file doesn't exactly include the descriptions of all the .msi files available in the install.
I do know you should stay away from the ..64.msi files though, unless you're using a 64 bit client.
-
Excerpt taken for BOL:
Microsoft Internet Explorer 6.0 SP1 or later is required for all installations of SQL Server 2005, as it is required for Microsoft Management Console (MMC) and HTML Help.
Microsoft Internet Explorer 6.0 SP1 or later is required for SQL Server Management Studio, Business Intelligence Development Studio, and the Report Designer component of Reporting Services.
--Ramesh
-
Ramesh - spot on 🙂
Resolved this yesterday by installing IE6. The problem was that the server was in a workgroup without internet access so I had to download the full version.
Thanks for your replies.
-
I've been in the same situation when I first installed SQL 2005 EE. I've tried installing it multiple times but i failed to successfully install SSMS. After a few days of R&D, i finally managed to install it successfully. Thanks to BOL.
--Ramesh
-
Charlie,
In MSSQL 2005 you must check the Workstation tools option during installation. If you do not check this box (it's at the bottom of the SQL Server options selection screen), then Management Studio will not be installed.
I think this behavior is different from MSSQL 2000 where the workstation tools installed by default. (Memory is fuzzy, so I'm not too sure on that).
Anyway, I hope this helps
Jared
-
I am having same problem. which path do you go to and type that command. I went to my DVD and all the way to x86 tools subdirectory. It did reinstall sql, but I still dont see sql management tools. from any other directory, it keeps saying go to windows control panel..:crying:
-
When SQL 2k5 installs, it goes through a list to check components. Did you see any errors or warnings from that part of the install?
-
Brandie, thanks for help. There were 2 warnings- that IIS is not installed and the hardware doesnt meet requirement (its running on recent dual core laptop with 1GB ram, so I dont know why its complaining). Anyway, I was able to install it last night. I had initially installed Visual studio, which probably installed sql server express. Then I installed SQL server DE. After much of work, I finally decided to uninstall all sql server related software from control panel (including express version), then reinstalled sql server from dvd. I used the above mentioned command line setup first from the tools directory and then from server directory. Seems to have worked!
Viewing 15 posts - 1 through 15 (of 20 total)
You must be logged in to reply to this topic. Login to reply