SQL 2008 SA account locked out
- oktober 20th, 2010
- Write comment
Connect from the same server (via terminal), server administrators are by default granted access to SQL Server. Then issue:
ALTER LOGIN sa WITH PASSWORD = ‘new_password’ UNLOCK
Archive for the ‘SQL’ Category
Connect from the same server (via terminal), server administrators are by default granted access to SQL Server. Then issue:
ALTER LOGIN sa WITH PASSWORD = ‘new_password’ UNLOCK