I'm trying to learn how to use microsoft sync framework using the following example, but am having a problem with a logon trigger blocking something. If I disable the trigger it will work, but that really isn't an option. Normally, if something
is blocked it is placed in a blockedLog table with the name of the user and application. If we need to allow access then we can put this information in the BlockedExceptions table to allow it through. Initially, the .Net SqlClient Data Provider
gets blocked. After adding it to the accepts table, I still get a blocking error due to the trigger, but I can't determine what is actually being blocked. The table never fills with any information about what gets blocked after fixing the initial
.Net SqlClient Data Provider error and I have not been able to figure out anything using the profiler or activity monitor.
Sync Example in question:http://code.msdn.microsoft.com/Release/ProjectReleases.aspx?ProjectName=sync&ReleaseId=3422
CREATE TRIGGER [BlockLogins]
ON ALL SERVER WITH EXECUTE AS 'DBTrigger'
DECLARE @Allow bit
SET @Allow = 'TRUE'
IF (SELECT COUNT(*) FROM DB.dbo.Programs WHERE AppTitle= APP_NAME()) = 0
-- ** Other allowed apps and users are in BlockedExceptions **
-- If it is a non-application that any user is allowed to run then let it through.
View Complete Post