Hi,
We have a clustered instance for our distributor in a transaction replication topology. At this distributor we also have our snapshot folder. We created a file share resource for this snapshot folder in MS Clustering in the virtual group as the sql instance. In the distributor setup we then provided the "virtual group\sharename" as the location of the snapshot folder thinking that in the event of a failure, the virtual name would be resolved.
My first question is, is this the correct way of setting the snapshot folder in a clustered instance
When i failed over the virtual group and tried to connect to this share which was previously connected whist running on the other node, it fails. Our Admins think this is related to Kerberos authentication. Will this likely to cause issues with replication
Thanks,
Priyanga
Snapshot location on a clustered server and Kerberos authentication
Hot Topic
- Error when trying to create "datasources"
- Script component as Destination - HasSideEffects?
- Multilingual report ?
- SQL Express Family CTP Now Available
- OleDB Connection Class in Custom Task?
- Create New Table
- memory could not be read
- HELP!!:about the MS association rules
- Error processing events
- IDENTITY fields
SQL Server
- JOIN problem with time involved
- Could not obtain a DataReader object from the specified data flow component.
- How automatically process a Cube periodically
- I can't access cubes from excel
- PackageID in Logging Provider
- Maximum Conversation timer interval
- Nested CASE statements Problem
- Trim Strings
- Custom Code in Web Report Builder
- function to display the numbers 1-12 in detail of table
Snapshot location on a clustered server and Kerberos authentication
John Bailo
Using file share resource should work. Maybe you can check the following items:
1) Could you access the file share resource with the path you provide as the snapshot folder location, before and after failover Use the Windows account that snapshot agent runs under.
2) I'm not sure how exactly you specify snapshot folder. The path I use is like \\virtualserver\sharename. The network name (virtualserver) and its IP address are the resources the file share resource depends on and are in the same virtual group.
3) I believe you may have configured the permission to the file share resource and just want to make sure. The default permission is read-only. But snapshot agent requires read/write permission to the folder.
Thanks,
Peng
Ahmed Abd-ElHaffiez
We got this issue resolved.
It was a matter of adding the virtual server name to the host file of the servers initiating the connection.
Thanks,
Priyanga