Skip to main content

Notifications

Dynamics 365 Community / Forums / Microsoft Dynamics NAV forum / Error: [Microsoft][SQL...
Microsoft Dynamics NAV forum
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.
 
Categories:
Development / Customization / SDK
  • 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 61,472 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!

HR Infrastructure Customer merge

Important considerations for HR Customer migrations…

more Community News

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,450 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 224,020 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,142

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans