Unable to create new database - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Express Edition and Compact Edition (2005)

Unable to create new database

Author

Topic

jleadbetter
Starting Member

2 Posts

Posted - 2007-07-10 : 10:18:13

I had a fully functioning SQL 2005 Exp install until today. All of my DBs work, Reporting Services works. But today I went to add a new DB for a DotNetNuke installation. Everything I have tried fails with the same error:

*****************************************************
TITLE: Microsoft SQL Server Management Studio Express
------------------------------
Create failed for Database 'TEST'. (Microsoft.SqlServer.Express.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Database&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)
------------------------------
A file activation error occurred. The physical file name 'G: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)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=5105&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
*****************************************************

I have looked high and low for a solution only to come up empty handed. I only hope at this moment that someone here has seen this before.

Thanks

Jason

jleadbetter
Starting Member

2 Posts

Posted - 2007-07-10 : 10:38:55

FINALLY!!!

Found the answer: [url]http://www.sql-server-performance.com/forum/post.asp?method=TopicQuote&TOPIC_ID=18462&FORUM_ID=24[/url]

Can't create new DBs outside of the local SQL server install HDD without using SAN.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources