Symptoms
vCenter Configuration Manager Console login page appears but when the Login button is clicked you receive this error message:
Your ID has either not been created in VCM, or you have no current VCM roles.
Error Message:
Unknown Error
Resolution
This issue occurs if the advanced SQL configuration option Ole Automation Procedures is disabled.
The VCM console relies heavily on SQL servers ability to create automation objects. To resolve this issue, run these statements in SSMS:
sp_configure ‘show advanced options’, 1
GO
RECONFIGURE;
GO
sp_configure ‘Ole Automation Procedures’, 1
GO
RECONFIGURE;
GO
sp_configure ‘show advanced options’, 0
GO
RECONFIGURE;
sp_configure ‘show advanced options’, 1
GO
RECONFIGURE;
GO
sp_configure ‘Ole Automation Procedures’, 1
GO
RECONFIGURE;
GO
sp_configure ‘show advanced options’, 0
GO
RECONFIGURE;