Hello, i see that is old post but maybe i can add valuable info about sql error 40.
This error appears mostly when:
- SQL Server does not allow remote connections
- Firewall Settings
- TCP/IP is not enabled.
Some quick steps to solve this error are:
Check SQL Server is running
Make sure that Allow Remote Connections is enabled on sql server properties
Check if TCP/IP is enabled Configure to allow SQL Server in Firewall Settings
Check for working fine SQL Server Browser
Make sure that you can ping the SQL Server
I found this article to explain steps by step those solution and maybe can be helpful for the members in the future. Thnx
How has COVID affected your inspection or marine survey business?
Has remained slow the entire time
(79 Votes)
13.57%
Started slow, but ramping up now
(52 Votes)
8.93%
Business remained steady
(81 Votes)
13.92%
Busier than ever
(156 Votes)
26.8%
Expanded or planning to expand my business/inspectors
(39 Votes)
6.7%
Reduced or planning to reduce my business/inspectors
(52 Votes)
8.93%
I'm thinking about retiring
(65 Votes)
11.17%
I've decided to become a new inspector or marine surveyor.
(58 Votes)
9.97%
1271223547[{"id":"25","title":"Has remained slow the entire time","votes":"79","type":"x","order":"1","pct":13.57,"resources":[]},{"id":"26","title":"Started slow, but ramping up now","votes":"52","type":"x","order":"2","pct":8.93,"resources":[]},{"id":"27","title":"Business remained steady","votes":"81","type":"x","order":"3","pct":13.92,"resources":[]},{"id":"28","title":"Busier than ever","votes":"156","type":"x","order":"4","pct":26.8,"resources":[]},{"id":"29","title":"Expanded or planning to expand my business\/inspectors","votes":"39","type":"x","order":"5","pct":6.7,"resources":[]},{"id":"30","title":"Reduced or planning to reduce my business\/inspectors","votes":"52","type":"x","order":"6","pct":8.93,"resources":[]},{"id":"31","title":"I'm thinking about retiring","votes":"65","type":"x","order":"7","pct":11.17,"resources":[]},{"id":"32","title":"I've decided to become a new inspector or marine surveyor.","votes":"58","type":"x","order":"8","pct":9.97,"resources":[]}]["#ff5b00","#4ac0f2","#b80028","#eef66c","#60bb22","#b96a9a","#62c2cc"]sbar200200/en/polls.html?id=7&task=poll.voteMSG_ERROR_NO_SELECTIONPlease select either existing option or enter your own, however not both.MSG_THANK_YOU_NO_RESULTSCOM_COMMUNITYPOLLS_LABEL_ANSWERSVotes