search

jimm98y / MSSQLEXPRESS-M1-Install

Installers and installation scripts for Microsoft SQL Server Express on ARM64.
MIT License
252 stars 57 forks source link

Login Failed for user on Parallels on MacBook Pro M3 #36

Closed grumpykiwi closed 2 months ago

grumpykiwi commented 2 months ago

Install went fine but when I go to log in using Azure Data Studio, I get login failed

Server .\sqldeveloper Windows Auth Encrypyt Optional or Mandatory (no difference) Trust certificate true

My local user that Parallels creates is a local admin

Since SA is disabled according to a ticket I read, I cant get in that way

Ideas ?

Thanks

Mark

jimm98y commented 2 months ago

Does SQL Management Studio connect? This might be because AzureAttestService is not installed (it cannot be installed on ARM64).

grumpykiwi commented 2 months ago

Hello

I have a fix for this after some searching and fiddling.

  1. Install SSMS 20.1

  2. Start PowerShell as Administrator

  3. Variables enclosed within <> should be replaced with the actual value. in my case is Mark-Windows-XI

  4. Ensure that the username you would like to add is a member of the local administrators group.

  5. net stop "SQL Server (SQLDeveloper)"

  6. $sql_server_instance = "\sqldeveloper"

  7. $login_to_be_granted_access = "[\]"

  8. net start "SQL Server (SQLDeveloper)" /f /mSQLCMD

  9. sqlcmd.exe -E -S $sql_server_instance -Q "CREATE LOGIN $login_to_be_granted_access FROM WINDOWS; ALTER SERVER ROLE sysadmin ADD MEMBER $login_to_be_granted_access; "

  10. net stop "SQL Server (SQLDeveloper)"

  11. net start "SQL Server (SQLDeveloper)"

After that I was able to connect to SSMS, change to Mixed mode, fix the SA account, and create a SQL login for my application.

Next step is to see if my Blazor app will run in debug from VS 2022 Preview.

Hope this helps

Cheers

Mark

Mark Nash

IT Director

(817) 465-9277 | Arlington, Tx

Winner of 104 IABC Gold Quills and the 2023 Large Agency of the Year

[cid:linkedin_4c6f3bdf-dd4e-4f46-94f0-1885fa83094c.png]https://www.linkedin.com/company/partnercomm [cid:instagram_bebedbe2-cb80-462a-af3c-7ae9caf0718c.png] https://www.instagram.com/partnercomm [cid:facebook_a2d99c62-cb5a-42d3-b0e4-d08e71427149.png] https://www.facebook.com/PartnerCommInc/ [cid:twitter_53725725-ce5d-4ef3-bd47-bfd64fe511d7.png] https://twitter.com/partnercomm [cid:vimeo_f71007e4-e318-469a-b82c-5751fc4fbe28.png] https://vimeo.com/sweet250 [cid:web_a51bd891-a842-461a-b706-81937a9daae4.png] www.partnercomm.nethttps://www.partnercomm.net [cid:logo-pcomm-30_74bce84a-c4e7-4724-87ee-9c2ca3e3421e.png] From: Lukas Volf @.> Sent: Saturday, July 6, 2024 3:30 AM To: jimm98y/MSSQLEXPRESS-M1-Install @.> Cc: Mark Nash @.>; Author @.> Subject: Re: [jimm98y/MSSQLEXPRESS-M1-Install] Login Failed for user on Parallels on MacBook Pro M3 (Issue #36)

[EXTERNAL SENDER]

[Warning! There may be malicious links below!]

Does SQL Management Studio connect? This might be because AzureAttestService is not installed (it cannot be installed on ARM64).

- Reply to this email directly, view it on GitHubhttps://github.com/jimm98y/MSSQLEXPRESS-M1-Install/issues/36#issuecomment-2211705997, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AKOLVX3FWK2NXNA3UMPEANLZK6TG5AVCNFSM6AAAAABKOBNRQOVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDEMJRG4YDKOJZG4. You are receiving this because you authored the thread.Message ID: @.**@.>>

jimm98y commented 2 months ago

That's interesting, Windows auth is enabled by default so it should have let you in right after the installation using your Windows account. But I'm glad you've fixed it and shared your solution!