DBNETLIB error when trying to export my CRM database via SMSS. Need help troubleshooting, please

Question

Alright so, all I want to do is export a CRM database. I've already tried allowing SMSS through the firewall, no dice. I've taken screenshots of my process and hyperlinked them to the steps below to clarify what I'm up to.

I connect to CRM via SMSS.

I select the database.

I right click on the database -> Hit 'Tasks' -> hit 'Export Data'...

I select the OLE DB Provider as my data source, and it's here that I encounter the error.

Said error is below:

[DBNETLIB][ConnectionRead (recv()).]General network error. Check your network documentation. (Microsoft OLE DB Provider for SQL Server)

Would appreciate any help!

Answer 1

The problem here might be that you are not connecting to SQL Server, but to a "TDS gateway". The TDS gateway supports some types of SELECT queries, but not all.

I don't know exactly what SSIS submits, but a few years back, I wanted to connect to Dynamics CRM over a linked server. I found that did not work, because the TDS gateway did not have the stored procedures or views the OLE DB provider uses to get metadata from the remote server. I ended up writing a CLR procedure to fetch the data I needed, but that is clearly not an option for you.

Answer 2

Hi @blueHope202，

Seems like a network issue.

Since your issue is more related to Dynamic CRM, we suggest you post over at the dedicated Dynamic CRM forum there to get more professional advice.

https://community.dynamics.com/ask-question/

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.