Working with Database-MSSQL Server (Step 5)- CSI: Troubleshooting in Microsoft SQL Server containers

In this section, I will talk about the problems and solutions I encountered while installing and running the Microsoft SQL Server. I will write the resources and solutions I used to fix the errors. Normally, the “Writing Dockerfiles and Docker compose file for Web app and MS SQL Server” article was next, but due to requests from readers, I gave priority to the “Step-5 CSI: Troubleshooting in Microsoft SQL Server containers” article and published it now.

The errors and solutions we will talk about:

• Error-4: [sqlsrv_errors] => SQLSTATE[HYT00]: [Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired) DB failed to connect.
• Error-1: “sqlcmd: command not found” sqlcmd not available after installing MySQL-tools.
• Error-2: Couldn’t connect to Docker daemon at http+docker://localhost
• Error-3: for PHP can not start service php: driver failed…
• Error-5: /opt/mssql/bin/sqlservr:Error: The system directory [/.system] could not be created. File: LinuxDirectory.cpp:420 [Status: 0xC0000022 Access Denied errno = 0xD(13) Permission denied] devops-task-vero_db_1 exited with code 1.
• Error-6: Login failed for user ‘SA’. Reason: Password did not match that for the login provided. [CLIENT: 127.0.0.1]

As a Result

Next post

References

Note: For more information about Microsoft SQL Server and DataBases, you can read the first article of this series, “Working with Database-1: Introduction Microsoft SQL Server and Explanation of what we will do in this series of articles” at the link here.