Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Error Creating Database in SQL 2012 on Windows Server 2012 Expand / Collapse
Author
Message
Posted Friday, February 15, 2013 7:37 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Thursday, October 9, 2014 11:29 AM
Points: 658, Visits: 953
Error creating a database on SQL Server 2012 (enterprise edition) on Windows Server 2012

- installed SQL 2012 Enterprise on Windows Server 2012
- during install, I specified -- default database data and log drive directories to E:\SQLdata and H:\SQLLog respectively
- SQL installed fine

Now, when I attempt to create a database called DBAdmin (the default paths show up correctly in the GUI as E:\SQLdata for the .mdf AND H:\SQLLog for the .ldf) I receive error message:

Create failed for Database. Directory lookup for the file "E:\SQLData\DBAdmin.mdf" failed with the operating system error 5(Access is denied)
CREATE DATABASE failed. Some file names listed could not be created. Check related errors.

I'm DBA on 80+ production servers. First time using SQL 2012 on W/ 2012. I'm Remote Desktop'd into the server and part of A/D group defined as both Local Administrator group and also explicitly defined as sysadmin in SQL server. My SQL Services are running under a single Windows domain acct also in Local Admin Group and explicitly in sysadmin on SQL Server. I've also explicitly added my account and the SQL Server services account to E: and H: drive permissions with FULL control. Not sure why I cannot create a database here???


BT
Post #1420546
Posted Friday, February 15, 2013 8:07 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Thursday, October 9, 2014 11:29 AM
Points: 658, Visits: 953
Researching this potential resolution now:

http://www.sqlservercentral.com/Forums/Topic1300021-2799-2.aspx#bm1395349


BT
Post #1420566
Posted Friday, February 15, 2013 9:01 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Thursday, October 9, 2014 11:29 AM
Points: 658, Visits: 953
Applying the VMWare KB fix worked for us: http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=1012225

thank you..

BT


BT
Post #1420604
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse