How to rebuild your master database in MSDE when it became corrupted?

Let’s imagine that your instance of MSDE cannot be brought online because of any reason, like when your master database became corrupted or the their files are unavailable. Under such circumstances, if you try to rebuild the master database with a command line similar to this one setup INSTANCENAME="MYINSTANCE" SAPWD="mySAPWd" REINSTALL=ALL REINSTALLMODE=a /I Setup\SqlRun01.msi /L*v…

1

SQL Server 2005 Service Pack 2 failing to install due to an error in Do_sqlGroupMember custom action

One colleague reported to me that one of his customers was getting the following error message when trying to install SQL Server 2005 Service Pack 2: Func Name=’RestoreSetupParams’> Failed to find installation media path due to datastore exception in FindSetupFolder() MSI (s) (C0!C0) [12:50:39:060]: Note: 1: 2203 2: C:\WINDOWS\system32\Setup\SqlRun.msi 3: -2147287038 Loaded DLL: C:\Program Files\Microsoft…

2

Cannot patch an instance of SQL Server 2005 if there is a mounted drive under the Data folder

In the following example, I tried to apply Service Pack 2 on top of an existing instance of SQL Server 2005 which had one mounted point under the instance’s Data folder. In such case, setup failed and SQL9_Hotfix_KB921896_sqlrun_sql.msp.log revealed the following. Configuring ACL:   Object: E:\Microsoft SQL Server\MSSQL.2\MSSQL\Data      ACL: (A;OICI;FA;;;[EMEA\ESTR_s_SQLSRV_SSTR170C])   Action: 0x103 Failed…

1

SQL Server 2005 setup fails if network name of the NIC includes a comma

Is your SQL Server 2005 installation blowing out while trying to install a clustered instance? And are you seeing the following output in setup’s log file? ********************************************** Running: InstallSqlAction at: 2006/1/16 19:50:38 Installing: sql on target: HOSTETCLN101-01 Waiting for remote setup(s) to get ready Remote setup(s) are ready Clustered feature detected: SQL_Engine Clustered feature detected:…

0

SQL Server 2005 hotfix, Cumulative Update or Service Pack installation fails with error 1053

You may be trying to apply one hotfix, one Cumulative Update or one Service Pack on top of your SQL Server 2005 instance and it fails, showing the following information in the setup log, and ERRORLOG, respectively:   From setup log: <Func Name=’SetCAContext’> <EndFunc Name=’SetCAContext’ Return=’T’ GetLastError=’0′> Doing Action: ComponentUpgradeInstall PerfTime Start: ComponentUpgradeInstall : Tue…

1