3-tier Nav2009 install SQL problem

dspace

I have a question/problem with the Nav2009 server install with the demo database. Everything seems to go ok except connecting to the SQl server. I get the following message:

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

Failed to connect to SQL database. (-2147467259 master )


I'm able to connect to the SQL server using the SQL management studio, but not during Nav server install. Any thoughts? I'm pretty sure the firewalls are setup ok and both machines are in the same domain. Thanks.

Peter_Wibeck_[MSFT]

Some questions

Are you running the SQL database installer on the database machine (May sound stupid but people miss this)?
Are you using the main setup application (found in root of DVD)?
Are you admin on the machine and in SQL server?

dspace

Are you running the SQL database installer on the database machine (May sound stupid but people miss this)?
Not stupid, but yes.

Are you using the main setup application (found in root of DVD)?
Yes

Are you admin on the machine and in SQL server?
Yes


I have since tried changing the login user on both SQL Server and NavServer to the same domain account, but don't see how I can test to see if that has made a difference.

I''ve also plugged ahead and tried to create a service principal name, but that hasn't worked and I'm suspecting that is because our domain is a Samba-server domain.

I would try to continue using network service instead of a domain account, but there isn't a walkthrough for that scenario.

Basically I haven't had a whole lot of luck with this project so far.

Peter_Wibeck_[MSFT]

You could try to-do it manually by stored procedures.
http://blog.wibeck.org/2009/05/installi ... -manually/

And then install the demo database by
http://blog.wibeck.org/2009/08/how-to-i ... rnative-2/