Author

SELECT failed because the following SET options have incorrect settings: ‘QUOTED_IDENTIFIER’

Error: SELECT failed because the following SET options have incorrect settings: ‘QUOTED_IDENTIFIER’. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML data type methods and/or spatial index operations. Fix: Replace… SET QUOTED_IDENTIFIER OFFGO with… SET QUOTED_IDENTIFIER ONGO SET QUOTED_IDENTIFIER must... » read more

0
Read
echiang
The service did not start due to logon failure.

Error: Getting the following error when trying to set a network account to run SQL Server service. The service did not start due to logon failure. Fix: Make sure the network account has “logon as a service” permission. Enable service log on permission for Run As accounts Go to Administrative Tools and select Local Security... » read more

0
Read
echiang
SSRS Error: Failure sending mail: The specified string is not in the form required for an e-mail address.Mail will not be resent.

SSRS Error: Getting the following error when trying to setup SSRS subscription… Failure sending mail: The specified string is not in the form required for an e-mail address. Mail will not be resent. Issue: If you are using an SMTP server or forwarder that uses e-mail accounts that are different from the domain user account,... » read more

0
Read
echiang
Install StackOverflow Database Locally

https://www.brentozar.com/archive/2015/10/how-to-download-the-stack-overflow-database-via-bittorrent/ After you download it, extract the .7Zip files with 7Zip. (I use that for max compression to keep the downloads a little smaller.) The extract will have the database MDF, NDFs (additional data files), LDF, and a Readme.txt file. Don’t extract the files directly into your SQL Server’s database directories – instead, extract them somewhere... » read more

0
Read
echiang
Unable to Drop/Delete Database from Server

Use the following to drop the database… If the above failed, do this… Stop the SQL Services. Kill the sqlserver.exe process on service if the services fail to stop. Manually delete the physical database files from the drives. Restart the SQL Services, then drop the database.

0
Read
echiang
Google IAP Desktop

Install the IAP Desktop application using the following link: https://github.com/GoogleCloudPlatform/iap-desktop/releases/latest/download/IapDesktop.msi. https://cloud.google.com/blog/products/identity-security/zero-trust-remote-access-for-windows-vms It’s more important than ever for IT administrators to be able to securely access resources from wherever they are. Exposing VM instances to the public internet can be risky, potentially giving bad actors a direct access path to your network. But solutions such as... » read more

0
Read
echiang
MMC could not create the snap-in for SQL Server Configuration Manager

Error: MMC could not create the snap-in for SQL Server Configuration Manager RegEdit: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MMC\SnapIns{eeed5f7e-9cae-45e2-9dd6-c9f44246cc37} C:\Program Files\Microsoft SQL Server\160\Tools\Binn\SqlManager.dll file not found Fix: Microsoft Management Console (MMC) is a built-in feature in Windows operating system that lets you manage snap-in on the go. Snap-ins are basic component of a console. Sometimes, snap-ins may not work properly,... » read more

0
Read
echiang
MMC could not create the snap-in for Task Scheduler

Error: MMC could not create the snap-in. The snap-in might not have been installed correctly. Fix: Microsoft Management Console (MMC) is a built-in feature in Windows operating system that lets you manage snap-in on the go. Snap-ins are basic component of a console. Sometimes, snap-ins may not work properly, especially if the registry configuration of... » read more

0
Read
echiang
Rebuilding of indexes cause the transactional log file to grow

The index rebuild operation runs by default in a single long-running transaction, that prevents the Transaction Log space reuse while rebuilding a large index. Switching to the BULK_LOGGED recovery mode while doing an index rebuild operation will reduce the amount of transaction log generated. If you’re considering using the BULK_LOGGED recovery mode, beware that you... » read more

0
Read
echiang