<hummingbirdlj@gmail.com> wrote in message
news:44e6acf1-92c5-4bd9-94fe-462d62f0f0ed@d61g2000hsa.googlegroups.com...
> Thanks for the information to list the alternate server information.
> I see that it is set properly. I've found that a connection is
> automatically re-established to the same primary server, if the
> connection is lost. However, if I try the following, I still get the
> SQL30081 error:
> 1) connect to hadr primary database
> 2) execute a hadr switch roles
> 3) execute a query, which should result in a connection to the new
> primary
>
> Is there anything else I need to set-up in this case? I've set the
> client registry settings for the number of connection retry attempts
> and the interval. Thanks.