Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 sqlwb-sql server management studio

Author  Topic 

charan.guddu
Starting Member

1 Post

Posted - 2009-09-16 : 03:27:40
Hi,
I need a help from you.
As i am having a windows small business server 2003 with sql server 2005 which i am unable to open sql server management studio and even i am unable to open visual studio 2005. If i click on visual studio 2005 it will just flicker and go off.
and if i click on sql server management studio i am getting the following error.

"sql server management studio has encountered a problem and needs to be closed."

Kindly help as i am unable to take the backup.

Regards,
Charan

rajdaksha
Aged Yak Warrior

595 Posts

Posted - 2009-09-16 : 03:53:46
Hi

try this....
FOR 32-bit:

Administrative tools-->Schedule Tasks-->New task-->"C:\Program Files\Microsoft SQL

Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe"

FOR 64-bit:

Administrative tools-->Schedule Tasks-->New task-->"C:\Program Files

(x86)\Microsoft SQL Server\90\Tools\binn\VSShell\Common7\IDE\SqlWb.exe"

SQLWB is a 32-bit application, so it would be running under WOW mode on 64-bit system

IMP: Run the SSMS executable as user who is logged on (not NT AUTHORITY \SYSTEM)

2) If this works then move on to the next step

3) Create a Test user account and launch SQL 2005 Management Studio (Run As)

4) So this would definitely point fingers at a faulty user profile. What we could do then is move to the next step.

5) Create a new profile and try launching SQL 2005 Management Studio.

6) This should launch SSMS successfully.




-------------------------
R...
Go to Top of Page
   

- Advertisement -