Skip to main content

Notifications

Announcements

Join us in the Community for an AMA: December 12th Register Today
News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Database Instance
Microsoft Dynamics NAV (Archived)

Database Instance

(0) ShareShare
ReportReport
Posted on by jsshivalik 3,027

Hi

  When i enter Database instance it gives error : Your entry of MSSQLSERVER is not an acceptable value for Database Instance

Instance is Default Instance

Secondly when i am trying to enter the below information in Change connecttion it gives error A server was not found net.tcp:test-pc:9046/Lve/Service

Thanks

*This post is locked for comments

  • Verified answer
    jsshivalik Profile Picture
    jsshivalik 3,027 on at
    RE: Database Instance

    Hi

       Resolved . Upgraded Express Edition

    Thanks

  • jsshivalik Profile Picture
    jsshivalik 3,027 on at
    RE: Database Instance

    Hi

      Navision has Navdemo instance . It got installed on SQLExpress as a result it is not taking Database greated than 10GB. I want the Database changed to default instance which is enterprise Edition. Is this possible.

    I have kept Database Instance Blank even then it is not working

    Thanks

  • jsshivalik Profile Picture
    jsshivalik 3,027 on at
    RE: Database Instance

    Hi

       Navision has Navdemo instance . It got installed on SQLExpress as a result it is not taking Database greated than 10GB. I want the Database changed to default instance which is enterprise Edition. Is this possible.

    I have kept Database Instance Blank even then it is not working

    Thanks

  • ManishS Profile Picture
    ManishS 6,578 on at
    RE: Database Instance

    How have you installed Dynamics NAV,

    Is it a Demo Installation or a Custom installation.

  • Suggested answer
    Zaid Tariq Profile Picture
    Zaid Tariq 2,266 on at
    RE: Database Instance

    Hi,

    1) Make sure the instance MSSQLSERVER exists (If you are use SQL Server Express then default instance could be SQLEXPRESS)

    2) Make sure the NAV database is at MSSQLSERVER.

    3) After step 1 and 2 configure the NAV service and restart.

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,745 on at
    RE: Database Instance

    Normally if you install it will create NAVDEMO instance. Open SQL Server management studio and check on which instance your database exists,if you are not using NAVDEMO and using Default Instance then you don't need specify anything on the NAV Service.

  • Suggested answer
    Brad_P Profile Picture
    Brad_P 1,542 on at
    RE: Database Instance

    Is that your instance or Database Server? If you have the default MS SQL Server installation then you wouldn't have an instance. You'd have a Database Server and Database name value. You can leave the instance blank if you do not have an instance.

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 us in the Community for an AMA: December 12th Register Today

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans