Fix Microsoft SQL Server Error 14258








As part of our Server Support Services, We have helped numerous customers to fix  SQL related issues.

In this context, we shall look into why this error occurs and how to best solve SQL Server error 14258.

What triggers SQL error 14258?

The most common reason for this error is when the MAP132.dll service is being used. Sometimes the SQLMail using MAPI client to send email  is being occupied at the same time. Therefore an error which looks like this is displayed;


An exception occurred while executing a Transact-SQL statement or batch.(Microsoft.SqlServer.ConnectionInfo) Cannot perform this operation while SQLServerAgent is starting. Try again later. (Microsoft SQL Server, Error: 14258)


How to fix Microsoft SQL error 14258

A quick fix to this error can be done by changing the Mail system to use Database Mail instead of SQLMail. To do this in SQL Server agent, navigate to the "Alert System" where you will see "Properties settings". From the Properties window, you can make the change to Database Mail.

Need support in solving SQL errors? Reach us Today.


Conclusion

SQL Server error 14258 triggers when a job is trying to run in the affected SQL instance.


For Linux Tutorials

We create Linux HowTos and Tutorials for Sys Admins. Visit us on LinuxAPT.com

Also for Tech related tips, Visit forum.outsourcepath.com or General Technical tips on www.outsourcepath.com