Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

Setup could not connect to the database server

(0) ShareShare
ReportReport
Posted on by

Hi all,

I'm attempting to install Microsoft Dynamics AX 2012 R3 to do some testing and demonstration. 

When attempting to install the database component, I am greeting with this message "Setup could not connect to the database server ServerName*\DBName*"

However, I can clearly connect to this server & instance in SQL Server 2008 R2 on my Windows Server 2008 R2 machine.

I have tried setting the permission levels for the administrator account to match whatever might be needed. I just cannot get past this point. I've created new servers and instances, and still get the same result. Can anyone provide any insight?

Regards,

Parker

*This post is locked for comments

  • kgh Profile Picture
    kgh 80 on at
    RE: Setup could not connect to the database server

    Hi Parker,

    I have the same issue, please can you give more details about the solution

    Best Regards

  • ParkerPeng Profile Picture
    ParkerPeng on at
    RE: Setup could not connect to the database server

    Thank you, the issue is caused by my user permission.

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Setup could not connect to the database server
    • Off the firewall of DB server
    • the installer user must have the following role in SQL Server
      • dbcreateor
      • public
      • serveradmin
      • setupadmin
      • sysadmin
    • and the user mapping with following in SQL Server
      • db_accessadmin
      • db_datareader
      • db_datawriter
      • db_ddladmin
      • db_owner
      • db_securityadmin
      • public
      • RSExecRole

      it must be mapped with master database.

      Hope answer the question

  • skaue Profile Picture
    skaue on at
    RE: Setup could not connect to the database server

    I'll second Nigel. No need to explicitly use MSSQLSERVER or even "DEV07\.". The default named instance will pick up connections when the instance name is not provided. I believe the SQL Browser service needs to be running on the SQL Server first though. You should make sure the account you're using to install with has proper permissions all over the environment. So local admin on the AOS server and the SQL Server is a given, and further have necessary permissions on the SQL Server instance itself. Easiest is giving yourself sysadmin on SQL Server instance. During installation, the necessary permissions for the service accounts will be setup and if necessary you can retract the permissions given to the setup account (if really necessary). This looks like a development space, so I would expect broad permissions instead of least privilege. :-) 

  • Verified answer
    DaxNigel Profile Picture
    DaxNigel 2,572 on at
    RE: Setup could not connect to the database server

    MSSQLServer is the default instance and as such does not need to be used int he connection string, just use DEV07

    After the firewalls have been disabled on both machine sI would check the user permissions in SQL. Make your account a sysadmin in SQL and try again. If this works fine then it was a user account setup issue.

  • Suggested answer
    Denis Macchinetti Profile Picture
    Denis Macchinetti 16,444 on at
    RE: Setup could not connect to the database server

    Hi Parker

    Take a look at blogs.msdn.com/.../how-to-enable-remote-connections-in-sql-server-2008.aspx

    So, check if the "Allow remote connections to this server" option is enable.

    Also, verify if the TCP/IP protocol is enabled

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Setup could not connect to the database server

    It seems  your server topology for this installation is multi server.

    as you have already validated the permission then it should be some other issue, otherwise please review the permission once again.

    can you please confirm the in DB server name text box, are you able to see the DB server name or you are typing it

    Consider IP address in place of DB server name

    like <<IP>>\<<Database Instance Name>>

    please verify and update us with your findings

  • ParkerPeng Profile Picture
    ParkerPeng on at
    RE: Setup could not connect to the database server

    But the error still cannot pass.

  • ParkerPeng Profile Picture
    ParkerPeng on at
    RE: Setup could not connect to the database server

    I have close the windows firewall both on DB server and AOS server

  • Suggested answer
    RE: Setup could not connect to the database server

    Hi

    Please try after disabling the windows firewall on the DB server.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,111 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,934 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans