June 10, 2005 at 11:07 am
Hello,
I am trying to set up some databases for replication and am facing the following issues :
1) I am unable to create any new databases specifically on the c drive of the server
I get the error message :
Error 5123:Create file encountered operating system error 5(access denied) while attemptiong to open or create the physical file. CREATE DATABASE failed. Some file names listed could not be created.
- The following error message is recorded in the SQL Log :
FCB::CreateFile() failed with error 5 for file C:\Program Files\Microsoft SQL Server\MSSQL\Data\test_Data.MDF.
2) I am unable to set up replication remotely from my desktop but am able to do so from the server itself
I am a domain admin with full control on all shares and sa priveleges.
Has anyone come across this problem ?
Thanks
June 10, 2005 at 11:47 am
Check the permissions for the account under which SQL Server runs. It's that account which will need permissions to create the database files. You should also check the sql agent account permissions. I've seen problems with replication when the agent account didn't have the correect permissions.
June 10, 2005 at 1:27 pm
Yes, that helped.
Thank you
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply