This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(182.40000000000003, 3%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
I'm trying to import data into my SQL Server using SQL Server Import and Export Wizard and I keep getting this error message:
TITLE: SQL Server Import and Export Wizard
Could not retrieve table list.
ADDITIONAL INFORMATION:
A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.
Client unable to establish connection
Registry information is corrupt or missing. Make sure the provider is installed and registered correctly. (Microsoft SQL Server Native Client 11.0)
BUTTONS:
OK
Any ideas on how to fix this?
This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Hi @KJP
We haven't heard any response from you yet.
Do you have further question on this issue, could we offer more support?
If any answer helps on your issue, you could mark it as answer so other user with similar problem could see this easier. :)
Best regards,
Cosmog Hong
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 0%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYS%3C/text%3E%3C/svg%3E)
Same error was facing by me bt not resolved will you please help me to overcome this
House rules: don't piggyback on old threads, but ask a new Question. You can also check this troubleshooter.
This message means that it was not possible to reach the SQL Server instance you have specified. Common reasons for this includes:
You can also try this troubleshooter.
Hi @KJP
The error usually means that the “SQL server is not found” or “TCP port is either unknown or wrong”, or it can be blocked by the “firewall”.
Follow the below steps to see if you can resolve the issue.
Step 1 - Check that you can ping the SQL Server box.
Step 2 - Check that the SQL Services are running.
Step 3 - Check that the SQL Server Browser service is running
Step 4 - Check that you are using the correct SQL Server instance name
Step 5 - Check that you can find the SQL Server
Step 6 - Check that TCP/IP and Named Pipes are enabled
Step 7 - Check that allow remote connections for this server is enabled
Step 8 - Check the port number that SQL Server is using
Step 9 - Check that the firewall is not blocking access to SQL Server
Step 10 - Check that the Service Principal Name has been registered.
Refer to this article for more details: Resolving could not open a connection to SQL Server errors.
Also, see this blog which might help: How to Fix the Error ‘A Network-related or Instance-specific Error occurred while Establishing a Connection to SQL Server’ ?
Best regards,
Cosmog Hong
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.