Cannot reinstall 2005 Express - Help!

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Cannot reinstall 2005 Express - Help!

Author

Topic

AlanPG
Starting Member

3 Posts

Posted - 2009-04-17 : 07:01:56

I will try and keep this short.

Basically, I had SQL Server 2005 Express installed on my PC. I then installed 2008 by accident (when installing VS2008). As I result I was unable to access a 2005 database I had on the system. I uninstalled 2008 and even 2005 so I could start from scratch again.

However, now when I try to re-install 2005, I am blocked with the following:

The Following components that you chose to install are
installed on the machine. etc

SQL Server Database Services 10.0.1600.22

This obvioiusly refers to 2008, but I uninstalled it and can see no obvious way to additionally get rid of this service.

Can anybody help please?

PS I notice there are many registry entries for Microsoft SQL Server, and the version numbers refer to 10.0.1600.22. Should I just remove Microsoft SQL Server from 'HKEY_LOCAL-MACHINE\Software\Microsoft'?

thanks

AlanPG
Starting Member

3 Posts

Posted - 2009-04-17 : 10:06:47

I went to the previous Restore Point, uninstalled SQL Server, and re-installed 2005 Express. I can now access databases using Management Studio, but whenever I try to make a connection to a 'mdf' file using VS 2005, I get the following message:

"Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance."

I have tried all manner of things, but cannot resolve this problem. When I click on 'Test Connection' when looking at the properties of the mdf file, the error appears.

Can anyone please advikse as I have wasted all day on this problem, so far.

thanks

AlanPG
Starting Member

3 Posts

Posted - 2009-04-17 : 15:34:10

So nobody on here has any ideas then? Fortunately, I found some reference to it and deleting the sqlexpress folder under my local settings did the trick.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources