connecting aspx to SQL Server 2000

Hello All,

I am just getting started on aspx, coming from an asp background.

I created the following connectionString in my web.config file:

<connectionStrings>

<addname="OuWebDB"

connectionString="server=OurServer;database=OurDatabase;uid=TheUser;pwd=ThePassword"

providerName="System.Data.SqlClient"

/>

</connectionStrings>

when I run this aspx file, from a machine, 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Help!!

thanks

Check outwww.connectionstrings.com for a proper connection string. Please search for these forums with your error message. I remember seeing previous posts with same question.

|||

Sorry,

I did some searching around, and I still have the following issue:

I can not telnet to port 1433 (even localhost on the SQL Server 2000 machine).

1. TCP/IP and Named Pipes are both 'enabled' within SQL Server Client Network Utility.

2. I read something about having to be at a certain SERVICE PACK to overcome this error, is that the case? If so, is it for SQL Server or Win2003?

Other Question: Should I just stick to ODBC connection strings, which have worked well in the past, for my asp applications?

thanks..

|||

I have found my problem, thanks... it is related to my service pack version