APS task to provision Lync service for a customer fails in POA with the error message "Login failed for user ‘[domain_name]\pem_admin‘.".
The pem_admin AD user does not have access to the Lync server database.
Follow the steps below to resolve the problem.
On the required MS SQL Server host, run Command Prompt: Start > Run > cmd.exe.
Execute the command:
sqlcmd.exe -S SERVER_NAME\INSTANCE_NAME
SERVER_NAME is the hostname, NETBIOS name or IP Address of the MS SQL Server or MS SQL Server Cluster
INSTANCE_NAME is the name of the MS SQL Server instance
Execute the following SQL queries:
CREATE LOGIN [DOMAIN_NAME\pem_admin] FROM WINDOWS;Replace the DOMAIN_NAME with the actual NETBIOS name of the AD domain where Lync is deployed.
EXEC master..sp_addsrvrolemember @loginame = N'DOMAIN_NAME\pem_admin', @rolename = N'sysadmin'
Note: you may also use SQL Server Management Studio to execute the SQL commands.