Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Intermittent connection failures
Message
General information
Forum:
Microsoft SQL Server
Category:
Installation
Environment versions
SQL Server:
SQL Server 2008
Application:
Web
Miscellaneous
Thread ID:
01458149
Message ID:
01458261
Views:
59
>>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.
Previous
Reply
Map
View

Click here to load this message in the networking platform