"Localhost" as server name is may good for web server, but not for SQL Server.
Enter the realy server name.
Sa account creating using single user mode
![](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(201.6, 73%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anandhswarupp
205
Reputation points
This our production server i setup the server in single user mode and creating sa account using sql query in cmd mentioned above image but facing mentioned issue, But in test server i am able to create sa account using above sql command,
SQL Server Database Engine
{count} votes
-
Dan Guzman 9,411 Reputation points2025-03-30T14:12:02.86+00:00 Are you able to connect if you omit
slocalhostand run SQLCMD with no arguments? -
Anandhswarupp 205 Reputation points
2025-03-30T14:15:02.89+00:00 No i did not
-
Dan Guzman 9,411 Reputation points
2025-03-30T20:26:50.2933333+00:00 Check to ensure the instance is actually running.
-
Anandhswarupp 205 Reputation points
2025-03-31T01:26:59.42+00:00 Sql server is running
Sign in to comment
1 answer
Sort by: Most helpful
-
Olaf Helper 47,586 Reputation points2025-03-31T06:59:40.5466667+00:00 -
Anandhswarupp 205 Reputation points
2025-03-31T07:18:37.2333333+00:00 What is good for sql server
Sign in to comment -