Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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.
 
  • 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.
  • 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
  • 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
  • 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.
     
  • 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?
     
     
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 79,380 Super User 2025 Season 1 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

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

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,280 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,038 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans