First of all, congratulations for deciding to get prepared for this exam. You apparently have lots of guts and determination! To my honest belief, this was a demanding exam that required focus and discipline in order to pass it. I was not confident that I would be able to get a Pass on the first... » read more
Fix error code 0x8009030c: Login Failed. The login is from an untrusted domain and cannot be used with Windows authentication.
We were recently facing an issue where several SSIS packages failed to execute against a newly created SQL FCI Cluster with DAG and several listeners created, with the following error being received as an output. Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. [CLIENT: xxx.xxx.x.xxx] SSPI handshake... » read more
Lately, we’ve had an interesting conversation on how could developers begin to sort of categorize various data stored within SQL databases. As our customer is located in a EU country, they are deeply concerned and have to strictly comply with GDPR, along with a custom security pattern that combines ISO27001 and PCI DSS. Understanding your... » read more
There is an unfortunate situation, where your Active Directory’s database gets corrupted and you are left with no clues of what has caused this inconvenience, or how to resolve it. Sadly, we had to recently face that issue as this Event ID gets accompanied by several others, including Event ID 1084, of task category Replication,... » read more
Before starting, let me inform you that Microsoft itself, promotes no way (or supporting) of downgrading Windows Server versions. In my case, i wanted to downgrade several Windows Server Datacenter servers, to Standard Edition, during their in-place upgrade process. The initial plan was to create new VMs and reinstall everything but the heavy configuration and... » read more
An error occurred during the execution of xp_cmdshell. A call to ‘LogonUserW’ failed with error code: ‘1326’.
Recently, i was invited by a senior developer to investigate an issue with the aforementioned result. User was receiving the below error when tried to execute a specific Stored Procedure by using xp_cmdshell: Msg 15121, Level 16, State 200, Procedure xp_cmdshell, Line 1 [Batch Start Line 338] An error occurred during the execution of xp_cmdshell.... » read more
OLE DB provider “Microsoft.ACE.OLEDB.12.0” for linked server returns message “Unspecified error”. (Microsoft SQL Server, Error: 7303)
An interesting request came up from one of our customers. They were unable to complete a process that was running until lately. During a mass update in a database from a Microsoft Excel file, the export process was not producing a file. This custom upload process is based on a Microsoft. ACE.OLEDB.12.0 SQL Server Linked... » read more