July 10, 2008 at 9:57 am
I'm running both SQL Server 2005 Developer Edition (Enterprise) and SQL Server 2005 Express on my computer. I got an automatic update today--a security update for service pack 2. The developer edition is fine--it installed the update. The Express version is having issues.
After digging through several unhelpful messages, I find an entry in the error log telling me that SQL Server Express has an incomplete installation.
Product: Microsoft SQL Server 2005 Express Edition -- Error 29565. SQL Server Setup cannot upgrade the specified instance because the previous upgrade did not complete. Start the Remote Registry service and go to Add/Remove Programs, select the Change button for Microsoft SQL Server 2005, and then select SQL instance SQLEXPRESS and complete the setup.
So I did what the message suggested. The Change button eventually took me a to a "Complete Suspended Installation" button. Then I got this message:
The feature that you are trying to use is on a network resource that is unavailable.
c:\85c4af34a87a98387104a1e2d62d\Setup\
Um... now I'm stuck. What is it looking for??
July 15, 2008 at 5:41 am
I have the same issue for an instance of Baxkup Exec v11d
July 16, 2008 at 10:36 am
anyone have any idea how to resolve this? I'm seeing the same error
July 28, 2008 at 10:22 am
I'm still trying to solve this problem. I'm getting closer to figuring out what's wrong, but I still can't solve it.
I suspect that the updater is trying to connect to Express using Windows Authentication from the account I'm running in. That would account for the failure, because I can't connect to Express either.
It's set up for Windows Authentication. It used to work with my account, but nearly a year ago my organization changed domain names and all the computer names changed. Obviously, I don't use Express very much since I haven't noticed this until now. I remember that that change messed up my Developer Edition, but since that one was set to Mixed Authentication, I logged in as sa and fixed things.
So, now I have an edition of SQL Server Express with Windows Authentication set and apparently none of the accounts that had connect permission exist any more.
New question: If I unintalled Express, will that harm my Visual Studio installation?
July 28, 2008 at 5:48 pm
I fixed my problem by doing the following...
1. Downloading SQL 2005 express from Microsoft
2. Starting the install (the install extracts the files then starts the install - no way to stop this process)
3. Once the files had been extracted (but before I clicked "next" to continue the install), I copied the extracted files (which were in a temporary folder beneath the root of the C: drive) to another folder so I could access them after canceling the install
4. I then canceled the install of SQL 2005 Express (this deleted the install's temporary folder but I had made a copy of it in the previous step)
5. Then I followed the instruction in the error log that was produced when I tried to apply the SQL service pack in the first place
The problem during the original repair was that there was a point in the repair where the program was looking for the previous install folder for SQL 2005 express.
Once the install got to that point, I directed it to the files I had extracted from the SQL 2005 Express download and it continued and finished successfully.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply