Re: Cannot create database [was: password limitations]

Josh Hillman ( (no email) )
Fri, 2 May 1997 17:32:52 -0400

> I have tried to do so, and found I still had the 6 character
> restriction. Later I learned that the entire database was not
> *properly* functioning as well so after a day of frustration I am
> completely reinstalling SQL server and Emerald to figure out just where
> the installation went wrong. After looking at the little documentation
> that exists from a couple sources on the installation I have run into a
> few problems that maybe I can get some help with. Upon trying to create
> a new database with the Emerald Administrator I get the error message,
> "Create Database Failed. Please Check the Device Settings and Retry"

Before attempting to recreate the Emerald db, go into the \MSSQL\Data
directory and physically delete the Emerald.dat file (and anything else
that may have "emerald" in it). THEN go and recreate the db. For some
reason, SQL doesn't actually delete the database file when the database has
been removed.

Josh Hillman