Problem running MSDE 2000 with SQL Server 2000 and cannot uninstall MSDE
Posted on 2003-03-31
Hi, I really hope that someone can help me out!
I recently installed MSDE 2000 on my Windows XP Pro laptop to develop a standalone VB application with an embedded database. My plan was to build the database in SQL Server 2000 and then migrate it over. I created a test database and attached it MSDE and easily added data, ran sp’s, etc.
The problem came up when I powered up my laptop this morning. I could no longer connect to my SQL Server database. (The error was something to do with “corrupt” and possibly “invalid ID” - I wish that I had written it down).
Google searches suggested running SQL Server setup again, which I did, but didn’t have any luck fixing the installation. They also mentioned that this can come up if the name of the machine is changed, which I didn’t do.
So I decided to uninstall SQL Server and reinstall it, hoping that would fix the problem. After doing so and attempting to connect to the SQL Server, I got the error:
Login failed for user 'sa'. Reason Not associated with a trusted SQL Server connection
I tried several installs with different options (windows authentication, no sa password, etc.). Nothing seemed to work.
At this point, my theory was that MSDE was causing the problem, since it was the only recent change to my machine. I uninstalled SQL Server (again!) and attempted to uninstall MSDE (from control panels/add remove programs). It ran through the normal uninstall process, then I got the error:
“Fatal Error during installation”
In a perfect world, I would love to have SQL Server 2000 and MSDE 2000 running flawlessly. My second choice would be to just get SQL Server running again and to successfully remove MSDE. At that point, I will most likely choose an alternate database solution for this product.
Thanks in advance!