SQL Server Management Studio installed ??

Question

greetings,
i just install sql enterpise editon (eval version) on my xp computer. does it come with SQL Server Management Studio or is that something i'm suppose to download seperatly??  its not in my menu. that is what i'm supposed to use to manage the database ??? very much a newbie.

Answer 1

Are you sure it is Enterprise Edition and not Express Edition?  Enterprise Edition requires Windows Server.  If you went through the installation, did you install the "Workstation components, Books Online and development tools"?

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/

 

Answer 2

pretty sure i installed the evaluation version of sql server (enterprise). i still have the exe file that installed the database on my desktop. its called sqleval.exe. from the microsoft download site http://www.microsoft.com/downloads/details.aspx?FamilyID=6931FA7F-C094-49A2-A050-2D07993566EC&displaylang=en
it states that eval version runs with xp the following is a copy and paste:

System Requirements

• Supported Operating Systems: Windows 2000 Service Pack 4; Windows Server 2003 Service Pack 1; Windows XP Service Pack 2

• 32-bit systems
• Computer with Intel or compatible Pentium III 600 MHz or faster processor (1 GHz or faster is recommended.)
• 64-bit systems
• 1 GHz or higher processor
• Minimum of 512 MB of RAM (1 GB or more is recommended.)
• 675 MB of available hard disk space

To learn more about what is required to run SQL Server 2005 Enterprise Evaluation Edition, see the system requirements page.

also, during install a dialog box came up and ask me if i wanted to install someother stuff. i checked everything but i don't remember what they were. sorry i'm not much help

Answer 3

The Management Studio executable is called sqlwb.exe.  If management tools were installed (and you didn't change the SQL Server install directory during setup), it will be in %ProgramFiles%\Microsoft SQL Server\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE.  There should be a shortcut installed in your start menu under SQL Server 2005 for SQL Server Management Studio also.

 

Hope this helps,
Steve

Answer 4

hmm, reran the setup program for sql. when it asked me what componets i wanted to install i pressed the advance button and selected client componets -> mamagement tools. that should have installed management studio. when i finshed making my selection i pressed the next button. the next dialog box said "existing components" and some more stuff about thing that were already installed on the computer. their was a greyed out line with a checkmark in front of it that said "workstation componets, books online and developement tools 9.00.1399.06. then i selected the details button, this is the point were i think i was getting to the willy nilly, it said
Name Microsoft sql serever 2005 tools express editon
reason: your upgrade is blocked. for more information about upgrade etc etc etc
edition check:
your upgrade is blocked because of edition upgrade rules. for more info etc etc etc

maybe this is the problem, i installed vb express along with sql express, i then uninstalled sql express but left vb express on the computer. then i installed sql eval version. now mangaement studio is being blocked from installing. tonight i will load eval version on a pc that has never had vb express or sql express on it, see if i have the same problem. anyone think it might be something else ???
BTW sqlwb.exe isn't on my computer anywhere.

Answer 5

well i went home and tried to install eval edition but i didn't have the windows installer 3.1 so i was unable to install eval last night. would like to go ahead and close this thread though becauce the basic question has been answered. management studio is not installed on my computer. I think i know why, but if i don't figure it out myself i'll get back with you guys.

Answer 6

SQL Server Management Studio doesn't install if you have installed Visual Studio 2005 already installed. Something to do with the SQL Server Express install that comes with it.

Having SQL Express already installed will do the same thing I think.

Answer 7

Hi, I have some problems in finding SQL server management studio at 64 bit, I have followed every type of parameters during the installation which has been successfully done, but I cannot find the consolle SQL Management Studio.

Under the path %ProgramFiles%\Microsoft SQL Server\Microsoft SQL      Server\90\Tools\Binn\VSShell\Common7\IDE



The system cannot retrieve anything. So I have installed Express Version but it doesn't seem to me the same thng, then I did the same installation on other server but 32 bit: this time without any problems and I have succeeded in finding SQL Management Studio following exactly the same path used for 64 bit (using a CD SQL 2005 32 bit). Can you help me to retrieve the solution of my problem?
Thanks in advance for every type of information you can give me.
Davide ([e-mail]).

Answer 8

Hi, I have some problems in finding SQL server management studio at 64 bit, I have followed every type of parameters during the installation which has been successfully done, but I cannot find the consolle SQL Management Studio.

Under the path %ProgramFiles%\Microsoft SQL Server\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE


the system cannot retrieve anything. So I have installed Express Version but it doesn't seem to me the same thng, then I did the same installation on other server but 32 bit: this time without any problems and I have succeeded in finding SQL Management Studio following exactly the same path used for 64 bit (using a CD SQL 2005 32 bit). Can you help me to retrieve the solution of my problem?

Thanks in advance for every type of information you can give me.
Davide ([e-mail]).

Answer 9

Management Studio wont install because the following folder already exists, so the installer thinks it is already on there.

 

%ProgramFiles%\Microsoft SQL Server\Microsoft SQL Server\90\Tools\

 

Rename the above ..\Tools\ folder to ..\Tools_Bak\, then run the SqlRun_Tools.msi from your install disk.

 

Answer 10

Hello Bmonson,

 

thanks for the tip. After following the steps system statrt working as expected.

 

Thank you again,

IT