Re: SQL Server 2005--Access is Denied
saw (swexpress(remove)@hotmail.com) writes:
When trying to create a database, I am getting an error message within the
createdb.log saying the following:
Create File encountered an operating system error (Access is denied) while
attempting to open or create the physcial file...
Please let me know what steps do I need to trouble-shoot or resolve this
issue.
It seems that the service account for SQL Server does not have write
access for the path you specified for one of the files.
So the way to troubleshoot this would be to check:
1) Which is your service accounts.
2) The permissions on the directories you specified.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
Relevant Pages
- Re: Create DB for filestream failes
... system error 5(failed to retrieve text for this error. ... Use a regular user account for the service account and you should be fine. ... Use SQL Server Configuration Manager to change this. ... Books Online for SQL Server 2005 at ...
(microsoft.public.sqlserver.programming) - Re: SQL Server 2005 cant attach database on Windows Vista
... Sometimes ignorance is a good thing! ... One thing is missing from your list: what is the service account for ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
(microsoft.public.sqlserver.tools) - Re: Login failed for user (null). Reason: Not associated with a trusted SQL Server connection.
... Now that the sql server has been moved to a separate box I am ... I would guess that the service account for IIS has to be a domain account. ... Books Online for SQL Server 2005 at ...
(comp.databases.ms-sqlserver) - Re: URGENT - Link server 2005 to 2000
... But it can also be more complicated if the service account for the SQL 2005 ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
(comp.databases.ms-sqlserver) - RE: Upgrade from 2005 to 2008: Invalid Credentials
... it seems that this issue was related to NETWORK SERVICE account for SSIS service could not be validated on DC. ... Please first go to your Services pane, double click your SQL Server Integration Services, switch to the Log On tab to check if the service account is NETWORK SERVICE account. ... Install SQL Server 2008 from the Command Prompt ... Microsoft Online Community Support ...
(microsoft.public.sqlserver.setup) |
|
