Options

Database server reset using windows authentication

lzrlzr Member Posts: 264
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

  • Options
    DenSterDenSter Member Posts: 8,304
    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.
  • Options
    lzrlzr 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
  • Options
    JanStepanekJanStepanek Member Posts: 6
    Hello,

    try change navision service account to system administrator account.

    Regards,

    Jan
  • Options
    lzrlzr Member Posts: 264
    Hello,

    try change navision service account to system administrator account.

    Regards,

    Jan

    Very nice, that worked. Thanks alot! =D>
    Navision developer
  • Options
    kinekine 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.
  • Options
    lzrlzr 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
  • Options
    kinekine 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.
  • Options
    lzrlzr 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
Sign In or Register to comment.