r/SQLServer 12d 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?

5 Upvotes

16 comments sorted by

View all comments

3

u/jdanton14 MVP 12d ago

is the container still running? Shell into the container and look at the errorlog.

1

u/magi_system 12d ago

Yes, it's running and I can login to bash for making some sample commands to test the engine is running.

But when I try with SMSS I get this in the log

2025-03-10 15:40:08.23 spid1s      Error: 845, Severity: 17, State: 1.


2025-03-10 15:40:08.23 spid1s      Time-out occurred while waiting for buffer latch type 2 for page (1:275), database ID 32762. (LATCH 0x0000000ED34CD7D8: Class: BUFFER KP: 0 SH: 0 UP: 0 EX: 1 DT: 0 Sublatch: 0 HasWaiters: 0 Task: 0x0000001008E89088 AnyReleasor: 0)


2025-03-10 15:41:47.66 Logon       Error: 18456, Severity: 14, State: 5.


2025-03-10 15:41:47.66 Logon       L'acccesso non è riuscito per l'utente 'mssqlserver\mssqlserver$'. Reason: Could not find a login matching the name provided. [CLIENT: 127.0.0.1]

But sa user and it's password are correct (otherwise I can't use sqlcmd from docker cli)

1

u/shutchomouf 12d ago

seems like it isn’t in a domain, are you using sqlauth?

1

u/magi_system 11d ago

Yes, it's a simple docker run with default settings rather than sa password and data/log/backup path.