How asign password to sa user?

jimm98y / MSSQLEXPRESS-M1-Install

Installers and installation scripts for Microsoft SQL Server Express on ARM64.

MIT License

252 stars 57 forks source link

How asign password to sa user? #39

Closed msolorzano77 closed 1 month ago

msolorzano77 commented 1 month ago

i try to assign password to 'sa' user, but i cant login please help

jimm98y commented 1 month ago

When you install as Admin, you should be able to use SQL Server Management Studio running also as Admin. Windows Authentication should let you connect. If you are having issues with the standard approach, you can always use sqlcmd.exe running locally on the same machine as the SQL Server and you can enable the "sa" user as described here: https://github.com/jimm98y/MSSQLEXPRESS-M1-Install/issues/36