The specified service does not exist as an installed service

  • I am currently working on an ecommerce site on my work computer. I turn on my computer the other day only to get the dreaded blue screen stating my c:\windows\system32\config\system file is missing or corrupt.... so I boot from my xp cd to the recovery console and replace the system file with one from a backed up location (system restore folder) and I can now get into windows fine... although now when windows starts I get the following error message from my MSDE "The specified service does not exist as an installed service" ... I know I can fix this simply by reinstalling my MSDE but Im afraid I may lose the database I've been working on for months.

    Can somebody please advise

    much appreciated

     

  • If you reinstall MSDE it should not affect any user databases you have created.  If you're not sure you can back up the files before installing (.mdf and .ldf files).  After reinstalling, you can use sp_attach_db (see Books Online) to reattach the database.  You will need to recreate logins and mappings to the database.

    If I understand the error message correctly, there is no SQL Server service installed, so you will need to reinstall it.

    HTH

    Dylan Peters
    SQL Server DBA

  • iight.... thanx alot... ill try that

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply