I have password of my SQL connection as secret key. I assigned this to a key. I need to pass the SQL connection string as an environment variable which assigns value in my appsettings.json file. It was working when I passed a team city variable as password. But when I changed password to secret key, I'm not able to retrieve data from API (Moved to Kubernities). It shows an error login failed for user. How can I pass a connection string in YAML file with password as secret key?

I tried to access the key in several ways but the result was the same.

env:
   - name: SECRET_USERNAME
     valueFrom:
          secretKeyRef:
            name: mysecret
            key: username
    - name: SECRET_PASSWORD
      valueFrom:
          secretKeyRef:
            name: mysecret
            key: password

  -name:ConnectionString
   Value: "server:172.168.0.1; username: ${SECRET_USERNAME};password:${SECRET_PASSWORD};....." 

Please don't mind the indentation here. I have it correctly in the file. How can I access SECRET_PASSWORD here?

The API wants to return success message. But am getting error login failed for user.