An LDAP query through a linked server worked in one domain but failed in another with Msg 7399 from the ADsDSOObject provider. Here is the fix.
SQL SERVER – The Description for Event ID 18456 From Source MSSQLSERVER Cannot be Found
A client’s event log said the description for Event ID 18456 from source MSSQLSERVER cannot be found. Here is what it means and where to see the real error.
SQL SERVER – Error While Enabling Windows Feature: NetFx3, Error Code: 2146498298
A SQL Server 2012 install failed with an error while enabling windows feature NetFx3. Here are the steps to turn on .NET Framework 3.5 in Server Manager.
SQL SERVER – Assembly ‘ISSERVER’ Was Not Found in the SQL Catalog of Database ‘SSISDB’
After a patch, SQL Server would not start: assembly ISSERVER was not found in the SQL Catalog of database SSISDB. Here is what the ERRORLOG showed and the fix.
How to Validate Email Address in SQL Server? – Interview Question of the Week #147
How do you validate an Email Address in SQL Server? Here is a simple query that separates valid addresses from invalid ones in a sample table.
Setup Permission Setting Error: Updating Permission Setting for File Failed
A setup permission setting error stopped a brand-new SQL Server 2016 install at the end. The cause was a TempDB location set to the root of a drive. A dedicated folder for TempDB fixed it.
SQL SERVER – Service Pack Failure: MissingRegistryKeyException
Patching my lab failed with MissingRegistryKeyException for the MSSQLSERVER Performance key. Here is how I read detail.txt and fixed it.