Why SQL server authentication is only available for connecting to Database Engine but grayed out for rest of all services, AS, RS and IS?
I am on SQL Server 2012.
How can I enable the sa login to AS, RS and IS?
Server Fault is a question and answer site for system and network administrators. It only takes a minute to sign up.Sign up to join this community
Analysis and Integration services only use Windows Authentication. SQL Server Reporting Services would require different configuration to handle different authentication. More detail can be found by clicking on the service links. As such, sa is a SQL Server authentication and cannot be used for logging into those services.