Got Error when export CRM
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
------------------------------
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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics