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

Generate the symbols

(0) Share

Report

Posted on by pooja gund

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

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Nitin Verma 21,700 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,546 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
pooja gund 143 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,105 Moderator on at

Like (0)

Report

Maybe this can be of any assistance to you ?

totovic.com/.../

Was this reply helpful? Yes No