February 15, 2013 at 7:37 am
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???
February 15, 2013 at 8:07 am
Researching this potential resolution now:
http://www.sqlservercentral.com/Forums/Topic1300021-2799-2.aspx#bm1395349
February 15, 2013 at 9:01 am
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply