SQL Server - can not open Sql server management studio

Asked By Daniel on 15-Nov-11 04:27 AM
Hi!I was working with sql server 2008 R2 ,but right now I am not able to open sql server,I am not seeing the shortcut to open it ,even in the sql server folder I am not seeing it to open it,but I am seeing that the service start normaly for sql server 2008 r2 express.What can be the problem?
dipa ahuja replied to Daniel on 15-Nov-11 04:29 AM
In my computer it is saved inside :

C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE

try to open from its storage location
Jitendra Faye replied to Daniel on 15-Nov-11 04:31 AM
Reference from-

http://social.msdn.microsoft.com/forums/en-US/sqltools/thread/75e2f725-338f-41a7-b66b-5fb4be2d339c/

Solution-

The most likely cause of this is if a file has been deleted or corrupted.  Does repairing the SQL Server management tools fix the problem? 

Repairing SQL Server is a command-line operation. You can repair by inserting the installation media into the disk drive and typing the following:

start /wait <CD or DVD Drive>\setup.exe /qb REINSTALL=SQL_Tools90 REINSTALLMODE=OMUS



You can find more information on installing SQL Server from the command line here: http://msdn2.microsoft.com/en-us/library/ms144259.aspx


Suchit shah replied to Daniel on 15-Nov-11 04:35 AM

Somehow this has happened to me also. Following the repair instructions

start /wait d:\setup.exe /qb REINSTALL=SQL_Tools90 REINSTALLMODE=OMUS

fixed the problem.


http://msdn.microsoft.com/en-us/library/ms144259.aspx

Daniel replied to dipa ahuja on 15-Nov-11 04:37 AM
Hi!I am able to open it as in its directory but when trying to open it It tells me that the database is not accessible.why?
dipa ahuja replied to Daniel on 15-Nov-11 04:46 AM
Its seem that you have permissions problem on the new server. Your SQL logins don't carry over automatically and if you manually create it on the new server it'll get a different SID which won't jive with the one that's granted access to the database.

http://serverfault.com/questions/34551/sql-2005-database-not-accessible