Author

An error occurred during the execution of xp_cmdshell. A call to ‘LogonUserW’ failed with error code: ‘1326’.
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)
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

Global e-mail profile missing from SQL Server
Global e-mail profile missing from SQL Server

During a visit to a regular customer, a strange request came from the upper IT management. As I was told, they noticed that the global email profile in one of their core SQL servers was mysteriously removed, resulting to errors and delays sending emails to some thousand customers, hence, they wanted me to investigate the... » read more