SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Attempt to Read or Write Protected Memory		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

ksr39
Posting Yak Master

India
171 Posts
Posted - 05/17/2012 :  14:50:59  Show Profile  Reply with Quote
Hi Experts,

Please help me in solving this issue, as when i am trying to connect my SQL Server 2008 to an instance i got this error message.

"Attemp to Read or Write Protected Memory. This is an often indication that the other memory is corrupt"

Please let me know if any one of you faced this problem and how to overcome this.

Thank you All in Advance.

tkizer
Almighty SQL Goddess

USA
35007 Posts
Posted - 05/17/2012 :  15:14:50  Show Profile  Visit tkizer's Homepage  Reply with Quote
Probably just need to reboot the client.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

ksr39
Posting Yak Master

India
171 Posts
Posted - 05/17/2012 :  15:40:09  Show Profile  Reply with Quote
Thank you Tara for the solution but it is a Prod server, Is there any other solution for this problem.
Go to Top of Page

robvolk
Most Valuable Yak

USA
15559 Posts
Posted - 05/17/2012 :  16:12:12  Show Profile  Visit robvolk's Homepage  Reply with Quote
Check the Windows System event log for possible memory errors. Also check the SQL Server Error log for similar messages. You may have bad memory modules that need replacing. If the server has diagnostic software you should run it and check for any warning messages.

If you don't see any such problems and you're still encountering that error, you may have to reboot the SQL Server anyway.
Go to Top of Page

ksr39
Posting Yak Master

India
171 Posts
Posted - 05/17/2012 :  17:06:53  Show Profile  Reply with Quote
Yeah i am still getting the error and not able to ping the server. I think i need to go for rebooting the server by taking the downtime from the apps owner.

Thank you all for the valuable suggestions.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000