Hello there was a severe problem with my sql server 2005. from client i can connect to the sql server instances installed in the server but when i login directly to the server and select the sql server management studio icon then its asking to browse from programs and saying it was uninstalled. i am confused as i can see the data and log files and services running and from client i can connect and run the queries but from windows server i am unable to connect to management studio. please help its urgent. in the morning i installed sp4 on one instance out of three which are already in sp4 is it causing the problem please suggest i am trying to open the management studio by running sqlwb on run then i am getting the error windows can not find sqlwb make sure you typed the name correctly try to search for a file click start button and click on search.
Having SQL Server installed and hosting databases is not the same as having SQL Server Management Studio installed and connecting to those databases. It sounds like you have SQL Server installed but for some reason you are not starting the SSMS application correctly. For SQL Server 2012 it is usually installed at "C:\\Program Files (x86)\\Microsoft SQL Server\\110\\Tools\\Binn\\ManagementStudio\\Ssms.exe", for 2008 it is "C:\\Program Files (x86)\\Microsoft SQL Server\\100\\Tools\\Binn\\VSShell\\Common7\\IDE\\Ssms.exe". Once you find this you will be able to start it as you are expecting. If you cannot find it then you have possibly uninstalled it. If that is the case then it can be installed from the SQL Server installation disk.