Can not connect to sqlserver authentication mode

Question

Iam using sql server 2019.

I want to connect through sql server authentication mode.

i can connect throgh windows authentication mode.

I have connected to sqlserver using windows authentication  and click security and login sa is there.

i have changed the password of sa and tried to login but it is showing following error

Login failed for user 'sa'. Reason: Server is in single user mode. Only one administrator can connect at this time. (.Net SqlClient Data

Provider)

How to solve this

Regards

Baiju

Answer 1

If you start SQL Server in single user mode only one administrator can connect at the same time.

Cause – Ensure SQL Server is not running in Single user mode by checking start-up parameter.

if you see -m; it mean your SQL is running with single user mode.

Resolution – In order to resolve this issue; you need to remove -m from Stat-up parameter and restart the SQL Server.

Answer 2

Hi

If you alter to multi user access ,I think your problem may solve .

 How to SET database to MULTI_USER Database Access Mode?

We can use script like below to SET database to MULTI_USER Database Access Mode

USE databasename GO ALTER DATABASE databasename SETMULTI_USER Thanks and regards

Answer 3

Hi baiju krishnan,,

Follow steps as next:

1.stop the sql service;
2.run cmd as administrator;
3.C:\windows\system32>net start "SQL Server (ServiceName)"
Then test with ssms again

This could be helpful: https://dba.stackexchange.com/questions/179623/only-one-administrator-can-connect-at-this-time-ms-sql-server-error-18461

BR,

Mia

If the reply helped, please “Mark Answer” and upvote it.--Mia

---

""SQL Server related"" forum will be migrated to a new home on Microsoft Q&A SQL Server!
We invite you to post new questions in the "SQL Server related" forum’s new home on Microsoft Q&A SQL Server !
For more information, please refer to the sticky post.

Answer 4

No, it isn't the database that si in single user, it is the whole instance. I.e., setting a database option doesn't resolve this, the instance need to be restarted and started without the -m switch.

---

Tibor Karaszi, SQL Server MVP (Web Blog)

Answer 5

Why did you start SQL Server in "single user mode"?  This is a manual process only used to fix specific issues.  This is not a normal thing to do.

Answer 6

Hi Biju, Remove -m from start up parameter and restart the sql services. Also if your environment is supported by multiple DBAs check with your colleagues to avoid clashes ! Thanks, Sreekanth Madambath