Personalized Community is here!
Quickly customize your community to find the content you seek.
Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2020 Release Wave 2Discover the latest updates and new features to Dynamics 365 planned through March 2021.
Release overview guides and videos Release Plan | Preview 2020 Release Wave 2 TimelineWatch the 2020 Release Wave 1 virtual launch event
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
When I install the connector according to this procedure: http://technet.microsoft.com/en-us/library/dn507083.aspx
the installation program asks for the name of the server with Sql Server installed, and I type it, but the pre-installation validation says that "Microsoft Sql Server is required in order to install the Microsoft Dynamics AX database".
I would like to avoid installing Sql server in the machine where the AOS is running, so I would be grateful if anyone had the same experience and knows a solution.
If communication to SQL server works (ping responds, there is no traffic blocked on firewalls), and if AX database IS installed on SQL server, then I would guess that you are pointing to SQL server only, while you probably have instances on it; if I am right, you should provide not only SQL server name, but SQL server name with instance name where AX database is located.
Hi, I tried everything, even serverName\InstanceName, he does not give error and I can ping the server. The problem arise when validating: it says I need Sql Server installed!
then probably permission/access error; if you could check logs on both: sql server and machine where you are trying to install connector would help; I believe what is in logs (mainly on machine where you are trying to install connector) would give you an answer.
from my experience worth to check is:
- if sql server allows remote conenctions, and if so, if it listens on 1433
- if user you are using to do install has sufficient permissions; be aware that even administrator may not have database permissions granted by default
- also if possible, tro to connect to sql server/ax database from computer other than sql server itself using sql management studio; if it would not be possible, then reason would be clear
In the same machine where I try to install the connector there is AX client and AOS, that connects without problems to the Sql Server if I launch it with my account, so I don't think it's a problem of firewall or permissions. But it's true that the prerequisite report states that "This failure typically occurs because the Windows service for the SQL Server instance is not running, or because the user running Setup does not have permission to query the database.".
there is something wrong then, or I misunderstood you; according to above you have 2 servers:
- one with aos & client
- second with sql
as I understood you are trying to install connector on first one - what seems strange to me; if you have there aos & client already, it means you have to have connector installed already; are you trying to install second instance (?) of connector? or maybe which connector you are trying to install, so called 'net business connector' or any other?
my fault, sorry - just found you're meaning not net business, but other one; sorry then, misunderstood you.
Yes you're right regarding the architecture. The Dynamics connector is an option during AX installation, it's the first time I check this option.
In the same server where there is AOS and Client there is also the CRM back-end server, while the front-end CRM server is in another server.
Thank you for your help.
You say "if you have there aos & client already, it means you have to have connector installed already": it is not true, you can install the AOS and Client without checking the option "Connector for Microsoft Dynamics".
Regarding the connection to sql server that does not work, in the logs I see the following message: "Error Code 1722: The RPC server is unavailable".
My account that runs the installation has sysadmin rights to the Sql server, and answering to another question of yours if I open Sql Server Management Studio in the machine where I run the installation, I can connect to the target instance without problems. So §I really don't see what can the cause of this Sql server connection error.
did you run the setup as admin?
does your account has admin rights for the sql server?
what is your sqlserver name (including instance)?
Yes I ran the setup as admin. My Sql Server name, including instance is: FLEXMIND-SQL\PROJECT
the error "Error Code 1722: The RPC server is unavailable" can be caused by wrong firewall settings. The SQL server is not reachable remotely.
This is what I thought too, so for testing I disabled the firewall in the two machines, but this didn't change anything. The Sql Server is absolutely reachable remotely, because I can connect to it from the AX client, and even from the Sql Server management studio. Very strangely the sql server isn't reachable from the Ax connector setup.
The sql profiler doesn't say anything interesting, in the events log I see an error about the .Net Business connector, but without any detail.
it can also be that there is an insufficient AD setting for the target server (the server with the sql server) and dynamics ax, means missing SPNs.
also check if there is an antivirus program (with firewall), e.g. mcaffee, which can cause this problem.
I will check for the AD settings but I've never had issues of this kind.
Just some more information: in the log file I see:
2014-10-19 19:46:59Z Performing a database version check for prerequisite 'Microsoft SQL Server (Connector for Microsoft Dynamics)'.
2014-10-19 19:46:59Z Attempting to connect to SQL Server 'FLEXMIND-APP'.
so the setup looks for a Sql Server instance in the local server, even if I specified another server! In fact, as I mentioned in my first question in this page, the prerequisite failed because there was no Sql Server instance in the machine where I was running the setup, so I had to install Sql Server even if then I had to specify another server as Sql Server!!!!
This really looks like a bug.....
Thanks a lot anyway
remove the failed installation, remove the installed files/folders, if there are any.
check again the prerequisites (especially the crm updates).
is the sql server browser service running?
install the dyn. connector on the same server where the sql server resides.
At last I found the solution: the latest version of the connector.msi, that works for SQL Server 2014 and AX 2012 R3: blogs.msdn.com/.../connector-for-microsoft-dynamics-now-supports-microsoft-sql-server-2014-and-microsoft-dynamics-ax-2012-r3.aspx
I thought that the latest version of the AX installer included the latest version of the Connector installer, but it is not true, it is necessary to use the .msi for the connector.
Thank you all for your help.
Business Applications communities