RE: SQL SERVER DATABASE CREATION ERROR'S

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Please note I gave the EVERYONE group full control and the db did not get
created if it was a permission issue that should have negated it shurely?

Also I used the network service account for the sql services and I gave this
account full access to the mount points as file permission access and it
still did not work.
--
General System Admin and IT manager


"Erland Sommarskog" wrote:

Ricus (Ricus@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
Thanks for the reply .I went as far as to give the EVERYONE group full
control .

And nothing.

It's definitely a permissions issue:

2009-09-01 11:12:33.40 spid53 CREATE FILE encountered operating
system error 5(error not found)


Error 5 is "Access is denied".

What service accounts do you use for SQL Server? If you use LocalSystem
or somesuch change to a domain user. Not that it should matter for a
mount point, but LocalSystem is bad practice anyway.

--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

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


.

Relevant Pages

  • Re: distribution clean up job fail
    ... The Administrator Account or whatever account the distribution agent is ... running under in sql 2005, or whatever account SQL Server agent is running ... permission on the share and underlying files and folders for this to work. ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)
  • RE: Run a ssis package on SQL Server 2005 Error
    ... I can run the SSIS package succesfully in BIDS under the same user as SQL ... The user is a domin user and it has full permission on the remote server, ... SQL Server 2005 and Agent are run under Domin\xxxxx, ...
    (microsoft.public.sqlserver.dts)
  • Re: version control for database settings in Workbench?
    ... control in past issues of SQL Server Professional. ... I do realize that source control or Transact-SQL code is ... >put scripts for changing server settings there. ...
    (microsoft.public.sqlserver.tools)
  • RE: Keeping User From Deleting Table Records
    ... a regular user, if you don't grant DELETE permission, he cannot delete. ... authentication and authenticate with Windows. ... Windows or is this SQL-assigned read permission done through SQL Server? ...
    (microsoft.public.sqlserver.security)
  • Re: User ASPNET in SQL Server 2000
    ... You need to disable anonymous access, enable Windows access, create group in Windows, assign permissions to that group in SQL, put ... > as the windows user then I want to logon to the SQL Server ... > now I want a permission to the SQL Server 2000 database ...
    (microsoft.public.dotnet.framework.aspnet.security)