I have two SQL Servers:
- SQL1 (workgroup edition, on domain abc)
-SQL2 (sql server 2008 evaluation edition on domain cba)
I have created a publication of single table on SQL1 and it was successful. I have enabled distribution on SQL1 as well.
Then, I tried to create a snapshot and it failed with a message: Script failed for table xxx
I am new at SQL server and replications. Also, I am a bit confused what credentials I need to put for snapshot agent.
Please advise .
View Complete Post