Date: 01/19/06 (SQL Server)    Keywords: database, asp, sql, web, microsoft

Okay, here's one for you. Not sure whether I should be posting here or in csharp; figured I'd try here first.

Trying to set up a SqlConnection in C#.NET (2005 Express Edition). When I test the connection, I get the following error:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings, SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

All well and good... except the machine to which I'm trying to connect is running SQL Server 2000, not 2005.

There is no connection string as of yet-- it's simply trying to locate the database and access the data (which, I should add, I can do just fine with Enterprise Manager, Query Analyzer, etc.). All I have right now is an "Add Connection" dialog box that has the DSP (Microsoft Sql Server Database File (SqlClient)) and the physical path to the database file (\\edison\c$\Program Files\Microsoft SQL Server\MSSQL\Data\Hospital Rates_Data.MDF). I hit "test connection," and up comes the error.

I am aware of this article at support.microsoft.com. SQL Server 2000 was installed on this machine at least a year before 2005 was released, so that's not the problem (at least, not as they explain it here).Still, I attempted the workaround, and the user they specify does not exist, so I assume that 2005 was never installed on that machine. I've found no help through a websearch; is there no one that doesn't ask questions specifically related to ASP.NET? Sheesh.

If anyone has any ideas, I'd be grateful. Thanks.

Source: http://community.livejournal.com/sqlserver/41154.html