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 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy