Date: 02/07/08 (C Sharp)    Keywords: browser, database, asp, sql, web, google

This is both a SQL Server 2005 and a C# question, so I'm posting it in the community that probably isn't as sick of me asking questions yet...

I've googled this extensively for the past two hours. All of the pages I'm coming up with either (a) have something to do with ASP, (b) have something to do with surface area configuration, and/or (c) have something to do with SQL Express. None of these is the case with my problem.

I'm trying to create a data source in a C# project. When I test connection (or just try to hit OK), 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.

I am using SQL Server 2005 Standard Edition. Both the SQL Server engine and the database are on my computer, though they are on different drives. I can connect to the database with SQL Server Management Studio (I've been building it all morning in Management Studio). Despite it not being my problem, I have checked Surface Area Configuration, and "Local and remote connections" is checked. I have stopped and started SQL Server Browser, as I have also been advised to do by some pages, with no effect. This is a Windows Application, not a Web Application, and there is no ASP involved.

Anyone have any ideas of what might be causing this problem other than remote connections? Thanks.

Source: http://community.livejournal.com/csharp/92288.html