September 17, 2009 at 4:01 pm
i am not able to login to SSMS.
Pls find the attachment.
September 17, 2009 at 4:38 pm
Do you get an actual error message if you click the shortcut?
Looks like somebody uninstalled the management tools from the pic you sent - best guess.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 17, 2009 at 4:56 pm
i am not getting any error if i click.
September 17, 2009 at 4:58 pm
what have you done to troubleshoot?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 17, 2009 at 7:20 pm
i dont know , pls suggets.
September 17, 2009 at 8:02 pm
Never saw this before.Reinstall client tools.
September 17, 2009 at 9:18 pm
I have come across this issue but can't recall what causes it. The shortcut points to a UNC path instead of the local path. (\\server\C$\ instead of C:\...). Windows is not able to execute the program since it cannot point back through the UNC path to find the required secondary files to start the program. This link is for Windows NT and older but explains the process or concept a little, note not the fix just a little explanation.
From your screen shot I see it as a user on TORGENSQLCL02 tried to start the SSMS console on TORGENSQLC01B by going through the admin share [C$]. In doing that it altered the path of the shortcut (Auto network shortcut resolution). You should be able to alter the shortcut path to be just C:\..., instead of the UNC path and be good to go. If not you can just recreate it under All Users.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
September 18, 2009 at 2:25 am
Did you check that you have the source file in the installation folder of the SQL Server!?
it is like this
C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE
You should find the SSMS.exe (for SQL Server 2008) or SQLWB.exe for SQL Server 2005(I'm not sure!!!)
Ok as I can see, you post the problem in the SQL Server 2005 section, and you will try to start the SSMS from Run command typing sqlwb - this is for the version SQL Server 2005) or ssms - for SQL Server 2008!
Let us know what did you do with your problem!?
September 18, 2009 at 2:28 am
September 18, 2009 at 3:15 am
as suggested change the c$ to c:\, also right click on the item in the item on the menu and look at the properties. and check to see if the .exe file actually exists on your c drive
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
September 18, 2009 at 3:46 am
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply