Your technology certification is waiting. Enroll in Cloud Class ®
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
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Please enter a first name
Please enter a last name
Must be at least 4 characters long.
Join and Comment
Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.