cannot login to sql server 2008 with sa or windows mode

ffayyca1 used Ask the Experts™
I'm having problems login to sql server 2008 with sa account. The windows account does not work either. Is there a way to reset the sa password without connecting to the actual instance?
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Qlemo"Batchelor", Developer and EE Topic Advisor
Top Expert 2015

Yes, as shown in that link you should be able to connect locally to your SQL Server when in Single User Mode, and then enable sa and/or change the password.

2008 does no longer add the administrator group to the SQL server accounts automatically, following Best Practise, and that is why the admin windows login does not work either at the moment.
Database Analyst
Do you have a login to at least connect to SQL Server? You could run the following stmnts in SSMS query against master database to see who's security admin or sysadmin if any then use one of those to connect (sp_helpsrvrolemember requires only public access):

exec sp_helpsrvrolemember @srvrolename = 'securityadmin'
exec sp_helpsrvrolemember @srvrolename = 'sysadmin'


question solved.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial