O'Reilly logo

SQL Server 2014 with PowerShell v5 Cookbook by Donabel Santos

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Changing authentication mode

In this recipe, we will change SQL Server authentication mode.

Getting ready

Confirm which authentication mode your instance is running. Go to SQL Server Management Studio and log in to your instance. Once logged in, right-click on the instance and go to Properties | Security (this is similar to what we did in the previous recipe):

Getting ready

In this recipe, we will change the authentication mode from Integrated to Mixed. Feel free to do the reverse if your settings are different from what is presented in the preceding image.

How to do it...

Let's explore the steps required to complete the task:

  1. Open PowerShell ISE as an administrator. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required