Cant create a database...Not sure why

• asm1212

  Hall of Fame

  Points: 3482

  More actions

  March 26, 2013 at 1:54 pm

  #291391

  Hey guys,

  Ran into a problem I have never seen before...

  I am logged on to a SQL Server box as sa with sa rights...

  I go to create a database, give it a name, the drives are already populated, and when I click OK, I get the following error

  CREATE FILE encountered an operating system error 5(Access denied) while attempting to open or create the file blah blah blah...

  What is this error? I even went to the drive where it will be created and created a txt file on that drive so:

  I am logged in as SA on SQL Server

  I can create a file on the drive

  Why is it not letting me create a database? Any suggestions?

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  March 26, 2013 at 2:03 pm

  #1600956

  Duplicate post. Do not reply.

  http://www.sqlservercentral.com/Forums/Topic1435672-1550-1.aspx#bm1435678

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/