Showing posts with label ssms. Show all posts
Showing posts with label ssms. Show all posts

Sunday, March 25, 2012

Cant find SMSS

After installing the evaluation edition of MSSQL Enterprise 2005 I can not find SSMS. I know I installed the client tools upon installation. It's not showing up on in the menu, where is the location for the executable file.

Is SSMS even distriubted with the evaluation edition?

If not, is it possible to download it from somwhere...

Did you get any warnings while setup cheked your computer configuration?

Did you specify client tools installation during setup?

P.S. This question suits http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=95&SiteID=1 forum better.

|||

SSMS is part of the evaluation edition. To see a report of what's installed go to Add/Remove Programs, select the entry for "Microsoft SQL Server 2005", select "Change", then select "Report". Under "Common Components" you'll want to see something like this:

Workstation Components
[Version: 9.00.1399.06 Edition: Evaluation Edition Patch level: 9.00.1399.06 Language: English (United States)]

If you see this and still don't think you have SSMS installed, close the report. On the "Change" dialog you should see an entry for Workstation Components, select it and press "Next". This will launch the component in maintenance mode. Just follow the dialogs. When you get to the feature tree be sure to select Management Tools under the Client Components node.

SSMS is installed to %ProgramFiles%\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\sqlwb.exe

|||Thanks for your reply::

I got the evauation to work when I downloaded the DVD image and burnt it to disk, and did a fresh install...

I'm now in the process of converting my MySQL talbles over to MSSQL... weeee fun... SSIS takes some of the headake away!|||Excellent!

Tuesday, March 20, 2012

Can't Edit Job in SSMS

We just started having a problem where when we right click on a job in SSMS
and select properties, it doesn't go to Edit Job, it just opens a New Job
window that is all blank. It is happening on several workstations, but not
when we use SSMS on the actual server.
Is this a known issue?Yes, I believe it was fixed with SP2. Get your clients up to date.
"Dan" <dantheriver@.newsgroup.nospam> wrote in message
news:B15DE092-1E07-4D30-A213-C7BA70912629@.microsoft.com...
> We just started having a problem where when we right click on a job in
> SSMS
> and select properties, it doesn't go to Edit Job, it just opens a New Job
> window that is all blank. It is happening on several workstations, but not
> when we use SSMS on the actual server.
> Is this a known issue?|||Hi,
It is hard to say that this is a known issue only according to the issue
appearance. However I do agree with Aaron on that you should install SQL
Server 2005 SP2 first to see if this issue can be resolved. SQL Server 2005
SP2 has many hotfixes for SSMS. You can run SELECT @.@.VERSION to check if
your SQL Server 2005 is with SP2. If the value is less than 9.0.3042, it
indicates that SP2 is not installed.
You can download SQL Server 2005 SP2 from the following link:
http://www.microsoft.com/downloads/details.aspx?FamilyId=d07219b2-1e23-49c8-
8f0c-63fa18f26d3a&displaylang=en
If you have any other questions or concerns, please feel free to post back.
We are very glad to assist you further.
Have a nice day!
Best regards,
Charles Wang
Microsoft Online Community Support
=====================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||> SP2 has many hotfixes for SSMS. You can run SELECT @.@.VERSION to check if
> your SQL Server 2005 is with SP2.
Remember that some of the clients may only have the tools installed, so
running @.@.VERSION (against the only server they connect to) is misleading...
the server may very well respond 9.00.3042 while their local tools are in
fact still at 9.00.1399. So they should check Help|About to make sure their
client tools are up to date.|||Yes, Aaron, you have a more considerate thinking. It is the best practice
for checking the tool's version.
Thank you!
Best regards,
Charles Wang
Microsoft Online Community Support
=====================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================