could not connect to Application server

brijen_rawat

Hi experts,

Kindly help me out, i am exhausted in establishing connection in 3 tier environment.

I am getting an error of connection "could not connect to Appserver" while setting up the 3-tier NAV server setup.
I would like to give a glimpse of all the activity i have done in 3-tier setup so far:
1.) Make two seperate Server, One Appserver and second Dataserver.
2.) Active Directory is in Appserver therefore I have created the domain user in it and grant all access to it by adding it in group of administrator and all possible groups.
3.) Created the domain user in SQL server i.e. in Dataserver and grant ndonavlistner schema to it.
4.) Changed the SQLSERVER service to domain user logon account.
5.) Passed all the commands throught cmd to create SPN account to provide delegation
6.) Enable all the TCP/IP port in SQL Server.

I have followed all the possible steps to build up the connection with Appserver, still i m stuck up somewhere and could not establish connection to the server.
-My firewall is off also on both server.
-I have added the sql port 1433 in delegation of user and firewall port also.
-I am able to login in FINSQL through window login but if run RTC then connectivity error is there.

Could anyone help me where i am getting wrong.


Thanks in advance, looking for a quick reply.

Regards,

Brijen.

mohana_cse06

Did you check with http://dynamicsuser.net/media/p/192857.aspx ?

brijen_rawat

Hi Mohana,
Thanks for your quick reply.

I should run this utility in both the server or in Appserver only.

Regards,

Brijen.

brijen_rawat

Hi Mohana,

I have installed the Best Practices Analyser and it scans out the attached error.
I am not able to understand why it has shown me such error, as I have made a domain user and that domain user is connected with demo database in SQLServer and has the administration rights.

Kindly help me out.

Regards,

Brijen.

kine

dataserver\dataserver\sqlsvc

??? Check your config file for the server. It looks like you entered server name into instance name instead just the instance name. If you are using default instance, use empty value.