First off
//this failure may be caused by the fact that
under the default settings SQL Server does not allow remote connections.
//
is a message which ~may~ happen, but may not be the culprit.
Its like
"Your car is making a noise, it ~may~ be the brakes".
However, it could be the issue.
There is a "Surface Configuration Tool" under start / programs / Sql Server
2005 /
and there is a place to enable remote connections there.
If its already enabled, then you'll have to check and recheck your
connection string.
Find out about the surface configuration first, then report back..and you'll
get more concrete advice.
"Lou Civitella" <(E-Mail Removed)> wrote in message
news:B2E30907-B3A9-4CF5-9E2B-(E-Mail Removed)...
>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
|
Similar Threads
