[Help Request] Windows auth login failed

jimm98y / MSSQLEXPRESS-M1-Install

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

MIT License

270 stars 59 forks source link

[Help Request] Windows auth login failed #31

Closed faiqg closed 5 months ago

faiqg commented 5 months ago

Using Parallels on MacBook Pro M1. Installed using Sql2022Developer.bat (let it download installer). Installation is complete. The SQL Server service seems to be running. When connecting to the instance using SSMS or SQLCMD, the error pops up. "Login failed for user "hostname\myuser.name"

I am sure i am missing something small. Could you please point me to a possible resolution?

jimm98y commented 5 months ago

In Advanced options in the connection dialog there should be something like "Trust server certificate". You have to check it.

faiqg commented 5 months ago

That checkbox is ticked in my case. Without that checked, i get a certificate related error.

jimm98y commented 5 months ago

In that case, I'm afraid I can't help. I am not a SQL expert and since it looks like the installation has completed successfully, this seems like some general problem with Windows account permissions.

faiqg commented 5 months ago

Opened SSMS as an Admin and viola! The installation needs elevated permissions, so makes sense the connections would too.

Bonus for anyone wandering here in the future - How to make any program always run as an administrator on Windows.