You are able to submit the data in the table using the application like InfoPath 2007 but when you go ahead and add the table in the Merge Replication Publication, the insert into the table using the InfoPath form starts to fail. This issue occurs when we have the application designed to insert data into…
We get the below error message when distribution agent tries to sync, Error: 14151, Severity: 18, State: 1. The subscription(s) have been marked inactive and must be reinitialized. NoSync subscriptions will need to be dropped and recreated. CAUSE: ====== When we check the Publication properties, we find that the options for subscription expiration are…
Minimize the MSI code for setup and use MSI code for what it does the best. In Sql 2005 entire setup process was coded using MSI code which uses the Windows Installer code and was found to be root cause of many setup failures in sql 2005. However in sql 2008 setup process has been…
In order to install, upgrade, uninstall, and patch the sql server 2008 instance on the system we need to call the setup.exe from the installation media. The setup.exe is an unmanaged code which checks the basic pre-requisites to launch the actual Setup process. The basic pre-requisites check performed by setup.exe is 1) It checks for…
While installing security patch KB 948109 on the sql server 2005, the installation of the patch may fail. In order to find the cause of the failure we need to look into the setup bootstrap logs which are located in the following location C:Progarm FilesMicrosoft Sql Server90Setup BootstrapLOGHotfixSummary.txt One of the cause of the failure…
Have you ever wondered how to change the keys for the encryption for an already encrypted database. For this you can use “Key Rotation”. Key rotation is the process of decrypting data with the old encryption key and encrypting the data with the new encryption key. But how to use the Key Rotation with SQL…
While installing security patch KB 948109 on the sql server 2005, the installation of the patch may fail. In order to find the cause of the failure we need to look into the setup bootstrap logs which are located in the following location C:Progarm FilesMicrosoft Sql Server90Setup BootstrapLOGHotfixSummary.txt One of the cause of the failure…
The ACT7 software installs sql server 2005 express edition along with the installation of ACT7 software. When we try to apply the latest security patch 948109 released by Microsoft for sql server 2005, the installation may fail. In order to find the cause of the installation we need to look into the setup boothstrap logs…
We have a production database in which the data is encrypted. The encryption follows the following hierarchy 1) The data is encrypted using Symmetric key 2) The symmetric key was encrypted using asymmetric key 3) The asymmetric key was encrypted using the master key of the database 4) The master key of the…
There have been a number of instances where we observed that the installation of the sql express edition on Windows Vista which also gets installed along with Microsoft Office Accounting 2008 fails which ultimately causes the installation of the Office Accounting 2008 on Windows Vista to fail. So in order to successfully install Sql…