Sunday, February 12, 2012

Cannot connect to local database - SQL Server 2005 Express

Hi,

Has anyone encountered this error when trying to connect to SQL Server 2005 Express?

TITLE: Connect to Database Engine

Cannot connect to STEVE\SQLEXPRESS.


ADDITIONAL INFORMATION:

The type initializer for 'System.Data.SqlClient.SqlConnection' threw an exception. (System.Data)

The type initializer for 'System.Data.SqlClient.SqlConnectionFactory' threw an exception. (System.Data)

The type initializer for 'System.Data.SqlClient.SqlPerformanceCounters' threw an exception. (System.Data)

Unable to find an entry point named 'CreateWellKnownSid' in DLL 'advapi32.dll'. (mscorlib)


BUTTONS:

OK

STEVE is my computer name - Windows 2000 SP4

I have .Net Framework 2.0 installed - as well as two previous versions - not beta - one of which I am using with VS Studio .NET Acaademic 2002 Version

I have multiple versions of 'advapi32.dll' on my machine - if I open the version in the system32 directory with notepad I can't find a reference to CreateWellKnownSid

if I open the version of 'advapi32.dll' in the system32\dllcache directory with notepad I can find a reference to CreateWellKnownSid

I'm at a loss. Not finding much on this in my searches. Thanks.

Steve

Sorry,

Forgot to mention. I'm trying to connect from 2005 Management Studio Express and not from code in VS. NET. Thanks.

Steve

|||I have the very same issue... somebody with an answer?

No comments:

Post a Comment