Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV forum
Suggested answer

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

Posted on by 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 62,281 Super User 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

Helpful resources

Quick Links

Can you answer this forum question?

You could make someone's day!

Community Newsletter - May 2024

Kudos to our community stars!

Community Spotlight of the Month

Kudos to Mohamed Amine Mahmoudi!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 283,676 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 224,910 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,146

Featured topics

Product updates

Dynamics 365 release plans