Home Forums SQL Server 2005 SQL Server 2005 Security How to set password newly install Sql server 2005 by query? RE: How to set password newly install Sql server 2005 by query?
HanShi
SSC-Dedicated
Points: 33506
More actions
July 22, 2014 at 8:16 am
#1731436
I guess this should work (when you are logged in as the SA):
USE [master]
GO
ALTER LOGIN [sa] WITH PASSWORD=N'new_password'