Issue
On attempted creation of new database receive the below errors.
Database creation failed.
Installation Error! <[Microsoft][ODBC SQL Server Driver][SQL Server]The database 'ContinuumDB' does not exist. Supply a valid database name. To see available databases, use sys.databases. >
Installation Error! <[Microsoft][ODBC SQL Server Driver]Invalid cursor state>
Installation Error! <[Microsoft][ODBC SQL Server Driver]Invalid cursor state>
Environment
Continuum Cyberstation
Cause
The "DB File Location" in the Database Initialization dialog is not specified properly.
Resolution
-
Check where the "Data" folder resides on the SQL server
A typical SQL Express install will have this located at "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data" but depending on the type of SQL, Operating System, and if any other instances of SQL - this location could be different.
The correct folder contains at least six files:- master.mdf
- mastlog.ldf
- model.mdf
- modellog.ldf
- tempdb.mdf
- templog.ldf
- Type this path location into the "DB File Location" field
- Re-attempt the Database creation.