Adding windows account to SQL server

  • Hi all - I am currently trying to setup replication across domains using seperate Publisher, a distributor that is SQL clustered and a Subscriber that is in the same domain as the distributor.

    At a basic level I am haivng problems adding a Windows account to the Clustered Server and getting the following error when trying to add an account I have placed in the local users for the clustered instance.

    Msg 15401, Level 16, State 1, Line 1

    Windows NT user or group 'NIHR-DB1-SQL\SNAPSHOT_AGENT' not found. Check the name again.

    Is this something specific to adding local accounts to a cluster? I have also been reading about potential case sensitive issues but as of yet have not found what this could be.

    Thanks

  • Not sure if this applies, but I think when I set up replication across domains, I used a sql account in both domains with the same password, not Windows accounts.

  • If thats the case, what account did you use to access your snapshot share folder?

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply