Windows 2012 R2 IPAM install Fails

Windows 2012 R2 Member Server

IPAM

IPAM fails to install requires a system reboot.

The install is installing an internal database and I want to use a SQL database which this server already has access to.
Why can't I unselect the internal database

The error is on the internal database service account which is not granted logon as a service rights.

I even changed the service account to one I have with logon as a service account and then the service starts but the install is incomplete and when you try to complete the install the internal database gets put back as new with the wrong service account again

See below

Get these two errors

og Name:      System
Source:        Service Control Manager
Date:          8/21/2015 10:57:42 PM
Event ID:      7041
Task Category: None
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      SERV013.FQDN.com
Description:
The MSSQL$MICROSOFT##WID service was unable to log on as NT SERVICE\MSSQL$MICROSOFT##WID with the currently configured password due to the following error:
Logon failure: the user has not been granted the requested logon type at this computer.
 
Service: MSSQL$MICROSOFT##WID
Domain and account: NT SERVICE\MSSQL$MICROSOFT##WID
 
This service account does not have the required user right "Log on as a service."
 
User Action
 
Assign "Log on as a service" to the service account on this computer. You can use Local Security Settings (Secpol.msc) to do this. If this computer is a node in a cluster, check that this user right is assigned to the Cluster service account on all nodes in the cluster.
 
If you have already assigned this user right to the service account, and the user right appears to be removed, check with your domain administrator to find out if a Group Policy object associated with this node might be removing the right.
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="Service Control Manager" Guid="{555908d1-a6d7-4695-8e1e-26931d2012f4}" EventSourceName="Service Control Manager" />
    <EventID Qualifiers="49152">7041</EventID>
    <Version>0</Version>
    <Level>2</Level>
    <Task>0</Task>
    <Opcode>0</Opcode>
    <Keywords>0x8080000000000000</Keywords>
    <TimeCreated SystemTime="2015-08-22T02:57:42.603959300Z" />
    <EventRecordID>46302</EventRecordID>
    <Correlation />
    <Execution ProcessID="508" ThreadID="10960" />
    <Channel>System</Channel>
    <Computer>SERV013.FQDN.com</Computer>
    <Security />
  </System>
  <EventData>
    <Data Name="param1">MSSQL$MICROSOFT##WID</Data>
    <Data Name="param2">NT SERVICE\MSSQL$MICROSOFT##WID</Data>
  </EventData>
</Event>


Log Name:      System
Source:        Service Control Manager
Date:          8/21/2015 10:57:42 PM
Event ID:      7000
Task Category: None
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      SERV013.FQDN.com
Description:
The Windows Internal Database service failed to start due to the following error:
The service did not start due to a logon failure.
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="Service Control Manager" Guid="{555908d1-a6d7-4695-8e1e-26931d2012f4}" EventSourceName="Service Control Manager" />
    <EventID Qualifiers="49152">7000</EventID>
    <Version>0</Version>
    <Level>2</Level>
    <Task>0</Task>
    <Opcode>0</Opcode>
    <Keywords>0x8080000000000000</Keywords>
    <TimeCreated SystemTime="2015-08-22T02:57:42.603959300Z" />
    <EventRecordID>46303</EventRecordID>
    <Correlation />
    <Execution ProcessID="508" ThreadID="10960" />
    <Channel>System</Channel>
    <Computer>SERV013.FQDN.com</Computer>
    <Security />
  </System>
  <EventData>
    <Data Name="param1">Windows Internal Database</Data>
    <Data Name="param2">%%1069</Data>
    <Binary>4D005300530051004C0024004D004900430052004F0053004F0046005400230023005700490044000000</Binary>
  </EventData>
</Event>


I know about this TechNet article too

https://technet.microsoft.com/en-us/library/hh831622.aspx

I saw videos online on how to install and setup IPAM but none talk about the internal database


Thoughts
LVL 23
Thomas GrassiSystems AdministratorAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Seth SimmonsSr. Systems AdministratorCommented:
Why can't I unselect the internal database.

it's required when you add the feature
once it's installed, you can click on provision in server manager which is where you have the option to select sql server

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Seth SimmonsSr. Systems AdministratorCommented:
here is a screenshot of where you can change it

ipam
Thomas GrassiSystems AdministratorAuthor Commented:
Seth

Thanks I saw that in the articles and videos.

The big question here is why does the install fail?

The only thing I se is the errors above because the internal
Database adds a bogus user account

The installation should prompt you for more options

All the  videos I saw the install went right in no problem

What prereqs are required maybe I missed a step

Thoughts
Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Seth SimmonsSr. Systems AdministratorCommented:
are you getting an error during the feature install?
Thomas GrassiSystems AdministratorAuthor Commented:
Seth

Yes

The install bar moves across the I get a red X install failed

That's when I then went to the event  viewer and saw the internal db errors

I am logged on to this server as a domain administrator


Thoughts
Thomas GrassiSystems AdministratorAuthor Commented:
this account being created "NT SERVICE\MSSQL$MICROSOFT##WID"  seems to be the issue here.

I was thinking if I added this before hand it might help the install go.

Today I also installed all the other prereqs  DNS Server Tools, DHCP Server Tools, Group Policy Management,

ASP NET 4.5 was already installed this is a web server also.



Now when I try to install IPAM  Feature all that is needed is
Remote Server Administration Tools
     Feature Administration Tools
         Tools IP Address Management IPAM Client
Windows Internal Database


So the problem is with the internal database account being created and not in the logon as a service group that the install fails and requires a server restart and then it is removed and I have to try again.

How to I get past this ?

Thanks
Thomas GrassiSystems AdministratorAuthor Commented:
Seth

figured it out

https://social.technet.microsoft.com/Forums/windowsserver/en-US/ae88de7d-f69f-4cb1-877f-379151d01899/can-not-install-windows-internal-database-wid-windows-server-2012

Add IIS_WPG, Network, Network Service, Service  to Log on As a Service in Default Domain Policy

After doing gpupdate /force  I was able to successfully install IPAM  now off to the configuration


So there are prereqs for installing WID  they should be noted in the install process don't you think?


Thanks for your help

Tom
Thomas GrassiSystems AdministratorAuthor Commented:
Update

I am now provisioned with IPAM

After all that found out that I need SQL Enterprise for IPAM to use SQL I only have Standard SQL 2008.

So now using internal DB
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows Server 2012

From novice to tech pro — start learning today.