Re: Error while generating Snapshot

If you're replicating to the same box this is fine. If you're going to
another box then it'll need to be a domain account with the correct
priviliges on your pub/dist and the subscriber as long as you are
impersonating it in the sql server agent and not using a proxy (SQL Server
2000 style). However I don't think this is the issue here as the problem is
in the creation of the snapshot folder. My last hope is that the disk is
full and no account can create a folder in the snapshot share - can you just
create a folder there as a test. Also change the sql server account to be a
domain one which is a local administrator on the publisher just to test this
although I don't see that this should make any difference. Am hoping it's a
simple space issue!
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com




.

Relevant Pages

  • Re: Problems changing the password for the service account in SQL
    ... Adding the domain account which runs SQL Server into SQL Server doesn't ... Server if it is running under the domain account. ... Admin-SQL, Logon Exec - exception from ...
    (microsoft.public.sqlserver.security)
  • Re: Problems changing the password for the service account in SQL
    ... It is because there is BULTIN\Administrstors Login that alllow access to ... You have a domaim account group that SQL Server ... this domain account in SQL Server ...
    (microsoft.public.sqlserver.security)
  • Re: Get "credentials not valid" message installing SQL2008 Failver
    ... The user account (domain account) has to be pre-created. ... The network name gets created during the install process. ... Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.setup)
  • Re: Connections errors
    ... Jasper Smith (SQL Server MVP) ... accounts and not the NT domain account. ... >> been observing connection errors that we can trace back ...
    (microsoft.public.sqlserver.security)
  • SQL services failing on startup
    ... The services are set to autostart using a windows account. ... The account is restricted to logon only to computers ... for several months, the last two weekends, SQL Server has failed to startup ... The domain account was a member of the local admin group. ...
    (microsoft.public.sqlserver.server)
Loading