Solved

Cannot start Messenger Service on VISTA to implement SQL Server Agent Job

Posted on 2010-09-08
4
367 Views
Last Modified: 2012-05-10
Hi -
I'm studying for my Microsoft 70-431 DBA Certification and am following the labs from their 2780B course book.  I need to start the Messenger service and their instructions say:
Click Start
Point to Administrative Tools
Click Services
In the services console
    Scroll down to the Messenger service
    Right-cllicK Messenger
    Click Properties
In the Messenger Properties (Local Computer) dialog box
    On the General tab in the startup type list
        Click Automatic
        Click Apply
Click Start to start the service
Then clock OK and close the Services Console

Unfortunately, my only notebok (needed to take to study groups) is on VISTA and I don't have the time to load XP or Windows 7.  Plus, I'm using VISTA Home (I borrowed my husband's notebook), so some things either aren't there at all, or they can be difficult to find.

Is there a way to run the Messenger service on my machine and, if so, how?  I've read that MS Vista doesn't have the "net send" command and instead uses msg.exe, but am clueless as to how to get everything up and running so that I can successfully send messages from SQL Server Agent.

If you know the answer, could you lay it out step by step (like the instructions above that were in my class book).  This is an area that I am very weak on right now and need all the help and simple explanations I can get.  Thanks in advance.
0
Comment
Question by:bshelby777
  • 2
  • 2
4 Comments
 
LVL 65

Accepted Solution

by:
rockiroads earned 500 total points
ID: 33631276
From reading this http://www.vistax64.com/vista-networking-sharing/8567-messenger-service.html it appears you might be able to add it on seperately.
Failing that, there is an alternative as discussed on ee here http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Windows/Windows_Vista/Q_23080313.html but I am assuming alternatives is not the way forward because of your course requirement.
0
 
LVL 65

Expert Comment

by:rockiroads
ID: 33631296
hey found this free net send. http://www.cezeo.com/products/netsend/
0
 

Author Comment

by:bshelby777
ID: 33631392
Thanks for your quick response, rockiroads - I'll try this out right now and will get back.
0
 

Author Closing Comment

by:bshelby777
ID: 33632107
Hi rockiroads -

I went to the first link (http://www.vistax64.com/vista-networking-sharing/8567-messenger-service.html) and was able to easily add the Microsoft Mesage Queue in as a service.  My SQL Server Agent job worked, so that was good.  I'm still trying to figure out where the alerts/messages are, but you answered my questions and helped make this whole thing a little clearer.  Thanks a lot!
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
The Task Scheduler is a powerful tool that is built into Windows. It allows you to schedule tasks (actions) on a recurring basis, such as hourly, daily, weekly, monthly, at log on, at startup, on idle, etc. This video Micro Tutorial is a brief intro…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question