Connection string issue

Using Django Deployment
1

Hi,

I am getting the following error in webpage after deploying in the IIS server (locally hosted).

(‘28000’, "[28000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user ‘<>\<>$’. (18456) (SQLDriverConnect); [28000] [Microsoft][SQL Server Native Client 11.0]Invalid connection string attribute (0);

we are using the following connection in settings.py

DATABASES = {
‘default’: {
‘ENGINE’: ‘sql_server.pyodbc’,
‘NAME’:‘<>’,
‘SERVER’: ‘<>’,
‘DRIVER’: ‘SQL Server Native Client 11.0’,
‘UID’:‘<>’,
‘PWD’:‘<>’,
‘OPTIONS’: {‘driver’: ‘SQL Server Native Client 11.0’,
‘Trusted_Connection’: ‘yes’,}
}
}

we also tried the following combination:
DATABASES = {
‘default’: {
‘ENGINE’: ‘sql_server.pyodbc’,
‘DATABASE’:‘<>’,
‘SERVER’: ‘<>’,
‘DRIVER’: ‘SQL Server Native Client 11.0’,
‘USERNAME’:‘<>’,
‘PASSWORD’:‘<>’,
‘OPTIONS’: {‘driver’: ‘ODBC Driver 17 for SQL Server’,
‘Trusted_Connection’: ‘yes’,}
}
}

The first settings.py did work out in the local development environment but when we deploy it it gave the above error.

we have the SQL instance with mixed mode authentication.

Thanks,
Boomessh V