My server crashed due to SQL writing a lot of trace files, which filled the server disk, and caused the server to crash.
So my first question is: How do I disable creation of Trace files - as I don't need them
After the server came back up (and another reboot thereafter) users are unable to login to SQL Server. They are valid Active Directory users, are able to login to the domain and even access a share on my database server, however SQL server denies their connection.
Admins however do not have a problem using the server.
I assume the unexpected crash had something to do with this, as the users were still able to login this morning, before the crash. I have removed and recreated their logins to the server and the relevant database.
How can I diagnose the cause of this issue and fix my problem?