SQL AUTHENTICATION AFTER SYSPREP

Question

We are using windows 10 with SQL 2019 authenticated by windows, the problem is that after sysprep is impossible to connect again with Error: 18456. Which could be the proceed to connect SQL?

Thanks

TITLE: Connect to Server

------------------------------

Cannot connect to DESKTOP-EELBGKN.

------------------------------

ADDITIONAL INFORMATION:

Error de inicio de sesión del usuario 'DESKTOP-EELBGKN\Navegador'. (Microsoft SQL Server, Error: 18456)

For help, click: https://learn.microsoft.com/sql/relational-databases/errors-events/mssqlserver-18456-database-engine-error

------------------------------

BUTTONS:

OK

------------------------------

Answer 1

Hi, I did those steps:
I created a user SA and then run SYSPREP.

After sysprep process I can connect with SA.

That´s all!

Answer 2

Hi @Garay, Javier ,
Pls firstly check if restarting the server can solve the issue. And please, make sure you are typing the correct username and password.
If it still doesn't work try this solution:

1. Right click on SMSS and select Run as Administrator,and check if the SQL server is clear of the error 18456
   
2. If not, check if disabling UAC on the server solves the issue. (Open the Control Panel -> Navigate to User Accounts and Family Safety > User Accounts -> Open your User Account and click on Change User Account Control settings.)
3. Launch the SQL Server in a Single User Mode. Add -m in the Start Parameters
   
   4.Restart the SQL in sscm and run as Administartor again to see if the error has been solved.
   5.If so, then add the domain account to the SQL server and assign it the SysAdmin role.Now go back to the SQL Server Configuration Manager window and remove the -m parameter in the
   Startup Parameters tab.
   6.Restart the SQL Server service to check if the SQL server is working fine

For more solutions, you can check this link: https://appuals.com/sql-server-error-18456/

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment"

Answer 3

Hi, I think that I Could fix the problem creating a new SA before the SYSPREP. Today I will be trying again.

Thanks