Thursday, February 16, 2012

Cannot get SQL 2005 Express to load

Initially I loaded SQL along with C# however it said at the time that the load had been unsuccessful. I continued as I knew I wouldnt need SQL for a while.

I also have Web Developer loaded and this would not load SQL 2005 Express either.

I have tried loading SQL 2005 Express as a seperate download and I note that rollback occurs - I presume because of the COM+ warning that appeared. I have been through the 'Work around COM+ System Configuration Check Failure in SQL Server Setup' document - to no avail. The following parts of SQL that have not loaded:

SQL Server 2005 Database Services.

I have also tried deleting all components of Visual Studio 2005 Express Edition and loading SQL as the first component; that also failed.

I have saved the logfile, however I dont really know what I'm looking for. sqlActionManaged = 3, sqlStateManaged = 2.

I'll answer this myself - just so anyone who's browsing needs the answer - and it aint pretty!!

The only way I could get SQL DB to load was to restore the system back to the factory configuration. I could then load SQL and then re-build my system back to how it was - luckily for me I've got my hard drive partitioned off so I could just dump all my stuff in there and the move it back after I'd restored. Ouch!

No comments:

Post a Comment