We're trying to install a fresh ePO 5.0 on a fresh Windows Server 2012 Enterprise without success.
After having installed Windows Server 2012 Enterprise, we installed MS SQL Server 2012 with all features and default configuration. There is really nothing special.
When trying to install ePO afterwards, we get the following error in the logs:
20130507113451 Entered ValidateAccountAndSQL function.
20130507113451 Calculating the DataSource for your SQL server.
20130507113451 UDP port is not enabled so configuring DataSource to use port number instead.
DataSource used: [MYMACHINE,1433]
20130507113451 Setting connection string DataSource to [MYMACHINE,1433].
20130507113451 Connection string set for SQL Authentication database connection.
20130507113451 SQL::connect to server MYMACHINE
20130507113451 Testing SQL Authentication to SQL Server.
20130507113451 Failed to connect to SQL Server [MYMACHINE] with error code [0x800a0e7a]
20130507113451 Description for error code is [Provider cannot be found. It may not be properly installed.]
20130507113451 Failed in connectToSQLServer with error code .
20130507113451 Exiting function ValidateAccountAndSQL with return code: 2
Especially the lien "Description for error code is [Provider cannot be found. It may not be properly installed.]" is interesting.
We have searched the internet up and down, reinstalled everything exactely again, having installed all updates, installed sql native clients - nothing. Even registering dll's did not do the trick.
What may be the problem?
Thanks for any help!
We managed to fixed it. It seems that the epo installer 5.0 does not respect default installation directories set by the system on a different volume (any other than C:\). Having installed it on c:\ did the trick.
As it resolved our situation but does not fix the issue, we consider this thread as unresolved.
Can you clarify a bit on this? The installer should certainly let you specify a drive other than C... which default installation directories are you referring to?
The thing is, if you change the registry keys for Program Files (HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion), the .NET Framework redistributables get installed on the right drive, but the ePO installer still looks on c:\ for the oledb dll files.
In addition, the proposed default installation directory does not respect the registry keys mentioned above.
Not that big of an issue, but still probably worth to mention in a kb regarding the issue described above.
In addition to the answer mentioned above, here's a reproducable steps list:
1) Install Windows Server 2012, x64
2) Change registry keys in "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion" from C:\ to D:\ (Should be about 3-5 keys to edit).
3) Install SQL Server 2012, defaults with mixed auth mode (windows auth and sql auth)
4) Try login from SQL Management Tools as well as from cmd console - works
5) Try remote login - works
6) Try install ePO 5.0 on the same server - installs .NET redistributable. Later fails when trying to validate server credentials.