bluecjh
Programmer
- Mar 12, 2003
- 385
New 2005 installation,
I tried to create a database on the server.
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
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