web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Error: [Microsoft][SQL...
Small and medium business | Business Central, N...
Suggested answer

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

(1) ShareShare
ReportReport
Posted on by MC-10051438-0 6
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.
 
I have the same question (0)
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 92,445 Super User 2025 Season 2 on at
    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.
     
     
    Hope this helps.
    Thanks.
    ZHU
  • RobertoLampa Profile Picture
    RobertoLampa on at
    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?
     
     
  • CU10051422-0 Profile Picture
    CU10051422-0 2 on at
    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.
     
  • Suggested answer
    MC-10051438-0 Profile Picture
    MC-10051438-0 6 on at
    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
  • MG-21051150-0 Profile Picture
    MG-21051150-0 2 on at
    Error: [Microsoft][SQL server native client 11.0] State ID:07006
    Hi,

    what compatibility level was configured before you changed it to 110?
    We also have the same issue and are on level 120.

    Microsoft support was as helpful as ever in suggesting a technical upgrade to latest build.
    Did you open a case with them or just found the solution through trail and error?
     
    thank you
  • MC-10051438-0 Profile Picture
    MC-10051438-0 6 on at
    Error: [Microsoft][SQL server native client 11.0] State ID:07006
    I believe the level was at SQL 2016 before changing it to 2012.  It was trial and error.  We also put in a request into Microsoft and they told us the same thing.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 4,237

#2
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 3,425

#3
Sumit Singh Profile Picture

Sumit Singh 2,907

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans