Re: Emerald Database

Mohammed Ersan ( (no email) )
Thu, 20 Aug 1998 09:36:23 +0300

you need to start the database in single user mode try closing the EM then make sure that nobody is logged in to the database even the services such as Radius and any other services that are using the database then execute this Query in the iSQL :

use emerald

go

sp_dboption 'Emerald','single user', TRUE

go

then close this iSQL connection

start the EM you'll notice a special icon next to the Emerald Database, indicating the single user mode.

to get it back to normal after changing what ever you want to change double click the emerald DB then un check the single user mode int the options menu.


At 04:23 PM 08/20/98 +1000, you wrote:

>Try deleting or renaming the Emerald.dat out of \mssql\data

>moored@romtech.com.au

>

>-----Original Message-----

>From: Humberto Guzman <<hguzman@sysop.com.mx>

>To: emerald@iea-software.com <<emerald@iea-software.com>

>Date: Friday, August 21, 1998 2:07 AM

>Subject: Emerald Database

>

>

>>Hello,

>>

>>I just installed Emerald on our server, but we keep getting an error

>>message when trying to create the database, we had created it, but deleted

>>it in the Emeral Admin, now we can not create it again... We already tried

>>re installing emerald.

>>

>>The message we get is:

>>Create Device Failed.

>>Please Check the Device Settings and Retry.

>>

>>Any ideas?

>>Thanks!

>>Humberto G

>>

>

>

>

<center>Mohammed Ersan

ersan@first.net.jo

firstnet

</center>