Member_2_6492660_1
asked on
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##W ID 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##W ID
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-26931 d2012f4}" EventSourceName="Service Control Manager" />
<EventID Qualifiers="49152">7041</E ventID>
<Version>0</Version>
<Level>2</Level>
<Task>0</Task>
<Opcode>0</Opcode>
<Keywords>0x80800000000000 00</Keywor ds>
<TimeCreated SystemTime="2015-08-22T02: 57:42.6039 59300Z" />
<EventRecordID>46302</Even tRecordID>
<Correlation />
<Execution ProcessID="508" ThreadID="10960" />
<Channel>System</Channel>
<Computer>SERV013.FQDN.com </Computer >
<Security />
</System>
<EventData>
<Data Name="param1">MSSQL$MICROS OFT##WID</ Data>
<Data Name="param2">NT SERVICE\MSSQL$MICROSOFT##W ID</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-26931 d2012f4}" EventSourceName="Service Control Manager" />
<EventID Qualifiers="49152">7000</E ventID>
<Version>0</Version>
<Level>2</Level>
<Task>0</Task>
<Opcode>0</Opcode>
<Keywords>0x80800000000000 00</Keywor ds>
<TimeCreated SystemTime="2015-08-22T02: 57:42.6039 59300Z" />
<EventRecordID>46303</Even tRecordID>
<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>4D005300530051004C 0024004D00 4900430052 004F005300 4F00460054 0023002300 5700490044 000000</Bi nary>
</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
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##W
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##W
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-
<EventID Qualifiers="49152">7041</E
<Version>0</Version>
<Level>2</Level>
<Task>0</Task>
<Opcode>0</Opcode>
<Keywords>0x80800000000000
<TimeCreated SystemTime="2015-08-22T02:
<EventRecordID>46302</Even
<Correlation />
<Execution ProcessID="508" ThreadID="10960" />
<Channel>System</Channel>
<Computer>SERV013.FQDN.com
<Security />
</System>
<EventData>
<Data Name="param1">MSSQL$MICROS
<Data Name="param2">NT SERVICE\MSSQL$MICROSOFT##W
</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-
<EventID Qualifiers="49152">7000</E
<Version>0</Version>
<Level>2</Level>
<Task>0</Task>
<Opcode>0</Opcode>
<Keywords>0x80800000000000
<TimeCreated SystemTime="2015-08-22T02:
<EventRecordID>46303</Even
<Correlation />
<Execution ProcessID="508" ThreadID="10960" />
<Channel>System</Channel>
<Computer>SERV013.FQDN.com
<Security />
</System>
<EventData>
<Data Name="param1">Windows Internal Database</Data>
<Data Name="param2">%%1069</Data
<Binary>4D005300530051004C
</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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
are you getting an error during the feature install?
ASKER
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
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
ASKER
this account being created "NT SERVICE\MSSQL$MICROSOFT##W ID" 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
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
ASKER
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
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
ASKER
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
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
ASKER
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