IP restriction Error in SQL Server 2005
-
I am getting this error Msg 1084, Level 15, State 1, Procedure LOGIN_IP_RESTRICTION, Line 2 'LOGON' is an invalid event type. while executing under code:- CREATE TRIGGER [LOGIN_IP_RESTRICTION] ON ALL SERVER FOR LOGON AS BEGIN DECLARE @host NVARCHAR(255); SET @host = EVENTDATA().value('(/EVENT_INSTANCE/ClientHost)[1]', 'nvarchar(max)'); IF(EXISTS(SELECT * FROM master.dbo.IP_RESTRICTION WHERE UserName = SYSTEM_USER)) BEGIN IF(NOT EXISTS(SELECT * FROM master.dbo.IP_RESTRICTION WHERE UserName = SYSTEM_USER AND ValidIP = @host)) BEGIN ROLLBACK; END END END; i am running it on mAster database and i am using SQL server 2005 standard edition. thanks in advance Aman
-
I am getting this error Msg 1084, Level 15, State 1, Procedure LOGIN_IP_RESTRICTION, Line 2 'LOGON' is an invalid event type. while executing under code:- CREATE TRIGGER [LOGIN_IP_RESTRICTION] ON ALL SERVER FOR LOGON AS BEGIN DECLARE @host NVARCHAR(255); SET @host = EVENTDATA().value('(/EVENT_INSTANCE/ClientHost)[1]', 'nvarchar(max)'); IF(EXISTS(SELECT * FROM master.dbo.IP_RESTRICTION WHERE UserName = SYSTEM_USER)) BEGIN IF(NOT EXISTS(SELECT * FROM master.dbo.IP_RESTRICTION WHERE UserName = SYSTEM_USER AND ValidIP = @host)) BEGIN ROLLBACK; END END END; i am running it on mAster database and i am using SQL server 2005 standard edition. thanks in advance Aman
-
Eddy Vluggen wrote:
Service Pack 2
Service Pack 3[^] ;P
Manas Bhardwaj Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
-
I am getting this error Msg 1084, Level 15, State 1, Procedure LOGIN_IP_RESTRICTION, Line 2 'LOGON' is an invalid event type. while executing under code:- CREATE TRIGGER [LOGIN_IP_RESTRICTION] ON ALL SERVER FOR LOGON AS BEGIN DECLARE @host NVARCHAR(255); SET @host = EVENTDATA().value('(/EVENT_INSTANCE/ClientHost)[1]', 'nvarchar(max)'); IF(EXISTS(SELECT * FROM master.dbo.IP_RESTRICTION WHERE UserName = SYSTEM_USER)) BEGIN IF(NOT EXISTS(SELECT * FROM master.dbo.IP_RESTRICTION WHERE UserName = SYSTEM_USER AND ValidIP = @host)) BEGIN ROLLBACK; END END END; i am running it on mAster database and i am using SQL server 2005 standard edition. thanks in advance Aman
Hi Aman, Try to read this article. It is full of information. http://technet.microsoft.com/en-us/library/bb326598.aspx[^] Regards, Kaushal Arora Please Mark as Answer if it Solved Your Problem.