Background
Trying to install Microsoft SQL Server v2017, but no go.
Error Message
Here is the error message :-
TITLE: Microsoft SQL Server 2017 Setup.
The following error has occurred:
The RPC server is unavailable.
Click ‘Retry’ to retry the failed action, or click ‘Cancel’ to cancel this action and continue setup.
Error Image
Troubleshooting
Looked everywhere on this one.
SysInternals
Process Monitor
Tried SysInternals’ Process Monitor, but no help today.
SQL Server
Setup Log
Reached for Microsoft’s SQL Server Setup Log available here ( C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log\ ).
The specific file that we want to track on is details.txt
Error Text
Slp: Sco: Attempting to open root DirectoryEntry object for local computer
Slp: Sco: Attempting to check if container ‘WinNT://LABSQL01,computer’ of group exists
Slp: Sco: User group Distributed COM Users exists
Slp: Sco: Attempting to get account sid for user account AD\dadeniji
Slp: Sco: Attempting to get sid for user account AD\dadeniji
Slp: Sco: Attempting to get account sid for user account AD
Slp: Sco: Attempting to get sid for user account AD
Slp: Sco: Attempting to see if user AD\dadeniji exists
Slp: Sco.User.OpenRoot – Attempting to get root DirectoryEntry for domain/computer ‘AD’
Slp: Sco: Attempting to check if user account LABDOMAIN\dadeniji exists
Slp: Sco: Attempting to look up AD entry for user LABDOMAIN\dadeniji
Slp: Sco.User.OpenRoot – root DirectoryEntry object already opened for this computer for this object
Slp: Sco.User.LookupADEntry – Attempting to find user account LABDOMAIN\dadeniji
Slp: Sco: Attempting to check if container ‘WinNT://LABDOMAIN’ of user account exists
Slp: Prompting user if they want to retry this action due to the following failure:
Slp: The following is an exception stack listing the exceptions in outermost to innermost order
Slp: Inner exceptions are being indented
Slp:
Slp: Exception type: Microsoft.SqlServer.Configuration.Sco.ScoException
Slp: Message:
Slp: The RPC server is unavailable.
Slp:
Slp: HResult : 0x84bb0001
Slp: FacilityCode : 1211 (4bb)
Slp: ErrorCode : 1 (0001)
Slp: Data:
Slp: WatsonData = Domain
Slp: DisableRetry = true
Slp: Inner exception type: System.Runtime.InteropServices.COMException
Slp: Message:
Slp: The RPC server is unavailable.
Slp:
Slp: HResult : 0x800706ba
Slp: Stack:
Slp: at System.DirectoryServices.DirectoryEntries.Find(String name, String schemaClassName)
Slp: at Microsoft.SqlServer.Configuration.Sco.User.LookupADEntry()
Remediation
Network Configuration Setting
TCP/IP DNS Suffix
The problem ended up being an incomplete DNS Suffixes listing.
You see our server is hosted on AWS and it is an EC2 Instance.
Outline
- Access Advanced TCP/IP Settings
- Launch Control Panel
- Access Network Applet
- Access “Advanced TCP/IP Settings”
- Access DNS Tab
- Review “Append DNS Suffixes” group
- Add corporate DNS suffices
Images
Original Setting