SQL Problems Preventing Use of EPO 2.5sp1

[AuntieEPO]

The server on which our EPO runs recently had a failed disk, when replaced we restored from a full backup.

I am unable to get the MSSQL Server service to start, the error states that "the service did not return an error"

Its running on the SQL7 installation which is part of the EPO installation (MSDE?). We also run an SQL2000 database on a shared drive on the same server, which holds a customer databse. The SQL2000 service runs and we can access the database. I dont think this is the problem, both ran along side each other fine beforehand.

Question - would the EPO SQL database be expected to reside in the C:\Program Files\Epo\MSSQL7\Data folder? I would assume so, and since there is nothing in this folder it would explain that when trying to connect to the database and/or start the service in SQL enterprise manager i get an "unable to connect, database is either missing or permissions are wrong" type message.

Does it appear as though the database was not part or our backup >> so i need to re-build the EPO daatbase? Any ideas appreciated.

 

[AVChap]

What was the sequence of installation of ePO and SQL2000? If you installed SQL2000 BEFORE ePO (and MSDE), this may happen.

I presume the sequence was reversed initially? If this is the case, can't you run ePO on the same SQL server? (Just a thought )


AVChap
... my $1 worth of advise, 2cents isn't enough due to inflation

 

[AuntieEPO]

The epo installation of MSDE from SQL 7 came first.

The fact that I cannot connect the SQL server in enterprise manager suggests to me that the database has gone - if not I would expect to see an .mdf file in the data directory - which I cant. So I guess I can only start fom scratch and re-build the SQL databse, probably easier to just start the whole EPO install again then is it not? I dont know a great deal about SQL.