Sa account creating using single user mode

Anandhswarupp 205 Reputation points
2025-03-29T10:33:48.3466667+00:00

Screenshot_2025-03-29-13-52-45-66_96b26121e545231a3c569311a54cda96

This is our production server. I set up the server in single-user mode and attempted to create an SA account using an SQL query in CMD, as mentioned in the image above. However, I am facing the mentioned issue. On the test server, I was able to create the SA account using the same SQL command. I am using mentioned sql query to create sq account on test server CREATE LOGIN newsa WITH PASSWORD = '12345678';

ALTER SERVER ROLE sysadmin ADD MEMBER newsa;

GO

SQL Server Database Engine
{count} votes

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.