i uninstalled MSDE and toasted the service mgr...
-
Okay. I wanted to see if MSDE was cool and determined it was. But I've got vs.net entp ed and figured i didn't need msde anymore. I went to control panel and removed msde. NOW, when i run the service manager, it says "service unavailable" or something like that... What do i do??? Are my databases toasted now? If someone can give me a hand, I'd -reallllly- appreciate it.. Thanks. Oops - forgot to say I'm on XP home edition with SqlServer 2000. ...Steve
-
Okay. I wanted to see if MSDE was cool and determined it was. But I've got vs.net entp ed and figured i didn't need msde anymore. I went to control panel and removed msde. NOW, when i run the service manager, it says "service unavailable" or something like that... What do i do??? Are my databases toasted now? If someone can give me a hand, I'd -reallllly- appreciate it.. Thanks. Oops - forgot to say I'm on XP home edition with SqlServer 2000. ...Steve
Steve Hazel wrote: What do i do??? Are my databases toasted now? If you still have the .mdf (and .ldf, not sure if these are important) files, you should be able to reattach them to an existing database instance. Look up the
sp_attach_dbsystem stored proc. You could probably do this via Enterprise Manager too. I'm not sure what the Service Control manager is complaining about. It may be looking for a particular SQL Server instance (machinename\instance).Bruce Duncan, CP#9088, CPUA 0xA1EE, Sonork 100.10030
Blackadder: Baldrick, have you no idea what irony is?
Baldrick: Yeah, it's like goldy and bronzy only it's made of iron. -
Okay. I wanted to see if MSDE was cool and determined it was. But I've got vs.net entp ed and figured i didn't need msde anymore. I went to control panel and removed msde. NOW, when i run the service manager, it says "service unavailable" or something like that... What do i do??? Are my databases toasted now? If someone can give me a hand, I'd -reallllly- appreciate it.. Thanks. Oops - forgot to say I'm on XP home edition with SqlServer 2000. ...Steve
MSDE is a limited Version of SQL Server and it is actually the same service called MSSQLSERVER Check in Services Control Panel if there is a MSSQLSERVER service running and if it shows to correct path. It can be that you will have to reinstall SQL Server Marek