Labels

Friday, 1 September 2017

CREATE DATABASE failed. Some file names listed could not be created. Check related errors. [SQLSTATE 42000] (Error 1802). The step failed.

Possible Reasons and Resolutions :

This problem usually occurs when the user that is trying to create the database doesn't have the necessary permissions in SQL Server. If you use the Administrator's account to create the database, this situation can be avoided. You can also check if the account that failed to create the database has the permissions described in this article.
The problem can also occur if the name of the database you attempted to create is already in use by another database or if files from a database with the same name remain on the computer. Try creating a database with a different name.
Check if the disk on which the SQL Server is trying to create the database has enough free space.

No comments:

Post a Comment