Error: [Microsoft][SQL server native client 11.0] State ID:07006

(1) Share

Report

Posted on by MC-10051438-0

We are coming across this message when trying to run an object or even doing file/database/information from object designer. We can use the client though. We are on Microsoft Dynamics NAV 2017 CU 11. We are using Azure SQL for the database platform.

These are the things we have tried:

1. Restore of the database from backup

2. Restore of the server from backup

3. Setup a whole new environment i.e new server, new database server, new restored copy of a database which has no issues.

Categories:

Development / Customization / SDK

All responses (4)

Answers (0)

Suggested answer

MC-10051438-0 4 on at

Like (0)

Report

Error: [Microsoft][SQL server native client 11.0] State ID:07006

We had to change the compatibility mode of the Azure SQL database to SQL 2012
CU10051422-0 2 on at

Like (0)

Report

Error: [Microsoft][SQL server native client 11.0] State ID:07006

Hi,

How are you?

Did you find a solution for your issue? I have exactly the same.

Thanks in advance for your reply.
RobertoLampa on at

Like (0)

Report

Error: [Microsoft][SQL server native client 11.0] State ID:07006

Hi,

we're having the exact same error with Microsoft Dynamics NAV 2018 CU 49 and Azure SQL for the database platform.

The tier is running but the Development Environment is non accessing the database.

Did you find a solution?
Suggested answer

YUN ZHU 60,818 Super User on at

Like (0)

Report

Error: [Microsoft][SQL server native client 11.0] State ID:07006

Hi, looks similar to the question below, I hope it can give you some tips.
However, if there is no problem after reinstalling the Cronus database, this should be a problem with the database.

https://forum.mibuso.com/discussion/29664/odbc-error-occured-restricted-data-type-attribute-violation

Hope this helps.

Thanks.

ZHU