The "SQL Server Error 2: Cannot connect to local" typically indicates that the SQL Server service is not running or there’s an issue with the server instance name. In this video I demonstrated the steps to troubleshoot and resolve the issue.
Add new user role in sql server
• Login failed for user 'NT AUTHORITY\S...