i am going to install Service Management 14.1 with MS SQL.
Client have the policy to not use the SQL mix mode authentication.
can we use the SQL windows authentication Mode.
if we can not use the mix mode then there is any explanation for justification.
SQL Server 2008 R2 Setup. Mixed authentication mode is mandatory.
We require mixed mode for the install.
During setup, you must select an authentication mode for the Database Engine. There are two possible modes:
Windows Authentication mode and mixed mode. Windows Authentication mode enables Windows Authentication and disables SQL Server Authentication.
Mixed mode enables both Windows Authentication and SQL Server Authentication. Windows Authentication is always available and cannot be disabled.
Mixed Mode Authentication during setup, you must provide and then confirm a strong password for the built-in SQL Server system administrator account named sa. The sa account connects by using SQL Server Authentication. We require ‘sa’ or ‘administrator’ rights to create the mdb.
Hello Arif, arimu02
Please let us know if this answers your question on sql server mixed mode authentication.
As per the client Policy they are allowed to use only SQL windows authentication.
is there any other way that we can use the windows authenticate mode only.
client going to use CA Service Management solution.
Client is using windows 2012 / SQL 2012 and CASM 14.1
I have confirmed with our Development that ITAM requires Mixed mode authentication for an install and to run the application. There is no support for Windows Authentication Mode.
Client is using CA Service Desk and CA Service Catalog with CABI and PAM
also client have the below question.
can any one give the answer on below.
Action Item – CA team to provide report on challenges of implementing Windows authentication with supporting evidence (including screenshots) to the IT governance team in order to approve the super user access form.
Action Item – ITSM team (CA) to provide a solution which address below governance team concerns.