To enable the sa login by using Transact-SQL Execute the following statements to enable the sa password and assign a password.
Copy Code ALTER LOGIN sa ENABLE ; GO ALTER LOGIN sa WITH PASSWORD = 'enterStrongPasswordHere' ; GO To enable the sa login by using Management Studio In Object Explorer, expand Security, expand Logins, right-click sa, and then click Properties.
On the General page, you might have to create and confirm a password for the sa login.
On the Status page, in the Login section, click Enabled, and then click OK.
1 comment:
http://msdn.microsoft.com/en-us/library/ms188670.aspx
To enable the sa login by using Transact-SQL
Execute the following statements to enable the sa password and assign a password.
Copy Code
ALTER LOGIN sa ENABLE ;
GO
ALTER LOGIN sa WITH PASSWORD = 'enterStrongPasswordHere' ;
GO
To enable the sa login by using Management Studio
In Object Explorer, expand Security, expand Logins, right-click sa, and then click Properties.
On the General page, you might have to create and confirm a password for the sa login.
On the Status page, in the Login section, click Enabled, and then click OK.
Post a Comment