Database server reset using windows authentication

lzr
lzr Member Posts: 264
edited 2005-10-04 in NAV/Navision Classic Client
If I use database verification it works perfectly, but if I use windows verification (yes, I have added my account in the database) the database server resets and I have to start the service again manually.

It also works if I connect directly to the database using windows authentication.

I am using Navision 4.0 with native db, and using TCP tcp connect to the database.

Anyone out there that has any experience with this?
Navision developer

Answers

  • DenSter
    DenSter Member Posts: 8,307
    Is the service set up with TCP or TCPS? The default when installing the database server is TCPS, so you have to manually set this to TCP.
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • lzr
    lzr Member Posts: 264
    DenSter wrote:
    Is the service set up with TCP or TCPS? The default when installing the database server is TCPS, so you have to manually set this to TCP.

    TCP/IP (not the kerberos one)
    Navision developer
  • JanStepanek
    JanStepanek Member Posts: 6
    Hello,

    try change navision service account to system administrator account.

    Regards,

    Jan
  • lzr
    lzr Member Posts: 264
    JanStepanek wrote:
    Hello,

    try change navision service account to system administrator account.

    Regards,

    Jan

    Very nice, that worked. Thanks alot! =D>
    Navision developer
  • kine
    kine Member Posts: 12,562
    Are you using Update 1 (not SP1)??? THe base version of 4.00 have this problem...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • lzr
    lzr Member Posts: 264
    kine wrote:
    Are you using Update 1 (not SP1)??? THe base version of 4.00 have this problem...

    Hmm, it should be the latest version, I thought it was 4.01 (?)
    Navision developer
  • kine
    kine Member Posts: 12,562
    The 4.01 (SP1) was released few days ago. What Build you are using?(version of the .exe file)
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • lzr
    lzr Member Posts: 264
    kine wrote:
    The 4.01 (SP1) was released few days ago. What Build you are using?(version of the .exe file)

    Nice, I have to wait until it is released in Swedish version tho :)

    20942 is the build I am using
    Navision developer

Categories