Hello dear community, I'm having some issues installing CA ITCM SP2, when I try to install this error appear,
I'm try installing with the same account of the database, in this case is ca_itrm, and the error still appearing.
Somebody know how to fix this error?
The installer requires "Windows Authentication" of the logged on user, to the local or remote SQL database. The installer does not use the ca_itrm account or any "SQL Authentication" to install the product. Simply put, the logged-on user MUST support Windows Authentication, and MUST BE a SYSADMIN on the SQL server.
If this is the first-time install, the installer will use your Windows Authentication to logon to the database server, and it will create the "mdb" database, as well as create the "ca_itrm" SQL account.
Adding to my reply, Microsoft SQL supports TWO authentication types:
1- Windows Authentication (also known as "Trusted" or "Integrated")
These are simply local user or domain user accounts-- e.g. domain\user. This is essentially SQL server integrating with Windows, to authorize/authenticate users based on local or Windows AD domain accounts, for access control into SQL.
2- SQL Authentication
These are database accounts, in my own words, internal to the SQL server itself. The ITCM installer will create an account called ca_itrm, which will later be used by various CAF plugins, for access to the database.
Authentication in SQL Server | Microsoft Docs
The ITCM installer requires the currently logged-on user to have admin access (sysadmin access), via there Windows Authentication to the SQL server.
After the product is setup, it will run on its own using ca_itrm and SQL authentication. The ca_itrm account is a "public" account with no admin privileges to the SQL server.
The Windows authentication is only required for the setup of the product.
EXCELLENT BRIAN, it works!!! THANKS!!!