SQL Server 2005, SP2 (build 3042) running on Windows 2003 Server (SP2) functioning properly. However, I need to install hot fixes that came out after SP2 on the SQL Server instance. Actually, now that SP3 is out, I'd like to install that.
Here's the history: Installed SQL Server 2005 in June 2007, and applied SP2 successfully shortly after original install (probably immediately after rebooting machine). In August 2008, a co-worker attempted to install Hotfix 8, which should have brought the build number to 3257. The install of that hotfix was unsuccessful. I've reviewed the hotfix.log files, and see that after the attempts to install the hotfix, there are warning messages in the log, but nothing "helpful". For example: "Warning: Product HotFixSQL is missing LCID value". I have no idea what that means, and searching for it hasn't yielded anything helpful either.
So, last week, I tried installing SP3 on the machine, and it "appeared" to install successfully (no error messages anywhere and a "success" message after install completed. However, after rebooting the machine, and opening SSMS, the build number has not changed (still on 3042) and executing "SELECT @@VERSION" shows the same thing.
Anyone know how to find what is causing this problem, and/or how to fix it?
Here's the history: Installed SQL Server 2005 in June 2007, and applied SP2 successfully shortly after original install (probably immediately after rebooting machine). In August 2008, a co-worker attempted to install Hotfix 8, which should have brought the build number to 3257. The install of that hotfix was unsuccessful. I've reviewed the hotfix.log files, and see that after the attempts to install the hotfix, there are warning messages in the log, but nothing "helpful". For example: "Warning: Product HotFixSQL is missing LCID value". I have no idea what that means, and searching for it hasn't yielded anything helpful either.
So, last week, I tried installing SP3 on the machine, and it "appeared" to install successfully (no error messages anywhere and a "success" message after install completed. However, after rebooting the machine, and opening SSMS, the build number has not changed (still on 3042) and executing "SELECT @@VERSION" shows the same thing.
Anyone know how to find what is causing this problem, and/or how to fix it?