This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 63%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
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)
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 2%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESX%3C/text%3E%3C/svg%3E)
Hi @PontiacGTX, ,
We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
Best regards,
Seeya
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.
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.