New Database - SQL Error

eagle_eye

I have a functional 3 tier environment using ServerPort 7046, SQL Server SQL and Service Server SERVICE

I created a new test database called TEST on server SQL

I have a service tier called SERVER. I have created a new Service on port 7047.

I edited the config file for the new service to point to 7047 and edited the client config to do the same.

I used SETSPN to designate the login for security for 7047.

When I try to open the RTC on the SERVICE server - it works, but when running it from another location I get:

"The login failed when connecting to SQL Server SQL"

What am I missing?

dmccrae

If your SQL Server is also on a separate machine to the NAV Server, you will need to set up delegation for this to work, which can be tricky. There is some useful information here to do this:

http://msdn.microsoft.com/en-us/library/dd568720.aspx