Enable Failure Email for SQL Agent Jobs
How to Enable Failure Emails for SQL Agent Jobs Expand SQL Server Agent. Expand Jobs. Right click on a Job > Properties. Go to the Notifications tab. Click to enable Email. Select the correct Operator. Choose “When the job fails” Hit OK. Note: Make sure the SQL Server Mail Account and Profile has been setup correctly.
Linked server was unable to begin a distributed transaction.
Error: The operation could not be performed because OLE DB provider “SQLNCLI11” for linked server “xxxx” was unable to begin a distributed transaction. Fix: The default settings were not configured correctly to allow communication with the other servers. These configuration settings are found under the Component Services snapin which can be launched by typing dcomcnfg.msc at a run/command... » read more
Unable to send email from SQL Server
Error: Message The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2020-07-23T17:27:13). Exception Message: Cannot send mails to mail server. (Mailbox unavailable. The server response was: 5.7.1 Unable to relay). ) Fix: Make sure the SQL Server Mail Account and Profile are setup correctly.
Linked Server Login Failed
Error: Msg 18456, Level 14, State 1, Line 3 Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’. Fix: Change the login to be… “Be made using this security content:“ Remote login: xxxxxx With password: xxxxx
Create Alert from Script
Script created by SSMS. Severity Alert Error Alert
Create Operator
Create Operator From Script No Pager schedule. Multiple Email Addresses: Add multiple email addresses separate by semi colon “;” E-mail name: address01@test.com;address02@test.com You could create a new operator with the semi colon delimited list of email addresses. Looking at the definition of sysoperators this is good for strings that can fit in nvarchar(100) If you need to exceed... » read more
SQL Server Autogrowth
Auto-growth What exactly are auto-growth events? An auto-growth event is the process by which the SQL Server engine expands the size of a database file when it runs out of space. The amount by which a database file grows is based on the settings that you have for the file growth options for your database.... » read more
Unable to Join Replicas to Available Group – Download configuration timeout. Error 47106
Error: Availability group xxxx is not joined on the secondary replica xxxx. (Microsoft.SqlServer.Management.HadrModel) Program Location: at Microsoft.SqlServer.Management.HadrModel.HadrTask.Perform(IExecutionPolicy policy, CancellationToken token, ScenarioTaskHandler taskDelegate) at Microsoft.SqlServer.Management.Hadr.JoinDatabaseToAvailabilityGroupWorkItem.DoWork() at Microsoft.SqlServer.Management.TaskForms.SimpleWorkItem.Run() Failed to join local availability replica to availability group <ag1>. The operation encountered SQL Server error 47106 and has been rolled back. Check the SQL Server error log for... » read more
SQL Server Remote Access Denied
Error: Fix: Make sure Remote Access checkbox is checked in server properties setting. Make sure “TCP/IP” is set to “Enabled”