Cannot Login with Windows Authentication and as 'SA' in SQL Server 2005
Posted on 2011-02-20
I am using SQL Server 2005
Server Authentication is 'SQL Server and Windows Authentication mode'
Issue #1:- I cannot login to SQL Server 2005 using Windows Authentication
Error:- Login failed for user '<computername>\<windows username>'
Issue #2:- SQL Server Authentication - sa login password - I don't remember.
If I try some password, 'Login failed for 'sa'" error message pops up
I know that to recover sa password, I need Windows Authentication Login.
Also to do something with Windows Authentication, I need 'sa' login
Only login I have is an user which have permission to only one database, which cannot do these stuffs
Anyway to recover from these two issues in this scenario. ?
Dear Friend, Please help