Smart questions
Smart answers
Smart people
Join Tek-Tips Forums

Member Login

Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

Can't find SQL SSMS icon on Remote Desktop

MacroScope (Programmer) (OP)
14 Feb 12 12:23
I'm working in a SQL database that's using Microsoft SQL Server Compact Edition.  I can't get into the Management System because there is no icon for it on the Remote Desktop and I don't know where the file is located to create my own.

Of course I can't edit tables or do anythimg else without access to that, and I'd sure appreciate some help on locating the active file so I can recreate the icon.

dhookom (Programmer)
14 Feb 12 13:15
Did you check the Start menu? Not every icon is going to appear on the desktop. Depending on your version and other stuff, it might be at:
"C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe"

Hook'D on Access
MS Access MVP

MacroScope (Programmer) (OP)
14 Feb 12 15:01
Thanks, Duane, but the version of SQL that's in use is the Compact Edition.  The directory name in Program Files is Microsoft SQL Server Compact Edition, and the only subdirectory is v3.1.  The file you mentioned, SqlWb.exe is nowhere in that subdirectory, and in fact there is no .exe file at all.  All are .dll except the readme file.

Any other thoughts using this version?
dhookom (Programmer)
14 Feb 12 15:12
It is possible the SSMS was not installed.

Hook'D on Access
MS Access MVP

MacroScope (Programmer) (OP)
14 Feb 12 15:17
OK, if that's the case can I install it separately?  Where do I get it?
dhookom (Programmer)
14 Feb 12 15:31
I get the SSMS tools by requesting at work. You may need to find the download on Microsoft.

Hook'D on Access
MS Access MVP

dhookom (Programmer)
14 Feb 12 15:32
Did you look in the Control Panel->Programs and Features to see if Microsoft SQL Server 200X Tools is installed?

Hook'D on Access
MS Access MVP

MacroScope (Programmer) (OP)
14 Feb 12 16:30
Thanks for your help.  It evidntly was not installed, although it was previously, meaning that someone intentionally unistalled it.  Why?  Who knows!

I now have all the directories in the path you specified...but the final file, SqlWb.exe, isn't there.  This is a work computer and it doesn't have any kind of photo manipulation software on it, so I pasted a screenshot of the available files in Word Documents.  Can you tell from these what the issue might be?
dhookom (Programmer)
14 Feb 12 17:14
This is a work computer and I can't view files in mediafire. I expect there is a SQL Server Forum in Tek-Tips that might be a better resource.

Hook'D on Access
MS Access MVP

MacroScope (Programmer) (OP)
14 Feb 12 17:41
Thanks for your help.  I'll check that out.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close