While most experienced DBAs would maintain their checklist before installing and setting up SQL Server in the production environment. However SQL Server is a product which is very commonly used by Small and Medium Enterprise who do not necessarily have experienced DBAs. Infact the person, installing SQL Server may not be even a DBA. I… Continue reading SQL Server Deployment Checklist
Category: SQL SERVER SETUP
This category discusses about some of the sql server setup issues seen or experienced by me.
A failure was detected for a previous installation, patch, or repair during configuration for features
Recently I was trying to apply a security update for one of my SQL instance and I encountered the following error in my summary log Note: For those who are not aware, summary.txt is located in C:Program FilesMicrosoft SQL Server100Setup BootstrapLog A failure was detected for a previous installation, patch, or repair during configuration for… Continue reading A failure was detected for a previous installation, patch, or repair during configuration for features
Why should I be connected to internet when installing Denali?
It has been really long time since I posted my last blog and even though I do intend to blog more often, i couldn’t do it as much as I would like. Anyways I will try my best to blog as often as I can. In this post, I would like to mention small tips… Continue reading Why should I be connected to internet when installing Denali?
SQL Server 2005 Setup Failing to Install on Cluster with Unexpected Failure while Performing the SCC checks
We have observed a number of cases where the installation of the sql server 2005 instance on the cluster fails with the following unexpected Failure Error Message while performing SCC checks. ERROR MESSAGE: ==================== There is unexpected failure. MSGID 50000 In order to troubleshoot the issue we followed the following steps 1) We… Continue reading SQL Server 2005 Setup Failing to Install on Cluster with Unexpected Failure while Performing the SCC checks
Error 11032 Unable to install Windows Installer MS while installing security patch KB 948109 on sql 2005 instance
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… Continue reading Error 11032 Unable to install Windows Installer MS while installing security patch KB 948109 on sql 2005 instance
Error 29527 while installing security patch 948109
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… Continue reading Error 29527 while installing security patch 948109
UNABLE TO INSTALL SECURITY PATCH 948109 TO SQL SERVER 2005 EXPRESS EDITION WHICH IS INSTALLED ALONG WITH ACT7 SOFTWARE.
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… Continue reading UNABLE TO INSTALL SECURITY PATCH 948109 TO SQL SERVER 2005 EXPRESS EDITION WHICH IS INSTALLED ALONG WITH ACT7 SOFTWARE.
INSTALLATION OF SQL EXPRESS EDITION FAILS ON WINDOWS VISTA WHILE INSTALLING MICROSOFT OFFICE ACCOUNTING 2008
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… Continue reading INSTALLATION OF SQL EXPRESS EDITION FAILS ON WINDOWS VISTA WHILE INSTALLING MICROSOFT OFFICE ACCOUNTING 2008
ERROR 29506 while Installing the SP2 on the sql server 2005
This post talks about the location of the log folder where all the sql server 2005 setup logs are located. It mainly provides the solution of the error 29506 during installation of the sql server sp2.