This seems more of an ODBC issue than an Excel issue. So I think it depends not only on the SQL Server side, but also on the ODBC-driver that's used on the client side (XP, Vista, Windows 7).
If you can't find out in the documentation, this is typically a question to ask your Microsoft support. After all, they wrote that driver and it's their database. So if anybody knows, it's them.
Companies that have fail-over service surely have the right support contract with Microsoft to get this issue solved in a wink.
Can you tell us the solution once Microsoft told you? It might be interesting for some other members.
Kees
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 an error.And asking for Authentication.
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
Satish

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic