MSSQLWIKI

Karthick P.K on SQL Server

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.

About these ads

2 Responses to “System stored procedures like sp_addsrvrolemember or sp_addserver may fail because of McAfee Host Intrusion Prevention”

  1. […] System stored procedures like sp_addsrvrolemember or sp_addserver may fail because of McAfee Host In… […]

  2. 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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
Follow

Get every new post delivered to your Inbox.

Join 2,088 other followers

%d bloggers like this: