Posted by Erland Sommarskog on 06/19/06 13:29

MVChauhan@googlemail.com (MVChauhan@googlemail.com) writes:
> I am sorry if i confued you, you are right WebServer and DB Server are
> 2 different machines. I have replaced 127.0.0.1 with the IP of DB
> server and now the error is
>
> TCP Provider: An existing connection was forcibly closed by the remote
> host.
>
> Configuration of Servers are as follows
>
> Webserver
> OS Windows 2003
>
> Database Server
> OS Windows 2003
> DB SQL Server 2005 with Service Pack1


Have you configured SQL 2005 to accept remote connections? The Developer
and Express Editions of SQL 2005 accepts by default local connection only.

Use the Surface Area Configuration tool to check and change this.

Also make sure that the SQL Server Browser service is running.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Connecting Sql Server 2005 from ASP?
• Prev in forum: Re: knowing which jobs/dts/SSIS affect which tables
• Thread view: Re: Connecting Sql Server 2005 from ASP?

[Reply to this message]