"John Yung" <johny@sac.com> wrote in message
news:OtwVPId9FHA.2176@TK2MSFTNGP14.phx.gbl...
> Hi,
>
> I installed SQL Server 2005 Express on one of my development machine, I
> had
> since then having problem connecting to a SQL Server 2000 (On a cluster)
> database. The problem persist even after I remove SQL Sever 2005 Express.
> The following is the error message:
>
> SAC.EDS.CorpAction.WithholdingTax.UnitTesting.WithholdingTaxOverrideRecordCr
> eate :
> System.Data.SqlClient.SqlException :
> 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: SQL Network Interfaces, error: 26 - Error Locating
> Server/Instance Specified)
>
> I do not experience the same problem when connecting from a machine
> without
> SQL Sever 2005 Express installed. I don't know why ADO.NET 2.0 thinks I am
> trying to connect to a SQL Server 2005 database.
>
> Please advice!
>
> Thanks,
>
> John Yung
>
>

"Rick Byham [MS]" <rickbyh@online.microsoft.com> wrote in message
news:egE7pfd9FHA.444@TK2MSFTNGP11.phx.gbl...
> Some questions: Is the "developement machine" the same computer as the
"SQL
> Server 2000 (On a cluster)"? I know that's not likely but if so, your
> problem may be related to SQL Server Browser.
> Also regarding SQL Server Browser service, is the cluster a named instance
> and what service pack is the SQL Server 2000 running?
> --
> Rick Byham
> MCDBA, MCSE, MCSA
> Lead Technical Writer,
> Microsoft, SQL Server Books Online
> This posting is provided "as is" with
> no warranties, and confers no rights.
>
> "John Yung" <johny@sac.com> wrote in message
> news:OtwVPId9FHA.2176@TK2MSFTNGP14.phx.gbl...
> > Hi,
> >
> > I installed SQL Server 2005 Express on one of my development machine, I
> > had
> > since then having problem connecting to a SQL Server 2000 (On a cluster)
> > database. The problem persist even after I remove SQL Sever 2005
Express.
> > The following is the error message:
> >
> >
SAC.EDS.CorpAction.WithholdingTax.UnitTesting.WithholdingTaxOverrideRecordCr
> > eate :
> > System.Data.SqlClient.SqlException :
> > 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: SQL Network Interfaces, error: 26 - Error Locating
> > Server/Instance Specified)
> >
> > I do not experience the same problem when connecting from a machine
> > without
> > SQL Sever 2005 Express installed. I don't know why ADO.NET 2.0 thinks I
am
> > trying to connect to a SQL Server 2005 database.
> >
> > Please advice!
> >
> > Thanks,
> >
> > John Yung
> >
> >
>
>