While configuring AlwaysOn availability group for one of my clients, there were various errors. I planned to write blog on all errors which I encountered. Here is an earlier blog. After we bypassed all errors in “Select Databases” screen, we came to “Specify Replicas” screen. We added both server names and as soon as we hit next, we got below message. Let us learn about how to fix AlwaysOn Wizard Error.
SQL SERVER – Error – Auto Close is Enabled. Only Databases with Auto Close Disabled can be Added to an Availability Group
As a part of my consulting job, I do work with clients who wanted to deploy AlwaysOn availability group. Sometimes there are some simple errors which are encountered, but new DBAs are not aware of such things. In this blog we would talk about one of such error.
How to Assign Multiple Variables in a Single T-SQL Query? – Interview Question of the Week #148
Question: How to Assign Multiple Variables in a Single T-SQL Query?
SQL SERVER – Msg 7399, Level 16 – The OLE DB Provider “ADsDSOObject” for Linked Server “AD” Reported an Error
One of my blog reader told that they are having trouble with linked server to AD. SQL SERVER – How to Query Active Directory Data Using ADSI / LDAP Linked Server. Let us learn about error related to OLE DB Provider.
SQL SERVER – Assembly ‘ISSERVER’ Was Not Found in the SQL Catalog of Database ‘SSISDB’
Due to my connect with my many clients, learning never stops for me. Almost every day someone sends me email for quick 55 minute consultation. You can read more about it over here about how to fix error related to SQL Catalog.
How to Validate Email Address in SQL Server? – Interview Question of the Week #147
How to Validate Email Address in SQL Server?
What is WorkTable in SQL Server? – Interview Question of the Week #146
Question: What is WorkTable in SQL Server?