SQL server login issue

OK... What is the error?
Are you trying to log into SQL management studio or connect a user to the DB to run operations?

is it a problem with a specific user or all local users?

You gave us no information to work with, Please explain your problem with as much information as you can, any debugging steps you took should be listed as well

You can acquire SINGLE_USER mode against a database by running SQL code like below however you may need to review the ROLLBACK IMMEDIATE option if it is not appropriate for your need plus if you close the SSMS session where you run this before the database is switched back to MULTI_USER then some other session may use it exclusively until you open new session and run the SET MULTI_USER. Highlight all the code below in SSMS and execute so it all goes in one.

USE [master]
ALTER DATABASE YourDBname SET SINGLE_USER WITH ROLLBACK IMMEDIATE
-- put all your SQL commands here like a RESTORE DATABASE...for instance
ALTER DATABASE YourDBname SET MULTI_USER
GO

Select allOpen in new window