failed to instantiate StorageService (mssql): ODBC StorageService failed to connect to database

[Thomas Rudolf]

Dear all,

I am trying to use a MSSql DB as session storage for SP2, using this connection string (shibb & db are containerized using docker):

DRIVER=freetds;SERVER=mssql;UID=<user>;PWD=<password>;DATABASE=shibboleth;APP=shibboleth

For some reason this will yield me the following error:

failed to instantiate StorageService (mssql): ODBC StorageService failed to connect to database

Verifying the DB connection with tsql:

bash-4.4$ tsql -H mssql -p 1433 -U <user> -P <password> -D shibboleth

yields a connection & console.

Can anybody please advise how to debug this (get a more verbose error output) or point me to some obvious issue?

Best,
Thomas
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://shibboleth.net/pipermail/users/attachments/20211013/7c271dfc/attachment.htm>