unable to connect to database server from excel sheet.

Question

Hi All,

When am trying to connect to sql  2008R2 server from excel sheet. Am getting below error

can anyone help me in this.

regards,

---

Maheshwar Reddy

Answer 1

Hello,

The image is not visible. Can you please post the error text instead?

---

Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Blog Xing

Answer 2

Hi Maheshwar,

Connect to SQL Server 2008 R2 from Excel locally, follow the steps:
Open Microsoft Excel, on the Data tab, click From Other Sources and select From SQL Server.
Type the Server name. If you connect a default instance, type computername. If you connect a named instance, type computername\instancename.
You could use Windows Authentication or use a SQL Server user. Click next.
You could choose a database and a table to export from database to Excel sheet. Click finish.

If you remotely connect to SQL Server 2008 R2 from Excel, you need to make sure that:
The server allows remote connections.
The firewall has configured properly.
SQL Server Browser service is running.

If it is still not work, please post the error messages in detail.

Thanks,
Maggie

 

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.