Article ID: 116039, created on Apr 30, 2013, last review on May 11, 2014

  • Applies to:
  • Operations Automation

Symptoms


APS task to provision Lync service for a customer fails in POA with the error message "Login failed for user ‘[domain_name]\pem_admin‘.".

Cause


The pem_admin AD user does not have access to the Lync server database.

Resolution


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
where:
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;
GO
EXEC master..sp_addsrvrolemember @loginame = N'DOMAIN_NAME\pem_admin', @rolename = N'sysadmin'
GO
EXIT
Replace the DOMAIN_NAME with the actual NETBIOS name of the AD domain where Lync is deployed.

Note: you may also use SQL Server Management Studio to execute the SQL commands.

caea8340e2d186a540518d08602aa065 5356b422f65bdad1c3e9edca5d74a1ae e12cea1d47a3125d335d68e6d4e15e07

Email subscription for changes to this article
Save as PDF