SQL Server Data Import Error

Question

I'm getting this error when trying to import an excel file into my server:

TITLE: SQL Server Import and Export Wizard

---

The operation could not be completed.

---

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

---

Answer 1

That error message means that you we're not able to access the SQL Server instance you had specified.

Common reasons for this error includes:

• SQL Server not running.
• Server name misspelled.
• You're mistaken on which machine SQL Server runs.
• You have installed a named instance, but you are not given the instance name.
• Firewalls blocking access.
• You are specifying a remote SQL Server instance, but it does not accept remote connections.
• You have not installed SQL Server at all on the machine you specify.

The list is not exhaustive. This troubleshooter can also help you.