Why does my login to MS SQL with AzureML dataprep using Windows authentication fail?

Why does my login to MS SQL with AzureML dataprep using Windows authentication fail?

I tried connecting to a MS SQL database using&nbsp;<code><a href="https://docs.microsoft.com/en-us/python/api/azureml-dataprep/azureml.dataprep?view=azure-dataprep-py" target="_blank">azureml.dataprep</a></code>&nbsp;in an Azure Notebook, as outlined in&nbsp;<a href="https://docs.microsoft.com/en-us/azure/machine-learning/service/how-to-load-data#load-sql-data" target="_blank">https://docs.microsoft.com/en-us/azure/machine-learning/service/how-to-load-data#load-sql-data</a>, using&nbsp;<a href="https://docs.microsoft.com/en-us/python/api/azureml-dataprep/azureml.dataprep.mssqldatasource?view=azure-dataprep-py" target="_blank">MSSqlDataSource</a>, using code of the form

I tried connecting to a MS SQL database using azureml.dataprep in an Azure Notebook, as outlined in https://docs.microsoft.com/en-us/azure/machine-learning/service/how-to-load-data#load-sql-data, using MSSqlDataSource, using code of the form

import azureml.dataprep as dprep

secret = dprep.register_secret(value="[SECRET-PASSWORD]", id="[SECRET-ID]")

ds = dprep.MSSQLDataSource(server_name="[SERVER-NAME]", database_name="[DATABASE-NAME], [PORT]", user_name="[DATABASE-USERNAME]", password=secret)

Setting [DATABASE-USERNAME] equal to MYWINDOWSDOMAIN\MYWINDOWSUSERNAME and the password [SECRET-PASSWORD] coinciding with my Windows password (i.e. trying to use Windows authentication).

After firing a query with

dataflow = dprep.read_sql(ds, "SELECT top 100 * FROM [dbo].[MYTABLE]")
dataflow.head(5)

I get

ExecutionError: Login failed.

I could connect to other databases without Windows Authentication fine. What am I doing wrong?

Angular 9 Tutorial: Learn to Build a CRUD Angular App Quickly

What's new in Bootstrap 5 and when Bootstrap 5 release date?

Brave, Chrome, Firefox, Opera or Edge: Which is Better and Faster?

How to Build Progressive Web Apps (PWA) using Angular 9

What is new features in Javascript ES2020 ECMAScript 2020

Python with SQL Server Database

In this article you will learn: How to connect through SQL Server Database using Python? How can we store some information into the SQL Server database using Python? How can we perform an update and delete operations? How we will retrieve stored information from the SQL Server database?

SQL Server Tutorial For Beginners - Learn MS SQL Server with Examples

SQL Server Tutorial For Beginners, Microsoft SQL Server Tutorial, SQL Server Training. Microsoft SQL Server explains all the fundamentals of MS SQL Server with examples. What is DBMS? What is SQL? What is SQL Server? SQL Server Installation

Storage Considerations for Running SQL Server in Azure

<strong>Originally published by </strong>&nbsp;<a href="https://dzone.com/users/3368561/daveberm.html" target="_blank">David Bermingham</a><strong> </strong><em>at&nbsp;</em><a href="https://dzone.com/articles/storage-considerations-for-running-sql-server-in-a" target="_blank">dzone.com</a>