asked on

MS SQL Server Management Studio will not load

Hi,

We have SQL Server Express 2008 R2 installed on MS Server 2003 R2 (x86). The SQL engine is working fine, but I am unable to open the SQL Server Management Studio.

When I open the application the SQL Server Management Studio flash screen appears and then disappears and the application does not run.

I have downloaded the install for SQL Server Management Studio and attempted to install it, but the option to install is "greyed out". I have also attempted to repair and upgrade it, but this did not work.

Maybe I need to unistall SQL Server Management Studio first and then re-install it, but I am unsure how to do this without un-installing MS SQL Server... This is a production server so I CANNOT un-install the SQL Server as a whole.

Please help.

Thanks, Greg

Vijaya Reddy Pinnapa Reddy

is there any event id?
Also check the SQL Server service status.

spen_lang

ASKER

Hi,

There is not an "application" or "ssytem" event.

I have checked the SQL Server Services and the following are running:
>> SQL Server (Instance1)
>> SQL Server (Instance2)

The follwoing SQL Server Services are not running:
>> SQL Server Agent (Instance1)
>> SQL Server Agent (Instance2)
>> SQL Server Browser

Thanks, Greg

ASKER CERTIFIED SOLUTION

PCANW

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

spen_lang

ASKER

Hi,

I have just tried the command "start /wait C:\SQLManagementStudio_x86_ENU.exe /qb REINSTALL=SQL_Tools90 REINSTALLMODE=OMUS"

Where SQLManagementStudio_x86_ENU.exe is the download file I got from MS website for SQL Server Management Studio. But this results in the attached error message.

spen_lang

ASKER

Any other suggestions please?