I encountered a problem trying to "Add Workgroup" when trying to setup SQL Replication from the publisher to the Subscriber that I thought was worth sharing. Neither machine were added to a domain, both were using LOCAL user accounts on Windows Server 2008 R2 SP1. It took me a while to solve it and the solution was not obvious, so I thought it worth sharing.
The Computer names were as follows:
- Publisher = RRSQLPUB
- Subscriber = RANKINR-SUBSCRIBER
On both machines, I had created a user account called "VAULTREPL", with the same password.
When I clicked "Add Workgroup" I entered all the details correctly, but I kept getting this message.
"Windows NT user or group 'computer\sharedfolder' not found. Check the name again"
First, I realised that in the "Remote Replication Credentials", you must enter the user account of the Subscriber, not the Publisher. So, in the above error message 'RRSQLPUB\VAULTREPL" was replaced with "RANKINR-SUBSCRIBER". Also, both the impersonating user (AutodeskVault by default) and the "SQL Server (AUTODESKVAULT)" service user (often "Network Service") need full control on this folder.
But I kept getting the same message, different computer name.
I found that renaming the server to contain less than 15 Characters resolved the issue! This meant:-
- Uninstalling SQL (2008 R2 RTM) on the Subscriber,
- rename the machine,
- reinstall SQL (2008 R2 RTM)
As I write this, after I had resolved it, I found this article from Microsoft....http://msdn.microsoft.com/en-us/library/aa952588.aspx...go figure. As a best practice, I'd recommend avoid using computer names exceeding 15 characters.
Comment on this blog if you experience a similar issue, but found a different workaround...