Cant seem to install SQL server 2005? Install completes, but where is SQL Server 2005

I went to one of the Microsoft "Ready To Launch" events over a year ago. Microsoft was gracious and gave everyone who attended a free copy of Visual Studio 2005 and SQL Server 2005. I have installed the Visual Studio and use it all of the time. I also installed the SQL server 2005 but I can not find the application on my computer. After the install the only items that appear to have been installed are the following:

SQL Server Configuration tools(SQL Server Configuration manager,SQL Server Error and usage reporting, SQL Server surface area confiuration, Reporting Services configuration). There is also a menu icon labeled "Microsoft SQL server upgrade advisor" and SQL server upgraded wizard.

That is all. I can't find anything that is analogus to the Enterprise manager that was in SQL server 2000 or anything that is analogous to Query Analyzer of 2005.

Can someone help me out? We use SQL server 2005 so I know how it looks. I just can't see where it insalled. I don't think it did?

Hi;

It seems that u only installed SQL server you could check it from your services..

Anyway; you could install SQL server management studio fromwww.microsoft.com

But even without installing studio with the current configuration u could reach your DB from VS2005 but sure gotta check your services..

|||

Check the below link to download the SQL server 2005 studio management

Studio Management.

HC

Can't launch SQL 2005 Tools

Hi,
I couldn't launch SQL server Management Studio from my SQL 2005 server.
There is no error message indicated after trying to launch this program.
However, if I try to launch other programs except SQL Server Configuration
Manager, I all got the following message.
To run this application, you first must install one of the following
versions of the .Net Framework: v2.0.50727 Contact your application publisher
for instructions about obtaining the appropriate version of the .Net
Framework.
SQL 2005 SP2 installation failed. How I can fix this issue and install SQL
2005 SP2 successfully?
Please advise ASAP. Tks.
Best Regards,
Lynn
Lynn (Lynn@.discussions.microsoft.com) writes:
> I couldn't launch SQL server Management Studio from my SQL 2005 server.
> There is no error message indicated after trying to launch this program.
> However, if I try to launch other programs except SQL Server Configuration
> Manager, I all got the following message.
> To run this application, you first must install one of the following
> versions of the .Net Framework: v2.0.50727 Contact your application
> publisher for instructions about obtaining the appropriate version of
> the .Net Framework.
> SQL 2005 SP2 installation failed. How I can fix this issue and install
> SQL 2005 SP2 successfully?
Download and install the .Net Framework from
http://www.microsoft.com/downloads/details.aspx?FamilyID=0856eacb-4362-4b0d-8edd-aab15c5e04f5&displaylang=en
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
|||The .Net Framework is corrupted in the machined. So, run the setup and
recovered the compnent. Problem solved.
Best Regards,
Lynn
"Lynn" wrote:

> Hi,
> I couldn't launch SQL server Management Studio from my SQL 2005 server.
> There is no error message indicated after trying to launch this program.
> However, if I try to launch other programs except SQL Server Configuration
> Manager, I all got the following message.
> To run this application, you first must install one of the following
> versions of the .Net Framework: v2.0.50727 Contact your application publisher
> for instructions about obtaining the appropriate version of the .Net
> Framework.
> SQL 2005 SP2 installation failed. How I can fix this issue and install SQL
> 2005 SP2 successfully?
> Please advise ASAP. Tks.
> --
> Best Regards,
> Lynn

Can't launch executable from SQL Server Agent Job

I'm trying to launch an .exe from SQL Server Agent Job and basically nothing happens. I created a job, with 1 step, type is Operating System (CmdExec), run as sql agent service account, and in the command box I typed "start notepad" (no quotes). The job owner is set to administrator. I manually start the job, it processes successfully yet notepad does not launch. I've tried with other .exe's and result is the same. Any advice? Thanks!

maybe what you need to type is notepad.exe alone

anyway you can also

place a jobstep containing

exec xp_cmdshell 'notepad.exe'

for more details on xp_cmdshell please consult BOL

or see this link

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_xp_aa-sz_4jxo.asp

thanks

joey

|||

Thanks joeydj but I've tried xp_cmdshell method and that does not work either. I've also tried launching a batch file (.bat) that calls the .exe and that does not work. The batch call (job) is successfull but again the .exe does not launch. I would like to know if anyone else has had this work for them (launch an .exe directly from a job). I'm starting to think there may be a security setting not allowing executables to be launched. My last option would be an SSIS(DTS) package but since just typing "start xxx.exe" is so straight forward I was trying to avoid the SSIS(DTS).

Note: Gosh I forgot to mention I'm using SQL Server 2005 Standard version.

|||

xp_cmdshell is disabled by default in sql server 2005.

Permissions

Execute permissions for xp_cmdshell default to members of the sysadmin fixed server role, but can be granted to other users.

|||thanks joeydj, but I don't think the permissions for xp_cmdshell is an issue. My login has sysadmin permissions.|||

http://msdn2.microsoft.com/en-us/library/ms190693.aspx

hi

please make sure you enable this by runningsurface area configuration

start>programs>micrsoft sql server 2005>configuration tools>

surface area configuration>surface area configuration for FEATURES>

>xp_cmdshell> check this option

regards,

joey

|||Thanks joeydj but xp_cmdshell is/was enabled and a proxy account with sysadmin permissions is setup for it as well. Can you answer the question: Should I be able to launch an .exe directly from SQL Server Agent Job?|||

hi odalys,

Yes. You can. you scenario and encountered the same error

anyway

here's the work around create an operating system(cmdexec) step

directly invoke command.com and pass the command as parameter

so the script should look like this

Command.com /c dir/w>mydoc.txt

regards,

joey

|||I tried the command.com /c notepad and the job just hangs, it never finishes executing.|||

same here.

|||

why do you want to do this? anyway..

is this a maintenance task or something

|||It's part of an I/O process. I create a data file from a db and have to launch the .exe to import the data. I've decided to do it through an SSIS package...But thanks for your suggestions!|||aaarrrrggghh! The package executes from SSIS but when I schedule it as a job it just hangs...it just says executing and it should not take more than a few seconds to run...|||

why not use the windows scheduler instead of a sql job?

To open Scheduled Tasks, click Start, point to Programs, point to Accessories, point to System Tools, and then click Scheduled Tasks.

|||Actually, that's how I have it running now, using Scheduled Tasks :)