I have a remote sql server connection and was in the middle of updating some value with begin and commit tran command. However, before it finished, the query got canceled and the table is locked. After several attempt to restart the database, the table is still locked and then we restarted the machine.
It is worse now that we cannot even connect to the server from management studio. There are few different errors that shows up when I tried to connect such as the connection timeout, server not known and the most common one that shows up is cannot generate SSPI context.
It can't be domain issue since I can connect just fine before on the same network with same user account. Does anyone know how to resolve this?