Excel Application Unable to Connect the High available (Mirroring) database

[satish0680]

Hi Folks,

Please help me out from below Issue.

We have developed an Excel application to pull data from Back-end Database SQL Server 2008.

The database is configured in High availability Mirroring, When fail over occurs the Database moving from One server DB to Another Server DB.

But my Excel application is not pointing to the Failover DB when the One DB fails.

We are using the below Connection string in the excel application:

"Data Source=Server A;Failover Partner=Server B; Initial Catalog=AdventureWorks; Integrated Security=True;"

When Server A is unavailable, it shows the below error.

PFA : Error.jpg

And again asking for Authentication

PFA : AuthReq.jpg

Here we need to Enter Credentials manually and then it is able to connect the desired database.

But it is not possible to spread credentials to end –user.

Can anyone please provide solution for this issue to automate the above scenario without manual intervention?

Thanks in Advance 