You need to provide a group of users from the IT and Manufacturing departments the minimum administrative rights to view database information and server state for the Manufacturing database on…

Database roles grant permissions only within a specific database and cannot be used to view server-level information like 'server state'.

Server roles in SQL Server grant permissions at the server level, which is necessary to view server state and information about all databases on the instance. Permissions such as `VIEW SERVER STATE` and `VIEW ANY DATABASE` are server-scoped and are appropriately managed by assigning users or groups to server roles, providing the required access across the server instance.

A Shared SQL Server Login is an authentication principal, an identity for connecting to SQL Server, not a mechanism for assigning permissions or administrative rights.

A Local Security Group is an operating system construct and does not directly grant permissions within SQL Server; while Windows groups can be mapped to SQL Server logins, configuring the group itself doesn't assign SQL Server permissions.