SQL Management Studio - Add SA (System Administrator) Credentials and Password to Local DB
The scripts for this are below:
--ALTER LOGIN sa ENABLE;
--ALTER LOGIN sa WITH PASSWORD = 'Ch@ngeThIS!';
--this checks that it has worked
--SELECT name, type_desc, is_disabled
--FROM sys.server_principals
--WHERE name = 'sa';
Remember - it's never too late!
Cheers,
Steve