How To Enable sa Login Using T-SQL In SQL Server 2008

In this article I tell you how to enable sa login in SQL Server using T-SQL.
  • 1589
In this article I tell you how to enable sa login in SQL Server using T-SQL.

To enable sa login, follow given steps.

Step 1

Open SQL Server Management Studio.

Step 2

In Object Explorer, connect to database engine. Open New Query window and write following code, enter password and execute.

alter login sa enable

go

alter login sa with password='<EnterPasswordHere>'

go

 AuthenticationMode01.jpg

Categories

More Articles

© 2019 DotNetHeaven. All rights reserved.