We might get Incorrect syntax near while applying the snapshot or stored procedure like sp_addsrvrolemember or sp_addserver might fails when we have Host Intrusion Prevention antivirus.
Last week two DBA’s came to me with two different errors after breaking their head for hours….
Error 1:
When i Run “EXEC sp_addsrvrolemember ‘VC’, ‘sysadmin’” I get
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData (CheckforData()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.
Connection Broken
Error 2:
I get Access Violation when i Install SQL Server 2008 and here is error in errolog
* Exception Address = 7814500A Module(MSVCR80+0001500A)
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred writing address 43D3FFFC
* Input Buffer 428 bytes –
declare @ServerName nvarchar(255) if not exists (select * fro
* m sysservers) begin select @ServerName = Convert(nvarchar(255), SERVERPR
* OPERTY(N’ServerName’)) execute sys.sp_addserver @ServerName, local end
* declare @ServerName nvarchar(255) if not exists (select * fro
* m sysservers) begin select @ServerName = Convert(nvarchar(255), SERVERPR
* OPERTY(N’ServerName’)) execute sys.sp_addserver @ServerName, local
Error is raised while executing sp_addsrvrolemember or sp_addserver or while applying the initial snapshot for database replication. I collected memory dump from both the systems and interestingly there was same 3rd party Dll’s in SQL Server address space of both systems. Its McAfee Host Intrusion Prevention. Disabled this and things started working.
https://kc.mcafee.com/corporate/index?page=content&id=KB65845
Thank you,
Karthick P.K |My Facebook Page |My Site| Blog space| Twitter
Disclaimer:
The views expressed on this website/blog are mine alone and do not reflect the views of my company. All postings on this blog are provided “AS IS” with no warranties, and confers no rights.
MSSQLWIKI 