NAV2009R2 Installation on 3 Computers

Shashanksid

Problem Could not connect to database During 2009 R2 installation on 3 Computers

Dear Expert's
First off all Thank's For your Supports..
Right Now I am Working on The 3 tier installation of NAV2009 R2 on Three computers with help of The following Document..
http://msdn.microsoft.com/en-us/library/dd301254.aspx

For This Installation I create The Following Envoirment.

a)NAVSQL-Windows Server 2003 SQL Server 2005(Physical M/C) For database tier
b)NAVSERV-Windows Server 2003 SQL Server 2005(Physical M/C) For Middel tier
c) NAVCLIENT -Windows 7(VPC)
user is domain administrator

I followed All The steps which mentioned in The document ,During This I faced Following problem.
a)During Installation of NAVSQl when specify the parameters during Installation I get The Following Error Report.

Microsoft Dynamics NAV 2009 R2 Build 32012
Error Report
SQL Server option
Microsoft Dynamics NAV 2009 Components for Microsoft SQL Server
Fatal error during installation.

Could not connect to the SQL database. (-2147467259 master ). This can be caused by insufficient permissions. Indirect permissions through Windows group memberships may not work as expected when User Account Control (UAC) is turned on.
Cronus Sample Database for Microsoft Dynamics NAV 2009
Fatal error during installation.

Could not connect to the SQL database. (-2147467259 master ). This can be caused by insufficient permissions. Indirect permissions through Windows group memberships may not work as expected when User Account Control (UAC) is turned on.


b) when I complete all the procedure and try to Connect The database from NAV client it Gives me following Error
"Could Not Connect The Database"
I have mention The Following Server path Address manually on The RTC window
10.104.101.174:7046/DynamicsNAV
The Following Error message occurred
"Could Not Connect The Server "

Please help me regarding This Issue

With regards
SID

mohana_cse06

I think this (10.104.101.174) IP adrress is of NAVSERV

Have you modified Custom Settings File in NAVSERV with Server as NAVSQL and Database name?

Is NAV Service running in NAVSERV?

Can you be able to connect via classic?

Shashanksid

Thank,s For Your Reply

Yes (10.104.101.174) IP adrress is of NAVSERV

And I make the changes in the custom setting File On the NAV SERV

And Even I make The change in The Firewall setting where it allow the SQL EXE and other Port
In this senario we have not install the classic client. so i did not check it.

mohana_cse06

I hope you are trying to connect from Client machine..
Check whether you can connect from NAVSERV machine only..
have you done Enable Change Listener and delegation?