3-tier Nav2009 install SQL problem

dspacedspace Posts: 15Member
edited 2009-08-27 in NAV Three Tier
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.

Comments

  • Peter_Wibeck_[MSFT]Peter_Wibeck_[MSFT] Posts: 78Member, Microsoft Employee
    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?
    “This posting is provided "AS IS" with no warranties, and confers no rights.”

    Peter Wibeck
    Software Development Engineer in Test
    Dynamics NAV Server and Installer team
    http://blog.wibeck.org/
  • dspacedspace Posts: 15Member
    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]Peter_Wibeck_[MSFT] Posts: 78Member, Microsoft Employee
    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/
    “This posting is provided "AS IS" with no warranties, and confers no rights.”

    Peter Wibeck
    Software Development Engineer in Test
    Dynamics NAV Server and Installer team
    http://blog.wibeck.org/
Sign In or Register to comment.