CODEWITHSUNDEEP
azureexternalcredentials
Per Schjetne
Per Schjetne

Reputation: 46

How to Create a SQL Credential in a local U-SQL database

The CREATE CREDENTIAL U-SQL command is now depreciated, and the PowerShell command New-AzureRmDataLakeAnalyticsCatalogCredential has taken over. How to create a credential in a local u-sql database with the new Powershell command? I'm developing all my U-SQL stuff in Visual Studio and want to connect to an Azure SQL Database from my local environment. Possible?

Upvotes: 1

Views: 232

Answers (1)

g_brahimaj
g_brahimaj

Reputation: 197

I needed this for my current tests that I am doing and after quite some investigations, I came up with a solution:

  1. Find the location where the "LocalRunHelper.exe" is located
  2. Run a command prompt window at that location
  3. Replace the keywords and run the command:

    LocalRunHelper.exe credential -DataRoot {Absolute_path_of_local_u-sql} -Add {database}{credential_name} -User {sql_user} -Password {sql_password} -Uri tcp://{server}.database.windows.net:1433

That's it!

Upvotes: 1

Related Questions