Cannot Create Database

Modified on Wed, 18 Dec, 2019 at 11:41 AM

Problem: Cannot open Blue Cherry because it cannot create a database, this refers to a date stamp that may have been added to the SQL Server Primary Database files .mdf & .LDF.




HOW TO FIX:


1. Open ‘SQL Server Configuration Manager’ and ‘Stop’ the service to the ‘SQL Server (GERRESPSQLSERVER)’



2. Locate the ‘SQL Server Data Files (GerathermRespiratory.mdf & GerathermRespiratory_Log.LDF)’


Usual Location: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data
– although could be Program Files (x86)



3. Remove the date stamp from the filename.


4. In the ‘SQL Server Configuration Manager’ ‘Start’ the service to the ‘SQL Server (GERRESPSQLSERVER)’.



5. Open Blue Cherry.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article