ERROR when checking Active for Microsoft Dynamics NAV Server

tiagofrancis

Hi Folks,

I've done a few installations of NAV Server and Business Web Services and never got this error.

When trying to activate the NAV Server in the Alter database options i've the following error:

Microsoft Dynamics NAV Classic

---

Ocorreu o seguinte erro ou erros no SQL Server: 15401,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]Windows NT user or group 'NT AUTHORITY\NETWORK SERVICE' not found. Check the name again.

SQL:
CREATE LOGIN [NT AUTHORITY\NETWORK SERVICE] FROM WINDOWS

---

OK

---

The login already exists in the dabase server beacause we've SharePoint also installed.

Does anyone have a clue? Thanks in advance.

tiagofrancis

Pease consider Enable instead of Active.

tiagofrancis

I figured this out. It seems that it is not possible (stupid) to enable nav server when NT Authority\Network Service is already created as a login in SQL. I had this login created and mapped to SharePoint database. I've talked on the phone with Microsoft escalation enginners and this was the reason. Had to drop it and let Nav Server enabling create the login. It's quite stupid but it true and no it is working! Thanks in advance.