Setup could not connect to the database server

(0) Share

Report

Posted on by ParkerPeng

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

I have the same question (0)

All responses (10)

Answers (2)

Suggested answer

Syed Zeeshan Haider... 725 on at

Like (0)

Report

Hi

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

Was this reply helpful? Yes No
ParkerPeng on at

Like (0)

Report

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

Was this reply helpful? Yes No
ParkerPeng on at

Like (0)

Report

But the error still cannot pass.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Denis Macchinetti 16,444 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

DaxNigel 2,574 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Tommy Skaue Moderator on at

Like (0)

Report

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. :-)

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (2)

Report
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

Was this reply helpful? Yes No
ParkerPeng on at

Like (1)

Report

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

Was this reply helpful? Yes No
kgh 80 on at

Like (0)

Report

Hi Parker,

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

Best Regards

Was this reply helpful? Yes No