Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Error 5101 Create Database Failed.??

Status
Not open for further replies.

bluecjh

Programmer
Mar 12, 2003
385
New 2005 installation,

I tried to create a database on the server.

Code:
Create failed for Database 'test'.  (Microsoft.SqlServer.Smo)
------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

A file activation error occurred. The physical file name 'X:test.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)

I tried adding permissions (full control) to the
account sql server runs under on all root directories but to no avail.


can anyone shed some light?

thanks.

BlueCJH
 
Sorted

The default file paths on a new database were incorrect

thanks

BlueCJH
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top