Cannot connect to microsoft sql server 08

Question

 whenever i start the server it just give me the error..

Cannot connect to local server 

the type initializer for 'system.data.sqlclient.sqlconnection' threw an exception (system.data)

attempted to read or write protected memory this is an indication that other memory is corrupt.

Answer 1

Try this!!

when you open ssms

go to the window tab ->Reset Window Layout

Regards

---

Addie

Answer 2

At least it's a local server (it would be harder to do this for a remote server).  Check out these resources:

#1) - Make sure SQL Server service is running:

http://blog.sqlauthority.com/2009/05/21/sql-server-fix-error-provider-named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-error/

#2) - Check ports, firewalls, etc.

http://blog.sqlauthority.com/2008/08/09/sql-server-fix-error-1326-cannot-connect-to-database-server-error-40-could-not-open-a-connection-to-sql-server/

---

Ryan Shuell

Answer 3

This could be an error in your app.config file, e.g. badly formed XML or unexpected elements. The error happens because the static fields inside SqlConnection read from app.config to determine trace detail level as described here: http://msdn.microsoft.com/en-us/library/ms254503.aspx

Here's is a thread about that may help also:

http://social.msdn.microsoft.com/Forums/en-US/wcf/thread/701e6845-3573-42e2-9f02-6b3387768f99/

---

John

http://knowledgy.org