This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hi
I haver posted that before but I dont got really good answer. I trying to install SCCM Site server, error:
The SQL Server name specified is configured for SQL authentication security. It is recommended to configure the SQL Server to operate only in Windows authentication security before you continue Configuration Manager Setup.
XXX; SQL Server security mode; Warning; The SQL Server name specified is configured for SQL authentication security. It is recommended to configure the SQL Server to operate only in Windows authentication security before you continue Configuration Manager Setup.
I have installed SQL server on another server and Site Server there is WSUS installed that pointed to SQL Server.
SQL Server and Site server have that open ports:
8531 TCP Any (null)
8530 TCP Any (null)
1688 TCP Any (null)
8530 TCP Any (null)
2701 TCP Any (null)
445 TCP Any (null)
443 TCP Any (null)
4022 TCP Any (null)
1433 TCP Any (null)
1434 UDP Any (null)
32400 TCP Any (null)
135 TCP Any (null)
I have also that settings with SQL:
Error
Any idea what I can do ?
You log snipit show firewall check not sql security mode, review those log snipits. Btw it is just a warning, you can ignore it if you like.
INFO: 'SqlServer.XXX.org' is a valid FQDN. Configuration Manager Setup 2023-01-06 20:36:52 2040 (0x07F8)
Installing service SMS_SERVER_BOOTSTRAP_SCCMSite.XXX.org_SMS_SQL_SERVER on remote server SqlServer.XXX.org ... Configuration Manager Setup 2023-01-06 20:37:15 2040 (0x07F8)
Installed service SMS_SERVER_BOOTSTRAP_SCCMSite.XXX.org_SMS_SQL_SERVER on remote server SqlServer.XXX.org Configuration Manager Setup 2023-01-06 20:37:36 2040 (0x07F8)
Starting service SMS_SERVER_BOOTSTRAP_SCCMSite.XXX.org_SMS_SQL_SERVER with command-line arguments "SOK D:\SMS_SCCMSite.XXX.org_SMS_SQL_SERVER0 /createcertificate SOFTWARE\MicrosoftCertBootStrap\ SMS_SQL_SERVER"... Configuration Manager Setup 2023-01-06 20:37:36 2040 (0x07F8)
Could not start service SMS_SERVER_BOOTSTRAP_SCCMSite.XXX.org_SMS_SQL_SERVER. The operating system reported error 1008: Configuration Manager Setup 2023-01-06 21:36:19 2040 (0x07F8)
ERROR: Failed to create SQL Server certificate on server SqlServer.XXX.org Configuration Manager Setup 2023-01-06 21:36:19 2040 (0x07F8)
ERROR: Failed to create SQL Server [SqlServer.XXX.org] certificate remotely. Configuration Manager Setup 2023-01-06 21:36:19 2040 (0x07F8)
Not recovery mode or not top level site. Skip restoring client piloting packages. Configuration Manager Setup 2023-01-06 21:36:19 2040 (0x07F8)
~===================== Completed Configuration Manager Server Setup ===================== Configuration Manager Setup 2023-01-06 21:36:19 2040 (0x07F8)
I have SQL Server 2017 , SCCM 2002 and Windows Server 2022. Maybe I will try with a newer SCCM edition ?
// :-)
Ok, I will bite, why use an old version of configmgr? Why use a old version of sql? Did you look up the error messages listed with the log?
Hi
I have now trying with SQL Server 2019 and with SCCM CB 2210 but I have got same error ,
Any Idea ?
It is not the same error, it shows that it can't logon to sql now. Check the permission within sql.
![277868-error-install.jpg][1]
I know its about the security , something I have missed ?
SQL Server
// :-)
It tells you exactly which account can't logon to SQL, you blacked it out.
Your account require full SQL Admin too.
You wrote Your account require full SQL Admin too.
My admin account have sysadmin , :-)
// :-)
Have you used SSMS to connect to SQL using that account?
Yes , of course .. And it's look great
Admin account have SYSADMIN and is owner to SUSDB (WSUS)
:-)
Did you enable named pipes on SQL?
and on the 32 bit connection too?
