question

sand143eep avatar image
sand143eep asked

SQL Server not found

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.
sql-server-2005
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Fatherjack avatar image
Fatherjack answered
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.
6 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Fatherjack avatar image Fatherjack ♦♦ commented ·
you dont need to install more instances, this will lead to more confusion. Use the installer options to just install the management tools. Most people do not install these tools on the SQL Server but on their own PC. See this blog for some details http://blogs.msdn.com/b/bethmassi/archive/2011/02/18/step-by-step-installing-sql-server-management-studio-2008-express-after-visual-studio-2010.aspx
1 Like 1 ·
sand143eep avatar image sand143eep commented ·
yes its correct in the perticular path i didnt find the files C:\\Program Files\\Microsoft SQL Server\\90\\Tools\\Binn\\VSShell\\Common7\\IDE in the vsshell there is no common 7folder. i installed new named instance then also it was not getting ssms please suggest is there any other procedure to install that
0 Likes 0 ·
sand143eep avatar image sand143eep commented ·
i am using sql server 2005 enterprise edition sp4 here when i am trying to install the management tools then i am getting the pop up like " none of the selected features can be installed or upgraded.setup can not proceed since no effective change is being made to the machine; please suggest how can i proceed further
0 Likes 0 ·
ThomasRushton avatar image ThomasRushton ♦♦ commented ·
`SQLWB` Should be in `C:\Program Files (x86)\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE`, as it's a 32-bit application. Assuming you're running on a 64-bit server, that is.
0 Likes 0 ·
sand143eep avatar image sand143eep commented ·
yes i am using 64 bit server then what was the problem that i am unable to open ssms as it is able to accesable from other server all databases any query which can be fired successfully i am confused a lot what to do
0 Likes 0 ·
Show more comments

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.