Issue with SQL Server Restart when Installing SNMP
George Dougherty emailed me with an interesting problem that he and Tony
Sengphirom discovered.
“A cursory google search didn't find anything, but we came across a pretty
big gotcha this morning with our production database server. We're running SQL
2000 on Windows 2003 R2 with SP2. I haven't tested against our test 2005 box but
it may affect 2005 as well. With SP2 applied if you install SNMP on 2k3, the
install restarts MSDTC, SQL Agent and the SQL server itself without asking for
any user input. Downgrade or do this on a box without SP2 and SNMP goes on
without any restarts. Needless to say it was a big surprise this morning when
one of our network admins installed on our production box as the company got in
and started their day.”
I haven’t verified their findings (too busy getting ready for
DevConnections!), but wanted to get their report out.