Hello

Right now I am using sql 2000 standard & sql 2005 standard for our website.

I am trying to use SQL Server 2008 Express with Advanced Services x64 for my website. The web server is in the DMZ and the Sql server is in the trusted.

I have used the SQL Server Configuration Manager and server properties to configure remote connection. I can connect remotely with Management Studio. When I try to connect though a web page I get an error .

The Error I am getting is

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: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.)

I have since installed SQL Svr Web Ed 2008 tria land I am able to connect from Management Studio and my website.

What am I missing with SQL Express?

TIA

Michael