I've been trying to fix this for a week now.
I tried to migrate my asp.net 1.1 web apps to 2.0. No code changes, complied
fine. the 2.0 version even worked on my dev machine (windows xp)
But when I run it on my production server (windows 2003) I get this error.
Server Error in '/' Application.
--------------------------------------------------------------------------------
Instance failure.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.
Exception Details: System.InvalidO perationExcepti on: Instance failure.
[InvalidOperatio nException: Instance failure.]
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) +684031
System.Data.Sql Client.SqlInter nalConnectionTd s.OpenLoginEnli st(SqlConnectio n
owningObject, SqlConnectionSt ring connectionOptio ns, String newPassword,
Boolean redirectedUserI nstance) +628
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)
+170
System.Data.Sql Client.SqlConne ctionFactory.Cr eateConnection( DbConnectionOpt ions
options, Object poolGroupProvid erInfo, DbConnectionPoo l pool, DbConnection
owningConnectio n) +359
System.Data.Pro viderBase.DbCon nectionFactory. CreatePooledCon nection(DbConne ction
owningConnectio n, DbConnectionPoo l pool, DbConnectionOpt ions options) +28
System.Data.Pro viderBase.DbCon nectionPool.Cre ateObject(DbCon nection
owningObject) +424
System.Data.Pro viderBase.DbCon nectionPool.Use rCreateRequest( DbConnection
owningObject) +66
System.Data.Pro viderBase.DbCon nectionPool.Get Connection(DbCo nnection
owningObject) +496
System.Data.Pro viderBase.DbCon nectionFactory. GetConnection(D bConnection
owningConnectio n) +82
System.Data.Pro viderBase.DbCon nectionClosed.O penConnection(D bConnection
outerConnection , DbConnectionFac tory connectionFacto ry) +105
System.Data.Sql Client.SqlConne ction.Open() +111
I tried to search on google, found this but no answer
http://answers.google.com/answers/threadview?id=599326
I know my connectstring is correct. I tried both sql server 2000 and 2005.
same exact error. the sql server serivce runs on the nt authority/network
service account.
this makes no sense at all
please help,
Howard