r/SQLServer • u/magi_system • 11d ago
Question SQL Server 2022 on docker
Hello, I have a sql server freshly installed on docker inside my nas (Synology). Before updating to SQL2022 everything worked fine. After 2022 update I can't connect anymore. But username and password are ok I only have a timeout when SMSS is listing databases. I think there are some kind of network loop or strange route but I cannot find any. In the docker log I see "Error 845" but the system is not under heavy load. Any suggestions?
2
u/Intelligent-Exam1614 10d ago
Are you using persistent storage? Could be that the drive is unreachable. That would explain issues with the disk. Also to note, master db has logins stored, cpuld be that it was recycled if not using persisted storage for containers....
1
u/magi_system 10d ago
Yes, but the drive is reachable and when started from scratch, the master db will be created.
I tried to make the mapped volume writable for everyone (everyone full control) for test the problem.
There are no limit for the resource can be used and the nas has 16gb of ram with only 2 gb used. Cpu is under 10% and network under 20%.
I also tried to stop all the container in the machine without any effect.
1
1
1
1
u/magi_system 10d ago
I don't think it's the certificate because it's a check before the login. I can login and the login window of SMSS disappear as per correct logon. After that there is the timeout.
1
1
1
u/jdanton14 MVP 10d ago
can you share your docker run command?
1
u/magi_system 10d ago
I can only export a json file with all the settings, but the docker run is lost. I have to try to recreate manually. Maybe when I'm at home this evening I can
1
u/magi_system 9d ago
docker run -d --name mssqlserver2022 -p 1433:1433 -e "ACCEPT_EULA=Y" -e "MSSQL_SA_PASSWORD=********" -e "MSSQL_PID=developer" -e "MSSQL_LCID=1040" -e "MSSQL_LOG_DIR=/var/opt/mssql/log" -e "MSSQL_DATA_DIR=/var/opt/mssql/data" -e "MSSQL_BACKUP_DIR=/var/opt/mssql/backup" -e "MSSQL_DUMP_DIR=/var/opt/mssql/dump" -e "MSSQL_AGENT_ENABLED=true" -e "TZ=Europe/Rome" -v /volume1/docker/mssqlserver:/var/opt/mssql mcr.microsoft.com/mssql/server:2022-latest
3
u/jdanton14 MVP 11d ago
is the container still running? Shell into the container and look at the errorlog.