Tag: snapshot

The server principal “XYZ\USER” is not able to access the database “YourDBName” under the current security context

My Development team contacted me and said they are not able to access database  “The server principal “XYZ\USER” is not able to access the database “YourDBName” under the current security context” when I looked into server server I found – Login was there and access was granted. When I looked into database I found user… Read More The server principal “XYZ\USER” is not able to access the database “YourDBName” under the current security context

learnsqlteamLeave a comment

Replication – Snapshot is not getting generated

Replication issues and resolutions Today I have encountered very strange issue – Scenario – Snapshot is not getting generated for newly added articles or Error when setting up Transactional Replication via SQL scripts. Msg  14100, Level 16, State 1, Procedure sp_MSrepl_addsubscription, Line 533 Specify all articles when subscribing to a publication using concurrent snapshot processing. Step performed to… Read More Replication – Snapshot is not getting generated

learnsqlteamLeave a comment