Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Intermittent connection failures
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Installation
Versions des environnements
SQL Server:
SQL Server 2008
Application:
Web
Divers
Thread ID:
01458149
Message ID:
01458261
Vues:
60
>>I had previously found that article but it's not a fix for me (unfortunately). That article is really a guide for troubleshooting the initial installation of sql server. This is an established server with very infrequent, intermittent errors. Thanks though.
>
>I changed my connection string from:
>
>driver={SQL Server Native Client 10.0};server=TEST1;Failover_Partner=TEST2;database=testdatabase;uid=myusername;pwd=mypassword;
>
>to
>
>driver={SQL Server Native Client 10.0};server=TCP:192.168.0.10,1433;Failover_Partner=TCP:192.168.0.11,1433;database=testdatabase;uid=myusername;pwd=mypassword;
>
>and this appears to have fixed the random error message.
>
>For others with a busy sql server it seems leaving no ambiguity in the connection string solves certain intermittent errors.

Good job! What a pain in the butt that must have been to solve.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform