How to connect Sql Authentication Mode in SQL Server?

Question

How to connect datasbase in Sql Authentication Mode in SQL Server?

Ashutosh Gupta · Answer

In SQL Server Management Studio Object Explorer, right-click the server, and then click Properties. On the Security page, under Server authentication, select the new server authentication mode, and then click OK. In the SQL Server Management Studio dialog box, click OK to acknowledge the requirement to restart SQL Server. In Object Explorer, right-click your server, and then click Restart. If SQL Server Agent is running, it must also be restarted. using Transact-SQL ALTER LOGIN sa ENABLE ; GO ALTER LOGIN sa WITH PASSWORD = ' ' ; GO

Chandresh Pansuriya · Answer

Hi Atul, Here is the reference video step by step guidance on your question. https://www.youtube.com/watch?v=qINbmzRQh1o Thanks.

Rajanikant Hawaldar · Answer

https://www.c-sharpcorner.com/UploadFile/ff0d0f/authentication-modes-available-in-sql-server/

Atul Warade · Answer

Hi Ashutosh, using Transact-SQL ALTER LOGIN sa ENABLE ; GO ALTER LOGIN sa WITH PASSWORD = '' ; GO instead of this i tried below command Create login sa with password = '12345' in master database by using this i can access sql database but i am doing some asp.net core hands on with sql server while using EF Core i got 'Can not create database in Master' this meesage i got. Permission issue i got it here.

Jenith Thakkar · Answer

Hi In sql Server popup select Authentication mode from dropdown And Enter Id/Password which you had set at the the time of install sql server Thank you

How to connect Sql Authentication Mode in SQL Server?

Answers (5)