question

Leo avatar image
Leo asked

Office Issue

Hi Everyone, I had a issue with our Domain Controllers last week at our office. First problem is - Network gone down (Domain Controller is Crash and Need replacement) No one can't connect to Network. Second problem is - MS Exchange is Down next day after we replaced the new Domain Controller but Exchange Server is still reference to Old Domain Controller. Now, Operation Director assigned me on mission. What he wants is - I should received an SMS as soon as one of them is off line including SQL Servers. Anybody have any idea how to resolve the issues? I have been looking [ www.txtlocal.co.uk][1] website last couple of days and I can setup SMS message in .net to check the SQL server but I don't know how to check the Network and MS exchange. Any Idea? Thanks. Leo [1]: http://www.txtlocal.co.uk
networkexchange
3 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Fatherjack avatar image Fatherjack ♦♦ commented ·
I would suggest that Stack Exchange would be a better place to ask about Exchange and Network details. This is a SQL forum and you say that you have the SQL part of your project solved.
0 Likes 0 ·
ThomasRushton avatar image ThomasRushton ♦♦ commented ·
@Fatherjack - let's humour him... see if we can get SQL Server to drive the whole thing. ;-)
0 Likes 0 ·
ThomasRushton avatar image ThomasRushton ♦♦ commented ·
What version of SQL Server have you got?
0 Likes 0 ·
ThomasRushton avatar image
ThomasRushton answered
Can you use SQL Server to drive the process? Write a script / SSIS task to regularly check that the DC or Exchange box are responding as they should and have them SMS you if not?
6 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Fatherjack avatar image Fatherjack ♦♦ commented ·
but if SQL is off you wont know if other services are off ... :-/ Liking the SQL Solves Everything attitude though :)
2 Likes 2 ·
ThomasRushton avatar image ThomasRushton ♦♦ commented ·
But if SQL is off you'll have an alert for that, so you'll know something's wrong... I'm going for the "We've solved this problem, now let's just beat up this so it works the same way..." approach here... can you tell?
2 Likes 2 ·
Leo avatar image Leo commented ·
Hi Thom, Do you have a script for that?
0 Likes 0 ·
ThomasRushton avatar image ThomasRushton ♦♦ commented ·
Not off the top of my head.
0 Likes 0 ·
ThomasRushton avatar image ThomasRushton ♦♦ commented ·
OK. Exchange. Looking at the options available in SSIS, I see there's a "Send Mail Task" that works on an SMTP connection... give that the appropriate parameters, create an email that goes to an auto-deleting account, and schedule it to run every minute. If this scheduled task fails, generate the SMS. NB: This is all Quick & Dirty thinking off the top of my head. There are almost certainly better ways of doing this, even within SQL Server.
0 Likes 0 ·
Show more comments
ramesh 1 avatar image
ramesh 1 answered
Yeah that a good idea . you can use solarwind for monitoring network server, which also gives notification email , about the server . for sending email you can use websitepulse for sending sms to mobiles, websitepulse is really good
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Leo avatar image Leo commented ·
Hi, 1 point for you both. Just looked at the websitepulse and that is a good site but I don't think my boss want to spend monthly fee on checking all application including network. What about a script SSIS task - Thomas mention? Do you have a script to check those Network and Excahnge? Thanks.
0 Likes 0 ·
Daniel Ross avatar image
Daniel Ross answered
you could create an ssis package that uses the WMI data reader control, and use the query; Select name, state from win32_service with that query you can look at the current state of every service currently on the target server (or include some parameters to look at a particular set of services). If you can't query the server, then it may be down. Then depending on the state of a service, you can then take appropriate action as needed. Pretty cool huh?
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.