Tag Archives: SQL Server

Using SPN tool to bypass SQL UDL Connection Test Cannot generate SSPI context error.

If the UDL connection refused and prompt an error as shown below We have to register SQL with the account name: “<domain>\user” with the help of SPN (Service Principal Name) tool. The SPN is a unique idendifier for each service … Continue reading

Posted in General | Tagged , , , | Leave a comment

How do I… Configure transactional replication between two SQL Server or in two instance ?

This gallery contains 18 photos.

Replication types: Snapshot Transactional Peer-to-peer replication Merge Snapshot replication is the simplest type of replication. With this kind of replication, all replicated data (replica) will be copied from the Publisher database to the Subscriber’s/Subscribers’ database(s) on a periodic basis. Snapshot … Continue reading

More Galleries | Tagged , | Leave a comment