Ack, please help! We have a SQL Server 2008 R2 server running on Windows Server 2008 R2
and it was running 100% wonderful up till this weekend when the Network Administrator installed windows service updates...
Now, my DB Mail doesn't work and my Maintenance Plan jobs are failing. :(
The DB Mail gives the following error:
Object Instance Not Set to an Instance of an Object.
The Maintenance Plans say:
Failed to acquire connection "Local Server Connection". Connection may not be configured correctly or you may not have the right permissions on this connection.
The SQL Agent starts up with a DOMAIN account that has Admin rights on the server.
I have tried deleting the Mail account and profiles and recreating them ...that did not fix the DB mail problem... I'm at a loss...
Does anybody know what windows updates would cause this problem? The network admin thinks it could be "a legacy .NET issue". But he's just guessing... Thanks!