Forums on Intune, SCCM, and Windows 11

Welcome to the forums. Register a free account today to become a member! Once signed in, you'll be able to participate on this site by adding your topics and posts, as well as connect with other members through your own private inbox!

NEW ERROR: SQL Server service running account and Server TCP Port

  • Thread starter Thread starter adzk75
  • Start date Start date
  • Replies Replies 0
  • Views Views 1K

adzk75

New Member
Messages
1
Reaction score
0
Points
1
Hi all,

I am attempting to install MECM and getting the below 2 failures on pre-req's:

SQL Server service running account - The logon account for the SQL Server service cannot be a local user account, NT SERVICE\<sql service name> or LOCAL SERVICE. You must configure the SQL Server service to use a valid domain account, NETWORK SERVICE, or LOCAL SYSTEM.

SQL Server Tcp port - Configuration Manager primary site and central administration site require SQL Server Tcp is enabled and set to Static port.

I have made sure the SQL Server service account is set to a domain account (DEVLAB\MECM_SA) and restarted the service to apply the setting. I've made this user a Domain User, without any other permissions. I haven't added this user as 'sa' to the SSMS.

I have 'Enabled' the TCP/IP protocol in SQL Server Config Management and set 'IPALL' TCP Port to 1433 and removed any number in 'Dynamic Ports'

Any help is greatly appreciated.
 

Attachments

  • SQLService.GIF
    SQLService.GIF
    20.7 KB · Views: 5
  • TCP_Port.GIF
    TCP_Port.GIF
    40.6 KB · Views: 6
Back
Top