Warning to Windows 2003 SP2 and SQL Server Users
I was asked to install SNMP on to a Windows 2003 SP2 SQL Server. I wish I had this information before I did this and bought down a national application for about 2500 users.
Installing SNMP on a Windows 2003 SP2 server with SQL Server installed
Be Warned!
If you are installing SNMP on a Windows 2003 SP2 server that has SQL server installed beware of the following.
The following services are automatically stopped without any notification to the user.
Microsoft SQL Server service
SQL Server Agent
MSDTC
These service are NOT restarted automatically.
If you downgrade to SP1 or are using any other O/S this does not happen.
This "feature" does not appear to have been advertised by Microsoft upon release of SP2 for Windows 2003.
Make Sure to check out
http://www.jadereynolds.co.uk
The following services are automatically stopped without any notification to the user.
Microsoft SQL Server service
SQL Server Agent
MSDTC
These service are NOT restarted automatically.
If you downgrade to SP1 or are using any other O/S this does not happen.
This "feature" does not appear to have been advertised by Microsoft upon release of SP2 for Windows 2003.
Make Sure to check out
http://www.jadereynolds.co.uk
Hot Links
- Jadereynolds.co.uk
- Find out how to get your hands on some of the latest gadgets at a fraction of the cost. Proces start from free - £10 or $10
Click Here for your Free MCITP Windows 2008 Training kit
Please Leave a comment if you found this useful
submit
-
Reply
- F1 F1 Aug 7, 2009 @ 1:50 pm
- Thanks for the info. I think you will also find that this only affects 32bit SQL servers.
-
Reply
- Boris Boris Sep 25, 2008 @ 12:00 pm
- I had the same problem.
Did anyone find the solution for this?
-
Reply
- MaKI MaKI Jul 4, 2008 @ 3:48 am
- Yes I can confirm. Yesterday we have successfully stopped production (HIGH IMPORTANT) database server with installation of SNMP. ;-) This is only message I've found on google which explaining this. Thanks.
Great Stuff on Amazon
Some books that may interest you
Windows Server 2008 Inside Out
Amazon Price: $37.79 (as of 12/18/2009) 
Used Price: $32.81
Windows Home Server Bible
Amazon Price: $23.09 (as of 12/18/2009)
Used Price: $18.80
Windows Home Server For Dummies (For Dummies (Computer/Tech))
Amazon Price: $16.49 (as of 12/18/2009)
Used Price: $4.77
by grabrail
Hi, Im Grabrail. I live in Nottingham in the UK and I like to get things for free.
Im a regular Joe with a regular job making "the man" rich, so why... (more)
Im a regular Joe with a regular job making "the man" rich, so why... (more)
Explore related pages
Cheap Dedicated Hosting - Compare Cheap Dedicated Servers- Starter Packet at ServerPronto AMD 2000+, 256 DDR RAM, 40GB HDD, 200GB Transfer...
Are You Ready for a Computer Ram Upgrade ?- Well, let's keep things simple. More or faster memory in your computer will shor...
Backup Software-Computer-Online-Network- Discover the best backup software applications for your PC, Home Computer, Netwo...
Building - Computer Floors- A high ground, additionally described as an access floor or artificial ground, i...
