Free for PREMIUM members
Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium
It looks like you are in Windows authentication mode, and not mixed mode. sa is valid only under mixed mode.
If you have the rights to change the sa password, then surely you have admin rights yourself and don't need to be sa?
usually domain admins will have access to the SQL
and in order to reduce LDF, do a full backup usually helps. p/s: how long ago you did a backup?
Open in new window
Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.