Unsolved
This post is more than 5 years old
1 Message
0
2484
July 25th, 2016 11:00
OME v2.2 Install Database Server local/SQLEXPRESSOME login failure
I have a new installation of OpenManage Essentials on a Dell T610 (Server 2012-R2 Std) that is also a domain controller.
All of the prerequisite steps were successful and am at the stage where I provide the database server name and authentication.
I tried using my normal domain administrator credentials (same as what I am logged in as to do the install) but it errors "Cannot connect to (local)\SQLEXPRESSOME. Login faile for user \administrator.
Next I created a user account just for this login and gave it Domain Admins memebership. Same problem.
Tried using local SQL server authentication by providing a user name and password that I want it to use but then I get the error "Microsoft ODBC SQL Server Driver [dbmslpcn] SQL server does not exist or access denied SQL State: 08001
I found the installation document that shows these screens but it doesn't say what to do when it doesn't work and I couldn't find posts that seem to apply.
Any thoughts on what I should try?
Thanks -Randy-
events found
DELL-Martijn G
291 Posts
0
July 26th, 2016 03:00
First of all I would really like to advise not to install OME on a Domain Controller (DC), the reason for this is IIS. Microsoft does not advise installing IIS on a DC, this is because of the local accounts that normally get created with IIS which obviously do not work on a DC because there are no local accounts anymore.
See:
Security Best Practices for IIS 8
Do not run IIS on a domain controller or a backup domain controller.
First, there are no local accounts on a domain controller. Local accounts are important to the security of many IIS server installations. Placing an IIS web server and domain controller on the same computer seriously limits your security account options. Second, any new exploit that compromises your web server could also compromise your entire network when the web server and the domain controller are on the same computer.
That being said, you probably need to install SQL Express Management Studio to be able to edit the security settings and allow the proper users/groups access to SQL