Forum

What are the differ...
 
Share:
Notifications
Clear all

What are the different authentication modes in SQL Server? How can it be changed?

4 Posts
1 Users
0 Likes
308 Views
kumar BI
Posts: 12
 kumar BI
Guest
Topic starter
(@kumar BI)
Active Member
Joined: 2 years ago

SQL Server authentication modes

3 Replies
Siva Kumar
Posts: 36
 Siva Kumar
Guest
(@Siva Kumar)
Eminent Member
Joined: 2 years ago

Windows mode and Mixed Mode – SQL and Windows. You can go to the below steps to change authentication mode in SQL Server:

Click Start> Programs> Microsoft SQL Server and click SQL Enterprise Manager to run SQL Enterprise Manager from the Microsoft SQL Server program group.
Then select the server from the Tools menu.

Select SQL Server Configuration Properties, and choose the Security page.

Reply
2 Replies
Gouthami
 Gouthami
Guest
(@Gouthami)
Joined: 2 years ago

New Member
Posts: 1

@Siva Kumar what is the difference between two modes Can you please explain that as well?

Reply
Siva Kumar
 Siva Kumar
Guest
(@Siva Kumar)
Joined: 2 years ago

Eminent Member
Posts: 36

@Gouthami 

Here is the difference between Windows Authentication Mode and Mixed Authentication Mode. 

1) Windows Authentication Mode:
Windows authentication mode requires users to provide a valid Windows username and password to access the database server.

2)Mixed Authonctiation Mode:
Mixed authentication mode allows the use of Windows credentials but supplements them with local SQL Server user accounts that the administrator may create and maintain within SQL Server.

I hope it helps. 

Reply

Leave a reply

Author Name

Author Email

Title *

 
Preview 0 Revisions Saved
Share: