issue was resolved by restarting the sql server service