Options

Connect NAV2013 R2 service to separated SQL Server on Workgroup

PhennoPhenno Member Posts: 630
Hi All!

Is there a way to connect NAV2013 service to separated SQL server while everyting is on workgroup, meaning without AD?

I have specific situation where I need connectivity from NAVservice to external resources not available from SQL server so I need to put NAVservice to my local machine...

Best Answer

Answers

  • Options
    PhennoPhenno Member Posts: 630
    Will try that, thank you.
  • Options
    PhennoPhenno Member Posts: 630
    I'm receiving this message in SQL server:
    Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'

    It seems that first I have anonymus Logon. Maybe I have to change some windows options for login...
  • Options
    PhennoPhenno Member Posts: 630
    Vremeni, it's Working! But with anonymus logon which is more than security risk even in temporary development environment such as this... I will try to find a way to authenticate, at least as my laptop but this is quite ok for start.
  • Options
    vremeni4vremeni4 Member Posts: 323
    Hi,

    Well, true this is not very secure.

    Another option which I forgot,
    Create a user in the domain, that you want to use for the service.
    Then start NAV Admin Control , right click on the service and select "Login Account".
    Then in the middle panel click on edit button and you can insert the username, domain and password. (see attached screenshot)

    This should work too, but this imply that you have a dedicate user created in the domain for this.

    I hope this helps.

  • Options
    PhennoPhenno Member Posts: 630
    Vremeni,

    I do not have domain at all, plain old workgroup environment. Only domains are computers itself.
  • Options
    vremeni4vremeni4 Member Posts: 323
    Hi,

    In that case I would suggest to make sure that SQL machine and your laptop can "see" each other.
    If you setup your laptop that your workgroup/network is your "home" or "work" and say that you want to share on both, then SQL should see the name of the laptop instead of Anonymous.

    I hope this helps.
  • Options
    PhennoPhenno Member Posts: 630
    Ok, will try that also.
  • Options
    krikikriki Member, Moderator Posts: 9,096
    Instead of using network service, you can create a local user on both the SQL Server and the service tier. Both NEED to be the exact same name and same password. Then you add that user inside your SQL server.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


  • Options
    PhennoPhenno Member Posts: 630
    I will try this also, thanx.
Sign In or Register to comment.