Connect NAV2013 R2 service to separated SQL Server on Workgroup

Phenno

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...

vremeni4

Hi,

If you are not in the same network then you have to use VPN to join the same network.

If you are in the same network, then setup the NAV service with the user "Network Service" on you local machine. (NT AUTHORITY\NETWORK SERVICE)

If the name of your laptop is e.g. LAPTOP,
then a user should be "workgruop\LAPTOP$" on the SQL server.
I am not sure if workgruop\LAPTOP$ is the correct name but you can double check this, by starting the NAV service. (it will fail but it will create a helpful error message on SQL server)
Then start SQL studio manager connect to the SQL server, and go to Management -> SQL Server Logs ->Current.

In the list of error messages it should be an error message that says a user e.g. "workgp\LAPTOP$" tried to connect to the database XY.
Use that name e.g. "workgp\LAPTOP$" to create a login in SQL and give it db_owner permissions on the database
The NAV service will now start from your local machine without a domain

I hope this helps.

vremeni4

Hi,

If you are not in the same network then you have to use VPN to join the same network.

If you are in the same network, then setup the NAV service with the user "Network Service" on you local machine. (NT AUTHORITY\NETWORK SERVICE)

If the name of your laptop is e.g. LAPTOP,
then a user should be "workgruop\LAPTOP$" on the SQL server.
I am not sure if workgruop\LAPTOP$ is the correct name but you can double check this, by starting the NAV service. (it will fail but it will create a helpful error message on SQL server)
Then start SQL studio manager connect to the SQL server, and go to Management -> SQL Server Logs ->Current.

In the list of error messages it should be an error message that says a user e.g. "workgp\LAPTOP$" tried to connect to the database XY.
Use that name e.g. "workgp\LAPTOP$" to create a login in SQL and give it db_owner permissions on the database
The NAV service will now start from your local machine without a domain

I hope this helps.

Phenno

Will try that, thank you.

Phenno

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...

Phenno

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.

vremeni4

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.

Phenno

Vremeni,

I do not have domain at all, plain old workgroup environment. Only domains are computers itself.

vremeni4

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.

Phenno

Ok, will try that also.

kriki

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.

Phenno

I will try this also, thanx.