Enable SQL Server Authentication - DSN Configuration

Question

I'm using Powershell to update DSN configuration. Example code:

$properties = @('server=databaseServer1', 'description=Test description')
Set-OdbcDsn -Name 'TestDSN' -SetPropertyValue $properties -DsnType System

This works. I want to enable SQL Server Authentication, following this page I tried:

$properties = @('SqlPassword=SQL_AU_PASSWORD')

Does not work. Also tried:

$properties = @('Authentication=SqlPassword')

Does not work. Both show the error Invalid keyword-value pairs.

What am I doing wrong?

Stefan Prugg · Accepted Answer · 2018-10-19 16:44:59Z

1

you have to set Trusted_Connection (No = SQL Server Authentication, Yes = Windows Authentication)

$properties = @('server=databaseServer1', 'description=Test description','Trusted_Connection=No')
Set-OdbcDsn -Name 'TestDSN' -SetPropertyValue $properties -DsnType System

answered Oct 19, 2018 at 16:44

Stefan Prugg

3142 silver badges5 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Enable SQL Server Authentication - DSN Configuration

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related