Error Message in SQL Import and Export Wizard

KJP 10 Reputation points
2023-01-31T17:24:36.2533333+00:00

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?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,620 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 100.8K Reputation points MVP
    2023-01-31T22:23:38.6266667+00:00

    This message means that it was not possible to reach the SQL Server instance you have specified. Common reasons for this includes:

    • Incorrect server name.
    • Incorrect instance name.
    • The instance is not running.
    • Firewall rules.

    You can also try this troubleshooter.

    0 comments
  2. CosmogHong-MSFT 22,616 Reputation points Microsoft Vendor
    2023-02-01T02:40:06.0233333+00:00

    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.

    0 comments