Posted by MVChauhan@googlemail.com on 06/19/06 16:29

In SAC I have enabled Local and Remote Connection and also SQL Browser
service is running and is also Active.

Mits

Erland Sommarskog wrote:

> 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: group by
• Prev in forum: Re: Connecting Sql Server 2005 from ASP?
• Thread view: Re: Connecting Sql Server 2005 from ASP?

[Reply to this message]