CREATE DATABASE failed

Because of the environment, modify the location of the data files and log files of the default database for SQL Server 2012. As follows:

Create database, encounter error.

Error message:

A file activation error occurred. The physical file name ' E:testaaa.mdf ' may be incorrect. Diagnose and correct additional errors, and retry the operation.
CREATE DATABASE failed. Some file names listed could not be created. Check related errors. (Microsoft SQL Server, error:5105)

Observe the error message and report that my file is named ' E:testaaa.mdf '. It is clear that there is a backward slash missing here.

Manually add a backward slash, no results.

Use the button on the edge of the text box to select the root directory, OK. Still no fruit.

Check the KB, no fruit.

Workaround

====================

A folder is created under the root directory, and the default location is changed to a folder in the root directory, OK.

Comments

====================

It's annoying to let people choose the root directory and not to use it.

Resources

=======================

You could receive error messages when you use the CREATE DATABASE statement to create a SQL Server DATABASE

Http://support.microsoft.com/kb/836873/en-us

CREATE DATABASE failed