3 Computer install issue

eagle_eye

I have the NAV Server on Server1
I have the Database on Server 2
And have installed the clients on both Server for testing

When Connecting to the Classic SQL client - no problem

When connect to the RTC I get the following error:

The Microsoft Dynamics NAV Server cannot connect the Change Listener to the SQL Server due to the following error: Login failed for user
'DOMAIN\Server1$.

Can anyone provide me with any help in resolving this??

On the userconfig I have specified the Nav Server (Server1) as the Server
The SQL database is not installed on a named instance
The server config specifies the SQL Server computer name(Server2) as the database server name

Any ideas what I can do?

SilverX

For your error: Your NAV server runs under NETWORK SERVICE crendentials and tries to authenticate the computer account on the SQL Server. You should follow the instllation guides carefully. Especially these:

Configuring Microsoft SQL Server
Installation Walkthroughs

In a 3 computer setup also read this.

Note: The setspn command for SQL Server is wrong in the docs, use "MSSQLSvc" without the computer part. And always add two service principal names: one with a fqdn, one with a computer name only.

If you have issues after this, search in this forum. I have seen your and some similar delegation related errors here before.
There is a hotfix available which deals with delegation scenarios. I didn't remind yet, so maybe someone can help me out here