1.i forgo my sa passowrd..i dont have any other access to sql server...what are my options to get reset the password?...
Likelihood , you still have a fair chance to come out of this incident ,as you may have the follow options : · If you are using local Account or AD account for your SQL Server installation, you can use it for connecting SQL Server and reset SA password or local Administrator group · If you are already granting sysadmin privileges for Local Administrators groups, you can add your account to this group and connect SQL Server Despite of that , it is heavily recommended to disable SA user to mitigate SQL injection risks and much better to create other AD credentials having sysadmin to be used for administrative tasks instead of SA credential Kindly work out the above options and let me know your feedback
