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
Hi Parker,
I have the same issue, please can you give more details about the solution
Best Regards
Thank you, the issue is caused by my user permission.
it must be mapped with master database.
Hope answer the question
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. :-)
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.
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
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
But the error still cannot pass.
I have close the windows firewall both on DB server and AOS server
Hi
Please try after disabling the windows firewall on the DB server.
André Arnaud de Cal...
292,111
Super User 2025 Season 1
Martin Dráb
230,934
Most Valuable Professional
nmaenpaa
101,156