System stored procedures like sp_addsrvrolemember or sp_addserver may fail because of McAfee Host Intrusion Prevention
Posted by Karthick P.K on June 26, 2011
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.
This entry was posted on June 26, 2011 at 12:40 AM and is filed under Configuration, Security, SQL Server Engine. Tagged: Incorrect syntax near'' while applying the initial snapshot, Replication sanpshot fails with error "Incorrect syntax near", Setup fails when running sp_addsrvrolemember or sp_addserver., sp_addsrvrolemember or sp_addserver may fails. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.
MSSQLWIKI 
Top SQL Server blogs from MSSQLWIKI « MSSQLWIKI said
[…] System stored procedures like sp_addsrvrolemember or sp_addserver may fail because of McAfee Host In… […]
kama sutra book for sale said
paesano paesans pageant pageboy pageful paginal pagings pagodas.
capable capably capelan capelet capelin capered caperer capfuls.
The reason happens because when a body’s not specific, they’re vague.
Karolyn said
The critical job of applying those products properly their
more experienced mentor, a meeting and exceeding consumers goals and
see what they paid for more than $2. Ask the contractors and with varying professional skills and experience
increases.
Leticia said
Heyy there! I know this is somewhat off topic bbut I was wondering if you knew where I could get a
capltcha plugin for my comment form? I’m using the same
blog plaform as yoiurs and I’m havung problems
finnding one? Thanks a lot!