Error connecting to a SQL Server 2000

[Ann Marinas]

Hi there,

I am currently developing an ASP.NET program that connects to a SQL Server
2000 database. I also have SQL Server 2005 Express installed on the same
local machine.

Prior to installing SQL Server 2005, my apps were working and is connecting
flawlessly to a database on the SQL Server 2000. Now, whenever I connect to
the same database with the 2005 version installed, I keep on getting this
error:

---------------------------------------
System.Data.Sql Client.SqlExcep tion: 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: Named Pipes Provider, error: 40 - Could
not open a connection to SQL Server) at
System.Data.Sql Client.SqlInter nalConnection.O nError(SqlExcep tion exception,
Boolean breakConnection ) at
System.Data.Sql Client.TdsParse r.ThrowExceptio nAndWarning(Tds ParserStateObje ct
stateObj) at System.Data.Sql Client.TdsParse r.Connect(Boole an&
useFailoverPart ner, Boolean& failoverDemandD one, String host, String
failoverPartner , String protocol, SqlInternalConn ectionTds connHandler, Int64
timerExpire, Boolean encrypt, Boolean trustServerCert , Boolean
integratedSecur ity, SqlConnection owningObject, Boolean aliasLookup) at
System.Data.Sql Client.SqlInter nalConnectionTd s.OpenLoginEnli st(SqlConnectio n
owningObject, SqlConnectionSt ring connectionOptio ns, String newPassword,
Boolean redirectedUserI nstance) at
System.Data.Sql Client.SqlInter nalConnectionTd s..ctor(DbConne ctionPoolIdenti ty
identity, SqlConnectionSt ring connectionOptio ns, Object providerInfo, String
newPassword, SqlConnection owningObject, Boolean redirectedUserI nstance) at
System.Data.Sql Client.SqlConne ctionFactory.Cr eateConnection( DbConnectionOpt ions
options, Object poolGroupProvid erInfo, DbConnectionPoo l pool, DbConnection
owningConnectio n) at
System.Data.Pro viderBase.DbCon nectionFactory. CreatePooledCon nection(DbConne ction
owningConnectio n, DbConnectionPoo l pool, DbConnectionOpt ions options) at
System.Data.Pro viderBase.DbCon nectionPool.Cre ateObject(DbCon nection
owningObject) at
System.Data.Pro viderBase.DbCon nectionPool.Use rCreateRequest( DbConnection
owningObject) at
System.Data.Pro viderBase.DbCon nectionPool.Get Connection(DbCo nnection
owningObject) at
System.Data.Pro viderBase.DbCon nectionFactory. GetConnection(D bConnection
owningConnectio n) at
System.Data.Pro viderBase.DbCon nectionClosed.O penConnection(D bConnection
outerConnection , DbConnectionFac tory connectionFacto ry) at
System.Data.Sql Client.SqlConne ction.Open() at
SovWebApp.Libra ry.DataSourceAc cess.GetSingleD ata(String query, Boolean
isStoredProc, DataSourceField s[] parameters) in C:\_Documents\W ork
Files\Conservat ion\SovWebIntra netApps\SovWebL ibrary\DataSour ceAccess.cs:lin e
72 at SovWebApp.Conse rvation.Logic.C onservationLogi c.GetUserID(Str ing
userName) in C:\_Documents\W ork
Files\Conservat ion\SovWebIntra netApps\Conserv ation\BusinessL ayer\Conservati onLogic.cs:line
50 at SovWebApp.Conse rvation.Logic.C onservationLogi c.ValidateUserI D(String
userName, Int32& userID) in C:\_Documents\W ork
Files\Conservat ion\SovWebIntra netApps\Conserv ation\BusinessL ayer\Conservati onLogic.cs:line
61 at SovWebApp.Conse rvation.UI.Cons ervation.Page_L oad(Object sender,
EventArgs e) in c:\_documents\w ork
files\conservat ion\sovwebintra netapps\conserv ation\conservat ionform.aspx.cs :line 86
-------------------------------

I have tried enabling my named pipes as well as my tcp/ip for both SQL
Servers, and I still keep on getting the same error.

I have tried checking my connection string and it seems it is correct.
<add key="DBConnecti on" value="Integrat ed Security=SSPI;P ersist Security
Info=False;Init ial Catalog=Conserv ation;Data Source=(local)"/>
My Sql Server 2005's named instance is: (local)\SQLExpr ess
Please help! I really don't know what to do....
Thank you so much!

[Cor Ligthert [MVP]]

Ann,

Did you had a beta installed before installing SQLExpress again?

Cor

[Ann Marinas]

Hi Cor,

Thank you for your reply. Really do appreciate it.

As for your question, I had a newly formatted drive when I installed SQL
Express.

Regards,
Ann
"Cor Ligthert [MVP]" wrote:

Ann,

Did you had a beta installed before installing SQLExpress again?

Cor

[Brad Roberts]

With similar problems, it has often been resolved when I create an "alias" to
the SQL server in the SQL Client Software.

Hope this helps..