TITLE: SQL Server Import and Export Wizard
------------------------------
Could not retrieve table list.
------------------------------
ADDITIONAL INFORMATION:
Unable to complete login process due to delay in opening server connection (Microsoft SQL Native Client)
------------------------------
BUTTONS:
OK
------------------------------
Got Error when export CRM
July 2nd, 2013 2:16am
use this checklist to rule an issue out:
- Check whether Remote Protocol (NamePipes and TCPIP) are enabled or not. If not, enable them and restart the service.
- If you are using NamedInstance, make sure SQLBrowser is enabled.
- If its taking too long to connect to server, use the switch -l in command and verify.
- sqlcmd.exe -U username -P password -l120 -S myserver
- If this works, you can configure remote-login time out values in database properties under advanced > Network settings
- Also, try using the IP address to connect with as sometimes there might be a delay by DNS server mapping.
Credits: http://durgaprasadch.wordpress.com/2013/05/03/sqlcmd-error-microsoft-sql-server-native-client-10-0-unable-to-complete-login-process-due-to-delay-in-opening-server-connection/
Free Windows Admin Tool Kit Click here and download it now
July 2nd, 2013 1:58pm