.NETADO.NETAgileAngularArchitectureASP.NETAuthenticationAzureAzure FunctionBIBig DataBlazorBusinessC#Cloud ServiceCosmosDBCSSDebuggingDesignEncryptionEntity FrameworkFYIGoogleHardwareInternetInterviewsJavascriptjQueryLeadershipLINQManagementMicrosoftMobileMS OfficeMS SQLNetworkingNoSQLOOPProject ManagementSoftware DevelopmentSource ControlSSISSSRSSyncfusionTeamTestingTSQLUncategorizedVendor SoftwareVisual StudioWebWeb ServicesWindowsWordPress
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
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.
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
Script created by SSMS. Severity Alert Error Alert
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
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
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
Error: Fix: Make sure Remote Access checkbox is checked in server properties setting. Make sure “TCP/IP” is set to “Enabled”
Cluster type The possible cluster types depend on the SQL Server version and operating system. Choose one from the following list: Windows Server Failover Clustering Use when the availability group is hosted on instances of SQL Server that belong to a Windows Server failover cluster for high availability and disaster recovery. Applies to all supported... » read more
Using DBCC OPENTRAN Here, I show how DBCC OPENTRAN can also be used to quickly narrow down the specific problem below. When working with SSMS, have you run into a situation where you try to expand the list of tables and SQL Server came back with this nice message? Lock request time out period exceeded.... » read more