Prev: BCP Import
Next: Unexpected “Long running transaction” performance counter behaviou
From: seeker on 20 Apr 2010 13:01
I am apart of the builtin\administrators group which has a server role as
dbcreator. I attempt to create a dbase and get the following:

CREATE DATABASE failed. Some file names listed could not be created. Check
related errors. CREATE FILE encountered operating system error 5(Access is
denied.) while attempting to open or create the physical file
'D:\BTCSystem\Data\Heal.mdf'

Thanks.


From: John Bell on 20 Apr 2010 13:35
On Tue, 20 Apr 2010 10:01:10 -0700, seeker
<seeker(a)discussions.microsoft.com> wrote:

>I am apart of the builtin\administrators group which has a server role as
>dbcreator. I attempt to create a dbase and get the following:
>
>CREATE DATABASE failed. Some file names listed could not be created. Check
>related errors. CREATE FILE encountered operating system error 5(Access is
>denied.) while attempting to open or create the physical file
>'D:\BTCSystem\Data\Heal.mdf'
>
>Thanks.
>

Hi

This is a permission issue when creating the file. With vista eve n as
an administrator you may not have permissions, you could use run as
administrator to gain higher permissions, but checking the
permissions/ACLs and granting the correct ones for the directory would
be the be a more permanent solution.

John

From: seeker on 20 Apr 2010 14:41
Thanks for the help. Where do I go to set the permissions/ACLS. SQL Server
is on a win03 box and client is xp pro.

Thanks.

"John Bell" wrote:

> On Tue, 20 Apr 2010 10:01:10 -0700, seeker
> <seeker(a)discussions.microsoft.com> wrote:
>
> >I am apart of the builtin\administrators group which has a server role as
> >dbcreator. I attempt to create a dbase and get the following:
> >
> >CREATE DATABASE failed. Some file names listed could not be created. Check
> >related errors. CREATE FILE encountered operating system error 5(Access is
> >denied.) while attempting to open or create the physical file
> >'D:\BTCSystem\Data\Heal.mdf'
> >
> >Thanks.
> >
>
> Hi
>
> This is a permission issue when creating the file. With vista eve n as
> an administrator you may not have permissions, you could use run as
> administrator to gain higher permissions, but checking the
> permissions/ACLs and granting the correct ones for the directory would
> be the be a more permanent solution.
>
> John
>
> .
>
From: Erland Sommarskog on 20 Apr 2010 17:42
seeker (seeker(a)discussions.microsoft.com) writes:
> Thanks for the help. Where do I go to set the permissions/ACLS. SQL
> Server is on a win03 box and client is xp pro.

Right-click the directory D:\BTCSystem\Data\ in Explorer, and select the
Security tab. I would suspect that you need to grant access to the service
account for SQL Server.

That is, this is an issue about permissions in Windows, not permissions
in SQL Server.


--
Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

 | 
Pages: 1
Prev: BCP Import
Next: Unexpected “Long running transaction” performance counter behaviou