question

Troy_2012 avatar image
Troy_2012 asked

GUI for sql server missing

Dear all, I have windows server 2003 sp2 - 32bit, I installed the sql server 2005 sp1 on this server , but when I go to start to open the Management Studio GUI. So I download the sP3 (SQLServer2005SP3-KB955706-x86-ENU) and install on the server but I still couldn't find the Icon to open the GUI for sql server. (maybe the SQLServer2005SP3-KB955706-x86-ENU file for vista home edition because my friend had the same problem and he solve it with this file). SO maybe I choose the wrong SP3 ? is there another SP file to solve this prolem,can I six this problem after I installed the (SQLServer2005SP3-KB955706-x86-ENU) on this server? PLz can someone help me,
sql-server-2005configurationsettings
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
ThomasRushton avatar image
ThomasRushton answered
What if you try start->run "sqlwb"? Chances are that, during the installation, you didn't install the client tools. Go back into the main installer, and have a look for additional components to install.
5 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Tim avatar image Tim commented ·
is sqlwb a 2005 thing and SSMS.exe a 2008 and 2008R2 thing? Never bothered looking at the actual .exe's from the editions.
1 Like 1 ·
ThomasRushton avatar image ThomasRushton ♦♦ commented ·
Have you gone through the steps mentioned at http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/944f85c2-ed0c-48d8-b846-58668f05050d/
1 Like 1 ·
Troy_2012 avatar image Troy_2012 commented ·
I selected all the options including the client tools
0 Likes 0 ·
ThomasRushton avatar image ThomasRushton ♦♦ commented ·
@Tim yes indeed. Confuses the hell out of me at times, particularly when managing older servers...
0 Likes 0 ·
ThomasRushton avatar image ThomasRushton ♦♦ commented ·
@Troy_2012 the installer for SQL Server Management Studio is (or should be) on your installation media, named "SQLRun_Tools.msi"
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.