I have an Azure used within a SQL Server database. I want to login using that user to run some database commands using azure-active-directory-password
. At the moment it says my user or password is incorrect but I can connect with Azure Data Studio as shown below:
my code is currently:
<code>const sqlConfiguration = {
server: dbConnection.server,
port: dbConnection.port,
database: dbConnection.database,
authentication: {
type: 'azure-active-directory-password',
options: {
user: dbConnection.user,
password: dbConnection.password,
clientId: dbConnection.clientId,
tenantId: dbConnection.tenantId,
},
},
options: {
encrypt: true,
enableArithAbort: false,
abortTransactionOnError: true,
trustServerCertificate: true,
},
};
connectionPool = await new sql.ConnectionPool(sqlConfiguration).connect();
</code>
<code>const sqlConfiguration = {
server: dbConnection.server,
port: dbConnection.port,
database: dbConnection.database,
authentication: {
type: 'azure-active-directory-password',
options: {
user: dbConnection.user,
password: dbConnection.password,
clientId: dbConnection.clientId,
tenantId: dbConnection.tenantId,
},
},
options: {
encrypt: true,
enableArithAbort: false,
abortTransactionOnError: true,
trustServerCertificate: true,
},
};
connectionPool = await new sql.ConnectionPool(sqlConfiguration).connect();
</code>
const sqlConfiguration = {
server: dbConnection.server,
port: dbConnection.port,
database: dbConnection.database,
authentication: {
type: 'azure-active-directory-password',
options: {
user: dbConnection.user,
password: dbConnection.password,
clientId: dbConnection.clientId,
tenantId: dbConnection.tenantId,
},
},
options: {
encrypt: true,
enableArithAbort: false,
abortTransactionOnError: true,
trustServerCertificate: true,
},
};
connectionPool = await new sql.ConnectionPool(sqlConfiguration).connect();
The error is:
ConnectionError: Security token could not be authenticated or authorized. Description: AADSTS50126: Error validating credentials due to invalid username or password.
4