Full-Text Search is disabled

I recently upgraded one of my SQL Server 2014 instance to SQL Server 2017 and applied CU5. Very recently I installed Full Text Feature and instance is enabled for Full Text. Database is enabled  for Full Text. Now when I am trying to create Full-Text Index from SSMS on one of my table , Full-Text Index  […]

Reading Azure Blob Storage Data – SQL Server 2017 – Polybase

In this article we will go over on how to Read Azure blob Storage Data from SQL Server (SSMS) Setup Azure Storage account Grant permission to access the Storage container. Connect to Azure Storage from SSMS ( Storage Account and Account Key Required). Install Polybase feature on the server.(If do not exists) PolyBase Connectivity Configuration. […]

PolyBase Installation with SQL Server 2017

This article talks about how to install SQL Server 2017 polybase post upgrading from SQL Server 2014 and troubleshooting polybase installation rule failures. For more details and limitations go to https://docs.microsoft.com/en-us/sql/relational-databases/polybase/polybase-installation Polybase is introduced in SQL Server 2016.So, post upgrading you have to install polybase as a fresh feature installation to an existing upgraded SQL Server […]

SQL Server Import & Export Wizard provider Error

Error : SSMS DTS Wizard throw error The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine. (System.Data)   TITLE: SQL Server Import and Export Wizard —————————— The operation could not be completed. —————————— ADDITIONAL INFORMATION: The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine. (System.Data)   The error is due to  SSMS calling […]

OPENROWSET -OLEDB-Error

While trying to import data from an excel file we encountered error related to OLDEDB provider (Microsoft.ACE.OLEDB.12.0 &  Microsoft.ACE.OLEDB.15.0) Error encountered on Microsoft SQL Server 2017 (RTM-CU5) (KB4092643) – 14.0.3023.8 (X64) Edition : Developer Edition   OLE DB provider “Microsoft.ACE.OLEDB.15.0” for linked server “(null)” returned message “Could not find installable ISAM.”. Msg 7303, Level 16, […]

Unable to load user-specified certificate [Cert Hash(sha1) “”]. The server will not accept a connection. You should verify that the certificate is correctly installed. See “Configuring Certificate for Use by SSL”

We recently ran into below issue trying to change the SQL Server Service Account. SQL Server Service was running under local service account and the instance is configured for force encryption with certificate. Issue : Unable to load user-specified certificate [Cert Hash(sha1) “XXXXXXXXXXXXXXXXXXX”]. The server will not accept a connection. You should verify that the certificate […]

Reading Mongod log in command prompt

Reading mongod log file in command prompt. Navigate to the log file location and type {TYPE log-file-name} type 1.log If the log file is quite big and you want to read the log file in batches use pipe operator with more tag type 1.log | more  

MongoDB : Check Replication Status

To check replication status, mongodb has rs.status() inbuilt function. abc:PRIMARY> rs.status function () { return db._adminCommand(“replSetGetStatus”); } rs.status ouput If secondary is synced and wasn’t created with slaveDelayoption then optime and optimeDate of secondary should be equal or close (if there are current operations) to those of primary. In that case stateStr should be equal […]

can’t start mongodb service

Stopped the mongod service manually and tried to start the service again which failed to start. Looked into the error log to see what caused the service to fail. Attached below is the error recorded in the error log, which was quite confusing and got me thinking how come permission where removed. [root@lx1 /]# cd /var/log/mongodb [root@lx1 mongodb]# […]

Encryption DMV’s

select * from sys.databases where is_master_key_encrypted_by_server=1 select * from sys.certificates select * from sys.dm_database_encryption_keys where encryption_state=3 SELECT * FROM sys.symmetric_keys SELECT * FROM sys.asymmetric_keys  

SQL Server Encryption with Asymmetric Keys Encrypt by Password

Continuation from http://sqlcontent.com/index.php/category/sql-server-encryption/ Asymmetric Keys Encrypt by Password  do not require to have master key in the database. The following example creates an asymmetric key named _rsa_customer_accmaster_key by using the RSA_2048 algorithm, and protects the private key with a password. USE RSASecData GO CREATE ASYMMETRIC KEY _rsa_customer_accmaster_key WITH ALGORITHM = RSA_2048 ENCRYPTION BY PASSWORD = ‘G%$D@3@f5-34+!DF’; GO […]

SQL Server Encryption with master and Asymmetric Keys

[BOL]:Public Key Cryptography (PKI) is a form of message secrecy in which a user creates a public key and a private key. The private key is kept secret, whereas the public key can be distributed to others. Although the keys are mathematically related, the private key cannot be easily derived by using the public key. […]