December 28, 2005 at 12:05 pm
A snapshot agent has failed, the associated error message being:
The process could not create file \\
After an initial set-up of replication the 'UNC-file' will be something like '\\
Help me .... please!
December 28, 2005 at 12:21 pm
A little more info would help (what are the service accounts, etc.), but here is a thought:
Does the account that SQL Agent runs on have access to that server? Since there's a UNC path to an administrative share, the server that's trying to publish data needs to have administrative rights on the server where the ReplData folder sits.
If not that, then maybe a typo in the path?
December 28, 2005 at 3:09 pm
When the replication are formed, the machine was as PC of office. and the shapshot agent worked very well.
Later the PC was promoted as server and it did not work already the replication
it began to mark this error.
The MSSQLServer and SQLServerAgent , they have both LocalSystem
The folder \\\REPLDATA to have rights on the server, full access for Everyone
December 28, 2005 at 3:55 pm
Using LocalSystem won't work in a distributed environment. In order for the services on the different servers to "see" each other, you'll need a method of authenticating across server, i.e. Windows Authentication. And the SQL Server agent service running on the Subscriber and/or Distributor (depending on how you are set up) will need explicit permissions granted on the folder where the ReplData files are kept. The problem comes in because of the C$ usage; you can alternatively specify a different folder, and share it out with rights that allow the SQL Server Agent account to see the files (The Publisher will need write permissions to the share, and the Distributor and Subscribers need read permissions to the share).
You said that replication had been working when the setup was done on a PC. Was the Publisher, Distributor, and Subscriber all on the same machine? Or on different machines? And now that the PC is a server, where are the Distributor and Subscriber? And are they also using LocalSystem?
May 27, 2008 at 2:25 am
First set snapshot folder as shared folder and grant access to it
Then right click on snapshot folder -> properties - > sharing - > Permissions: add user same as sqlAgent and grant privilegies
May 27, 2008 at 9:16 am
piojilla (12/28/2005)
A snapshot agent has failed, the associated error message being:The process could not create file \\{UNC-file}
After an initial set-up of replication the 'UNC-file' will be something like '\\{server-name} \ c$ \ mssql \ ReplData \ unc \ {server}_{database}_{snapshot name}'.
Help me .... please!
Do you really have spaces between all of the '\'s ? If so, I don't think that you should do that.
(ps. avoid using the angle brackets in your posts: <, > , the tag-translator tends to eat them.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply