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:
01458253
Views:
58
>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.
Brandon Harker
Sebae Data Solutions
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform