April 27, 2015 at 4:06 pm
Hey all,
Working with a brand new environment. During install (both SQL 2012 and 2014) on any one of four servers, they all fail on the service accounts page with a "RPC server is unavailable" error and "The SQL Server service account login or password is not valid."
I've verified that RPC server is unavailable is related to only the agent, and the account invalid is only for the engine. Verified this by trying each one separately and putting the other back to default. For the latter (account login or password is not valid), that's definitely not accurate being that I can use that account & password successfully elsewhere.
The best article I've found so far is here - http://sqlwithmanoj.com/tag/the-rpc-server-is-unavailable/.
I've verified all 5 are in place and changed the group policy. Still errors out every time. Even if I can fix the RPC issue, not sure what's wrong with the engine account? I think both issues still stem back to the RPC, even though the engine doesn't report it in the setup. In the detail log, I'm assuming "Slp: Sco.User.OpenRoot - root DirectoryEntry object already opened for this computer for this object" is the core of my problem.
Here's a full output of a failed run:
(08) 2015-04-27 18:28:19 Slp: Sco: Attempting to determine if the password is required for account 'MyDomain\svcSQLEngine'
(08) 2015-04-27 18:28:19 Slp: Sco: Attempting to determine if the account 'MyDomain\svcSQLEngine' is Virtual Account
(08) 2015-04-27 18:28:19 Slp: Sco: Attempting to get account sid for user account MyDomain\svcSQLEngine
(08) 2015-04-27 18:28:19 Slp: Sco: Attempting to get sid for user account MyDomain\svcSQLEngine
(08) 2015-04-27 18:28:19 Slp: Sco: GetSidForAccount normalized accountName MyDomain\svcSQLEngine parameter to MyDomain\svcSQLEngine
(08) 2015-04-27 18:28:19 Slp: Sco: Attempting to determine if the account 'MyDomain\svcSQLEngine' is Managed Service Account
(08) 2015-04-27 18:28:25 Slp: Sco: Attempting to determine if the password is required for account 'MyDomain\svcSQLAgent'
(08) 2015-04-27 18:28:25 Slp: Sco: Attempting to determine if the account 'MyDomain\svcSQLAgent' is Virtual Account
(08) 2015-04-27 18:28:25 Slp: Sco: Attempting to get account sid for user account MyDomain\svcSQLAgent
(08) 2015-04-27 18:28:25 Slp: Sco: Attempting to get sid for user account MyDomain\svcSQLAgent
(08) 2015-04-27 18:28:25 Slp: Sco: GetSidForAccount normalized accountName MyDomain\svcSQLAgent parameter to MyDomain\svcSQLAgent
(08) 2015-04-27 18:28:25 Slp: Sco: Failed when querying buffer size
(08) 2015-04-27 18:28:25 Slp: Sco: Attempting to determine if the account 'MyDomain\svcSQLAgent' is Managed Service Account
(03) 2015-04-27 18:28:27 ACE: Normalizing user input on public configuration object.
(03) 2015-04-27 18:28:27 ACE: Formatting user name 'MyDomain\svcSQLAgent'
(03) 2015-04-27 18:28:27 Slp: Sco: Attempting to get account sid for user account MyDomain\svcSQLAgent
(03) 2015-04-27 18:28:27 Slp: Sco: Attempting to get sid for user account MyDomain\svcSQLAgent
(03) 2015-04-27 18:28:27 Slp: Sco: GetSidForAccount normalized accountName MyDomain\svcSQLAgent parameter to MyDomain\svcSQLAgent
(03) 2015-04-27 18:28:27 Slp: Sco: Failed when querying buffer size
(03) 2015-04-27 18:28:27 Slp: Sco: Attempting to get account sid for user account MyDomain
(03) 2015-04-27 18:28:27 Slp: Sco: Attempting to get sid for user account MyDomain
(03) 2015-04-27 18:28:27 Slp: Sco: GetSidForAccount normalized accountName MyDomain parameter to MyDomain
(03) 2015-04-27 18:28:27 ACE: Formatted user name is 'MyDomain\svcSQLAgent'
(03) 2015-04-27 18:28:27 ACE: Can't get InstanceName, fall back to INSTANCENAME input setting value
(03) 2015-04-27 18:28:27 ACE: Got instanceName=MSSQLSERVER
(03) 2015-04-27 18:28:27 ACE: ValidateUserNameAndPassword started with userName = 'MyDomain\svcSQLAgent', userNameRequired = 'True', isCluster = 'False'
(03) 2015-04-27 18:28:27 ACE: Validating username 'MyDomain\svcSQLAgent' and password '***'
(03) 2015-04-27 18:28:27 Slp: Sco: Attempting to validate credentials for user account 'MyDomain\svcSQLAgent' and service name 'SQLSERVERAGENT'
(03) 2015-04-27 18:28:27 Slp: Sco: Attempting to determine if the account 'MyDomain\svcSQLAgent' is Virtual Account
(03) 2015-04-27 18:28:27 Slp: Sco: Attempting to get account sid for user account MyDomain\svcSQLAgent
(03) 2015-04-27 18:28:27 Slp: Sco: Attempting to get sid for user account MyDomain\svcSQLAgent
(03) 2015-04-27 18:28:27 Slp: Sco: GetSidForAccount normalized accountName MyDomain\svcSQLAgent parameter to MyDomain\svcSQLAgent
(03) 2015-04-27 18:28:27 Slp: Sco: Failed when querying buffer size
(03) 2015-04-27 18:28:27 Slp: Sco: Attempting to see if user MyDomain\svcSQLAgent exists
(03) 2015-04-27 18:28:27 Slp: Sco.User.OpenRoot - root DirectoryEntry object already opened for this computer for this object
(03) 2015-04-27 18:28:27 Slp: Sco: Attempting to check if user account MyDomain\svcSQLAgent exists
(03) 2015-04-27 18:28:27 Slp: Sco: Attempting to look up AD entry for user MyDomain\svcSQLAgent
(03) 2015-04-27 18:28:27 Slp: Sco.User.OpenRoot - root DirectoryEntry object already opened for this computer for this object
(03) 2015-04-27 18:28:27 Slp: Sco.User.LookupADEntry - Attempting to find user account MyDomain\svcSQLAgent
(03) 2015-04-27 18:28:27 Slp: Sco: Attempting to check if container 'WinNT://MyDomain' of user account exists
(03) 2015-04-27 18:28:29 ACE: The credentials you provided for the SQL Server Agent service are invalid. To continue, provide a valid account and password for the SQL Server Agent service.
(03) 2015-04-27 18:28:29 SQLBrowser: StartMethod Type='SqlBrowserPublicConfig' Method='ValidateSettings'.
(03) 2015-04-27 18:28:29 SQLBrowser: Validating intended SQL Server Browser service properties. The current intended values are: service account = 'NT AUTHORITY\LOCAL SERVICE', start type = 'Disabled' (source: 'Default').
(03) 2015-04-27 18:28:29 SQLBrowser: StartMethod Type='SqlBrowserPublicConfig' Method='ValidateUserNamePassword'.
(03) 2015-04-27 18:28:29 SQLBrowser: ValidateUserNamePassword: UserName contains its default value of 'NT AUTHORITY\LOCAL SERVICE'. Setting internal property ApplyAccount to 'True'.
(03) 2015-04-27 18:28:29 Slp: Sco: Attempting to get local service account name
(03) 2015-04-27 18:28:29 Slp: Sco: Attempting to get NT account from sid S-1-5-19
(03) 2015-04-27 18:28:29 Slp: Sco: Attempting to get account from sid S-1-5-19
(03) 2015-04-27 18:28:29 Slp: Sco: Attempting to get local service account name
(03) 2015-04-27 18:28:29 Slp: Sco: Attempting to get NT account from sid S-1-5-19
(03) 2015-04-27 18:28:29 Slp: Sco: Attempting to get account from sid S-1-5-19
(03) 2015-04-27 18:28:29 Slp: Sco: Attempting to get account sid for user account NT AUTHORITY\LOCAL SERVICE
(03) 2015-04-27 18:28:29 Slp: Sco: Attempting to get sid for user account NT AUTHORITY\LOCAL SERVICE
(03) 2015-04-27 18:28:29 Slp: Sco: GetSidForAccount normalized accountName NT AUTHORITY\LOCAL SERVICE parameter to NT AUTHORITY\LOCAL SERVICE
(03) 2015-04-27 18:28:29 SQLBrowser: EndMethod Type='SqlBrowserPublicConfig' Method='ValidateUserNamePassword'.
(03) 2015-04-27 18:28:29 SQLBrowser: StartMethod Type='SqlBrowserPublicConfig' Method='ValidateStartMode'.
(03) 2015-04-27 18:28:29 SQLBrowser: EndMethod Type='SqlBrowserPublicConfig' Method='ValidateStartMode'.
(03) 2015-04-27 18:28:29 SQLBrowser: EndMethod Type='SqlBrowserPublicConfig' Method='ValidateSettings'.
(03) 2015-04-27 18:28:29 SQLEngine: : Action Scenario: Install, Feature Scenario: Install, Resolved Scenario Install
(03) 2015-04-27 18:28:29 Slp: Sco: Attempting to get account sid for user account MyDomain\svcSQLEngine
(03) 2015-04-27 18:28:29 Slp: Sco: Attempting to get sid for user account MyDomain\svcSQLEngine
(03) 2015-04-27 18:28:29 Slp: Sco: GetSidForAccount normalized accountName MyDomain\svcSQLEngine parameter to MyDomain\svcSQLEngine
(03) 2015-04-27 18:28:29 Slp: Sco: Attempting to get account sid for user account MyDomain
(03) 2015-04-27 18:28:29 Slp: Sco: Attempting to get sid for user account MyDomain
(03) 2015-04-27 18:28:29 Slp: Sco: GetSidForAccount normalized accountName MyDomain parameter to MyDomain
(03) 2015-04-27 18:28:29 SQLEngine: --EffectiveProperties: Dumping Effective Properties for new instance.
(03) 2015-04-27 18:28:29 SQLEngine: --EffectiveProperties: InstanceId = MSSQL11.MSSQLSERVER
(03) 2015-04-27 18:28:29 SQLEngine: --EffectiveProperties: InstanceName = MSSQLSERVER
(03) 2015-04-27 18:28:29 SQLEngine: --EffectiveProperties: IsDefaultInstance = True
(03) 2015-04-27 18:28:29 SQLEngine: --EffectiveProperties: SqlServerServiceName = MSSQLSERVER
(03) 2015-04-27 18:28:29 SQLEngine: --EffectiveProperties: IsExpressSku = False
(03) 2015-04-27 18:28:29 SQLEngine: --InstallProperties: Dumping Install Properties
(03) 2015-04-27 18:28:29 SQLEngine: --InstallProperties: EnableRanu = False
(03) 2015-04-27 18:28:29 SQLEngine: --InstallProperties: SecurityMode =
(03) 2015-04-27 18:28:29 SQLEngine: --InstallProperties: LoginMode = 1
(03) 2015-04-27 18:28:29 SQLEngine: --InstallProperties: SqlCollation = SQL_Latin1_General_CP1_CI_AS
(03) 2015-04-27 18:28:29 SQLEngine: --InstallProperties: SqlAdminAcounts =
(03) 2015-04-27 18:28:29 SQLEngine: --InstallProperties: SqlServiceStartupType = Automatic
(03) 2015-04-27 18:28:29 SQLEngine: --InstallProperties: SqlAccount = MyDomain\svcSQLEngine
(03) 2015-04-27 18:28:29 SQLEngine: --InstallProperties: AddCurrentUserAsSQLAdmin = False
(03) 2015-04-27 18:28:29 SQLEngine: --PublicBasedDirectoryProperties: Dumping Directory Propreties
(03) 2015-04-27 18:28:29 SQLEngine: --PublicBasedDirectoryProperties: DataRootDirectory = C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL
(03) 2015-04-27 18:28:29 SQLEngine: --PublicBasedDirectoryProperties: SystemDataDirectory = C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA
(03) 2015-04-27 18:28:29 SQLEngine: --PublicBasedDirectoryProperties: InstallSqlInstanceDir = C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL
(03) 2015-04-27 18:28:29 SQLEngine: --PublicBasedDirectoryProperties: DefaultDataDirectory = C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA
(03) 2015-04-27 18:28:29 SQLEngine: --PublicBasedDirectoryProperties: DefaultLogDirectory = C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA
(03) 2015-04-27 18:28:29 SQLEngine: --PublicBasedDirectoryProperties: BackupDirectory = C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup
(03) 2015-04-27 18:28:29 SQLEngine: --PublicBasedDirectoryProperties: TempDbDirectory = C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA
(03) 2015-04-27 18:28:29 SQLEngine: --PublicBasedDirectoryProperties: TempDbLogDirectory = C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA
(03) 2015-04-27 18:28:29 SQLEngine: --PublicBasedDirectoryProperties: ErrorLogDirectory = C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Log
(03) 2015-04-27 18:28:29 SQLEngine: --PublicBasedDirectoryProperties: TemplateDataDirectory = C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Template Data
(03) 2015-04-27 18:28:29 SQLEngine: --PublicBasedDirectoryProperties: SqlInstanceBinnDir = C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn
(03) 2015-04-27 18:28:29 SQLEngine: --PublicBasedDirectoryProperties: SqlInstanceTemplatesDir = C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\Templates
(03) 2015-04-27 18:28:29 SQLEngine: --PublicBasedDirectoryProperties: MasterDbPath =
(03) 2015-04-27 18:28:29 SQLEngine: --PublicBasedDirectoryProperties: MasterLogPath =
(03) 2015-04-27 18:28:29 SQLEngine: --InputValidator: --- Validating Engine Settings ---
(03) 2015-04-27 18:28:29 SQLEngine: --InputValidator: Engine: Validating StartMode
(03) 2015-04-27 18:28:29 SQLEngine: --InputValidator: Engine: Validating FileStreamLevel : FILESTREAMLEVEL is 0
(03) 2015-04-27 18:28:29 SQLEngine: --InputValidator: Engine: Validating FileStreamSharename : No sharename specified
(03) 2015-04-27 18:28:29 SQLEngine: --InputValidator: Engine: Validating EnableRanu
(03) 2015-04-27 18:28:29 SQLEngine: --InputValidator: Validating SqlCollation
(03) 2015-04-27 18:28:29 SQLEngine: --InputValidator: SqlCollation = SQL_Latin1_General_CP1_CI_AS
(03) 2015-04-27 18:28:29 SQLEngine: --InputValidator: SqlCollation 'SQL_Latin1_General_CP1_CI_AS' is valid.
(03) 2015-04-27 18:28:29 SQLEngine: --InputValidator: Engine : Validating Service Account
(03) 2015-04-27 18:28:29 SQLEngine: --InputValidator: SQLEngine : Validating Engine Service Account
(03) 2015-04-27 18:28:29 Slp: Sco: Attempting to determine if the account 'MyDomain\svcSQLEngine' is Virtual Account
(03) 2015-04-27 18:28:29 Slp: Sco: Attempting to determine if the account 'MyDomain\svcSQLEngine' is Managed Service Account
(03) 2015-04-27 18:28:29 SQLEngine: --InputValidator: Engine : Attempting to get account sid for account MyDomain\svcSQLEngine
(03) 2015-04-27 18:28:29 Slp: Sco: Attempting to get account sid for user account MyDomain\svcSQLEngine
(03) 2015-04-27 18:28:29 Slp: Sco: Attempting to get sid for user account MyDomain\svcSQLEngine
(03) 2015-04-27 18:28:29 Slp: Sco: GetSidForAccount normalized accountName MyDomain\svcSQLEngine parameter to MyDomain\svcSQLEngine
(03) 2015-04-27 18:28:29 Slp: Sco: Attempting to get account from sid S-1-5-21-2005767751-3441520766-2436301181-2505
(03) 2015-04-27 18:28:29 Slp: Sco: Attempting to initialize user group MyDomain\svcSQLEngine
(03) 2015-04-27 18:28:29 Slp: Sco: Attempting to get account sid for user account MyDomain
(03) 2015-04-27 18:28:29 Slp: Sco: Attempting to get sid for user account MyDomain
(03) 2015-04-27 18:28:29 Slp: Sco: GetSidForAccount normalized accountName MyDomain parameter to MyDomain
(03) 2015-04-27 18:28:29 Slp: Sco: Attempting to check if user group svcSQLEngine exists
(03) 2015-04-27 18:28:29 Slp: Sco: Attempting to open root DirectoryEntry object for domain/computer 'MyDomain'
(03) 2015-04-27 18:28:29 Slp: Sco: Attempting to check if container 'WinNT://MyDomain' of group exists
(03) 2015-04-27 18:28:29 Slp: Sco: User group svcSQLEngine doesn't exist
(03) 2015-04-27 18:28:29 Slp: Sco: Attempting to get account sid for user account MyDomain\svcSQLEngine
(03) 2015-04-27 18:28:29 Slp: Sco: Attempting to get sid for user account MyDomain\svcSQLEngine
(03) 2015-04-27 18:28:29 Slp: Sco: GetSidForAccount normalized accountName MyDomain\svcSQLEngine parameter to MyDomain\svcSQLEngine
(03) 2015-04-27 18:28:29 Slp: Sco: Attempting to get account sid for user account MyDomain\svcSQLEngine
(03) 2015-04-27 18:28:29 Slp: Sco: Attempting to get sid for user account MyDomain\svcSQLEngine
(03) 2015-04-27 18:28:29 Slp: Sco: GetSidForAccount normalized accountName MyDomain\svcSQLEngine parameter to MyDomain\svcSQLEngine
(03) 2015-04-27 18:28:29 Slp: Sco: Attempting to get account sid for user account MyDomain
(03) 2015-04-27 18:28:29 Slp: Sco: Attempting to get sid for user account MyDomain
(03) 2015-04-27 18:28:29 Slp: Sco: GetSidForAccount normalized accountName MyDomain parameter to MyDomain
(03) 2015-04-27 18:28:29 SQLEngine: --InputValidator: Engine : Service Acccount Specified, Validating Password
(03) 2015-04-27 18:28:29 Slp: Sco: Attempting to validate credentials for user account 'MyDomain\svcSQLEngine' and service name 'MSSQLSERVER'
(03) 2015-04-27 18:28:29 Slp: Sco: Attempting to determine if the account 'MyDomain\svcSQLEngine' is Virtual Account
(03) 2015-04-27 18:28:29 Slp: Sco: Attempting to get account sid for user account MyDomain\svcSQLEngine
(03) 2015-04-27 18:28:29 Slp: Sco: Attempting to get sid for user account MyDomain\svcSQLEngine
(03) 2015-04-27 18:28:29 Slp: Sco: GetSidForAccount normalized accountName MyDomain\svcSQLEngine parameter to MyDomain\svcSQLEngine
(03) 2015-04-27 18:28:29 Slp: Sco: Attempting to see if user MyDomain\svcSQLEngine exists
(03) 2015-04-27 18:28:29 Slp: Sco.User.OpenRoot - root DirectoryEntry object already opened for this computer for this object
(03) 2015-04-27 18:28:29 Slp: Sco: Attempting to check if user account MyDomain\svcSQLEngine exists
(03) 2015-04-27 18:28:29 Slp: Sco: Attempting to look up AD entry for user MyDomain\svcSQLEngine
(03) 2015-04-27 18:28:29 Slp: Sco.User.OpenRoot - root DirectoryEntry object already opened for this computer for this object
(03) 2015-04-27 18:28:29 Slp: Sco.User.LookupADEntry - Attempting to find user account MyDomain\svcSQLEngine
(03) 2015-04-27 18:28:29 Slp: Sco: Attempting to check if container 'WinNT://MyDomain' of user account exists
(03) 2015-04-27 18:28:29 SQLEngine: --InputValidator: Engine: Validation for account MyDomain\svcSQLEngine failed. The RPC server is unavailable.
Never seen this before, any suggestions?
Thanks
April 28, 2015 at 5:30 am
Do you have any entries in Eventlog? Is it a domain account you want to add here?
April 28, 2015 at 5:39 am
Nothing worthwhile in the event log. The output from the setup is definitely more detailed.
Yes, domain account.
April 28, 2015 at 6:32 am
The account and credentials you provided for the SQL Server Agent service are invalid. try using the default services account configuration during the SQL Server setup and update services account after installation is completed.
SQL 2000/2005/2008/2012 DBA - MCTS/MCITP
April 28, 2015 at 6:34 am
Hi Ken, what do you mean by not valid? The account authenticates as I've verified its credentials in multiple other locations.
At this time yeah, I'm going to simply use the defaults and update later. To confirm (as I've never had to go this route) using SQL config manager will grant all the appropriate file system permissions post changing correct?
Thanks
April 28, 2015 at 9:34 am
As Kenneth says - the installer is unable to verify the accountname/pwd. Is server in domain since this combination has worked before?
April 28, 2015 at 9:36 am
Yep, same domain.
If I grant the account access to RDP to any of the servers in question where I'm attempting to install SQL, it logs in without issue. So at a bit of a loss.
For now, I simply used the default local and switched after install, worked without issue. Still, need to understand why this is happening and how to resolve.
Thanks
April 28, 2015 at 2:48 pm
I've had some issues earlier (think it was sql 2005). I first installed client components - patched with sp3 (which then was the latest) and then installed the database engine. I belive this was cluster. Maybe worth a try?
So install SQL 2012 client components + sp2. Install db engine and patch with sp2.
September 18, 2015 at 12:29 pm
Did you ever get to the bottom of this issue? I'm experiencing the same problem with a SQL 2014 installation. Interestingly a clustered install works just fine, but a standalone local install does not. I think it may be related to the fact that the service account is from a different (trusted) domain to the machine itself. Next step is to play around with some DNS settings.
May 18, 2016 at 2:17 pm
Hi,
Had this same problem and was able to resolve it by adding tweaking the advanced dns settings on the network adapter so that the machine's fqdn suffix was being added to the ones appended for unqualified names.
Whoever had setup the VM that I was working on had entered some odd settings for cloud virtualization that didn't quite mesh with the machine name.
Hope this may be of use to someone else!
Dave
May 20, 2016 at 5:52 pm
If you are installing anything below SQL 2014 then the SQLAgent account is the first account that gets validated. If it comes up with an error this may mean the account is invalid, but it can also mean you have a problem contacting your domain controller.
If you verify that the account and password are OK, then you need to direct your troubleshooting around comms issues between the serve and the domain controller.
Dave has identified one possible problem and its solution. Even two years ago (2014) you did not need to put the fdqn into the adapter settings to get the comms to the domain controller working, but today it seems that it is necessary.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply