Mirroring ASPState

Hello Does any one have any information on how to mirror the ASP.NET 2 ASPState database we have set the connection string to allow custom DB and failover partner but this is still not working.

Regards Matt.

Hi Matt,

Are you having problems with automatic failover not happening at all, or the ASP.NET connection does not get re-routed to the failover partner after auto-failover occurs?

Thanks,

Kaloian.

|||

Hi Kaloian,

The problem that we are having is that the ASP.NET connection does not get re-routed to the failover partner after auto-failover. This is the connection string that i am using.

<sessionState mode="SQLServer"

sqlConnectionString="data source=Test; Failover Partner=Test2; initial catalog=Credit; user id=State;password=password"

cookieless="AutoDetect"

timeout="61"

allowCustomSqlDatabase="true" />

The databses all failover fine but it seems that the ASP.NET connection is never looking for the failover partner it just errors giving a named pipes error. But they are enabled on both the primary and the failover partner.

Thanks Matt.

|||

I believe you are missing the Network parameter -->

Network=dbmssocn; for TCP/IP

so sqlConnectionString="data source=Test; Failover Partner=Test2; Network=dbmssocn; (etc)

Let us know if it works!

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/fd000cb1-9426-4ed9-8108-1907ddfd1c5f.htm

sql