Cannot login after creating the user in SQL Server

Cannot login after creating the user in SQL Server

.net core cannot connect DB

new user in sql server not work

Solution

Can not login user in ssms,

after set mode as below, check ssms, then login the wheelchair success

Try setting your authentication mode to mixed mode. Your server does probably not accept logins using sql server accounts.

Open properties
Go to "Security"
Select "SQL Server and Windows Authentication mode"

=================
Create Sa Account

https://sudeeptaganguly.wordpress.com/2010/04/20/how-to-enable-sa-account-in-sql-server/
GO
ALTER LOGIN [sa] WITH PASSWORD=N'123456'
GO
ALTER LOGIN [sa] ENABLE
GO

留言