Unable to connect to localhost with sa login credentials

PontiacGTX, 1 Reputation point
2022-04-06T17:44:40.767+00:00

I have tried to reset-create a new password to login to localhost on sql server(localdb login just fine with sa and even allows to reset the password) I have done the following

Stop SQL Agent Service,MSSQLSERVER Service
Set property for startup on MSSQLSERVER with -m
Started both services, logged in to SMSS with Windows Authentication
Opened the tree for security>login
Clicked property for sa and set the password and confirmed it, then in Status page enabled the login
accepted close SMSS,
removed the -m flag on Sql server configuration manager
applied and accepted then restarted the service (MSSQLSERVER)

and then I used the new password with SQL Authentication and used sa for username
and it shows an error

A connection was successfully established with the server, but then an error occurred during the login process. (Error Number: 233)

then tries again and says my password is invalid, but this didnt happened with LocalDb because I sucessfully changed the password,

what could I do?

I am running Windows 10 21H2
SMSS 15.0.18410
Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64)

Windows 10
Windows 10
A Microsoft operating system that runs on personal computers and tablets.
10,728 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,832 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 102K Reputation points MVP
    2022-04-06T18:51:54.15+00:00

    Before anything else, download and install the most recent Cumulative Update to get lots of bug fixes.

    If the issue persists, you may want to check the spelling of the passwords. Also check the contents of SELECT *FROM sys.server_triggers.

    0 comments
  2. Seeya Xi-MSFT 16,446 Reputation points
    2022-04-07T02:46:56.173+00:00

    Hi @PontiacGTX, ,

    Welcome to Microsoft Q&A!
    Could you post the entire information about this error 233?
    Please see this article about the detailed error message and the solution.
    https://www.databasefilerecovery.com/blog/fix-sql-server-error-233.html
    Hope this could help you. Good day.

    Best regards,
    Seeya

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments