Setup is unable to connect to SQL Server with the connection in sccm
SCCM lab troubleshooting step by step to resolve the issues
Error-1
Setup is unable to connect to SQL Server with the connection information provided. Verify the following
1.The SQL SERVER and instance names are entered correctly.
2.The specified SQL SERVER instance is not configured to use dynamic ports.
3.If a firewall is enabled on the SQL server, inbound rules exist to allow connections to the correct ports.
4.The account used to run setup has permission to connect to the specified SQL Server instance.
Error-2
VIEW SERVER STATE permission was denied on object 'server', database, 'master'.
The user does not have permission to perform this action