I created a test web site with VS2008 using Framework 2.0. Created a
database in SQL Server 2005 and am able to connect to it without any
problems. I then setup the database to be accessed using a public IP
address. Changed the connection string in my web site to use the public IP
along with the port, when I load the web site through VS2008 everything
works OK. When I try to upload to my web site I get this error message.

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 added the SQL Server and Browser to the firewall as well as the port. I
can connect to my database from a remote connection through SQL Server
Management Studio. I only get this when the site loads from my web site.

Any ideas?

Thanks In Advance,
Lou