Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

Generate the symbols

Posted on by 143

Hii  Everyone ,

I want to Know how to generated the symbols ??

I have connected the Server of azure databse but things it is i have only the server name i don't have database instance name. the database instance is blank then

how to generatd the symbols and when i put the only server name in it giving me this error 

Error :

[22922070] The following SQL Server error or errors occurred: 40607,"HY000",[Microsoft][SQL Server Native Client 11.0][SQL Server]Windows logins are not supported in this version of SQL Server.

 

can anyone guide 

Thanks & Rgds

Johnson 

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: Generate the symbols

    Maybe this can be of any assistance to you ?

    totovic.com/.../

  • pooja gund Profile Picture
    pooja gund 143 on at
    RE: Generate the symbols

    thank for reply

    my navision 2016 is credentail type is navuserpassword and now in BC14 my credentail type is windows so i was think may be the credentail is not matching that's why the error hitting so can suggest or guide how i can solve this error

    thanks

    Johnson

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,472 Super User 2024 Season 2 on at
    RE: Generate the symbols

    Hi, As far as I know, there is no problem with omitting the instance name. 

    The Command:

    finsql.exe Command=generatesymbolreference, Database=<DatebaseName>, ServerName=<ServerName>\<Instance>

    For example,

    finsql.exe Command=generatesymbolreference, Database=”Demo Database NAV (11-0)”, ServerName=ITMBSNAV

    More details: https://cloudblogs.microsoft.com/dynamics365/no-audience/2018/01/16/generate-symbols-in-a-modern-development-environment-with-microsoft-dynamics-nav-2018/

    And from the error message, it doesn't look like an Instance problem. 

    "Windows logins are not supported in this version of SQL Server."

    You can try adding other users.

    https://azure.microsoft.com/nl-nl/blog/adding-users-to-your-sql-azure-database/

    https://learn.microsoft.com/en-us/answers/questions/671968/enable-azure-sql-database-sa-user-account.html

    Hope this helps.

    Thanks.

    ZHU

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,091 Super User 2024 Season 1 on at
    RE: Generate the symbols

    Please share your Lanuch.json file meanwhile can you check if your launch.josn file has "authentication":"windows", change this with "authentication":"UserPassword" and try again.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans