How to create SQL authentication user in Azure SQL serverless database

Question

How to create SQL authentication user in Azure SQL serverless database

Eddynson Vega 152

Hello dears,

I have tried several ways to create a user's authentication in SQL Serverless, but none have worked for me, they can help me define the steps to follow to access all the views of the database.

I currently get an error like this:

Eddynson Vega 152 Reputation points

2022-01-05T15:26:12.443+00:00
in the following article I found this documentation that explains how to create authentication but I don't know how to create user identity

List item

CREATE EXTERNAL DATA SOURCE ExternalDataSourceDataLake
WITH (
LOCATION = 'https://<storageaccountname>.dfs.core.windows.net/datalakehouse'
);

CREATE SCHEMA LDW authorization dbo;

CREATE MASTER KEY ENCRYPTION BY PASSWORD = '<REALLY_STRING_PASSWORD!>';

CREATE DATABASE SCOPED CREDENTIAL SynapseUserIdentity
WITH IDENTITY = 'User Identity';
ALTER DATABASE sqllogicaldw COLLATE Latin1_General_100_BIN2_UTF8;
ShaikMaheer-MSFT 38,556 Reputation points Microsoft Employee Moderator

2022-01-12T16:37:20.64+00:00

Hi @Anonymous ,

Following up to see if the below answer helped. If this answers your query, do click and upvote for the same. And, if you have any further query do let us know.

Answer accepted by question author

0 additional answers

Your answer

Eddynson Vega 152 Reputation points

2022-01-05T15:26:12.443+00:00

in the following article I found this documentation that explains how to create authentication but I don't know how to create user identity

List item

CREATE EXTERNAL DATA SOURCE ExternalDataSourceDataLake
WITH (
LOCATION = 'https://<storageaccountname>.dfs.core.windows.net/datalakehouse'
);

CREATE SCHEMA LDW authorization dbo;

CREATE MASTER KEY ENCRYPTION BY PASSWORD = '<REALLY_STRING_PASSWORD!>';

CREATE DATABASE SCOPED CREDENTIAL SynapseUserIdentity
WITH IDENTITY = 'User Identity';
ALTER DATABASE sqllogicaldw COLLATE Latin1_General_100_BIN2_UTF8;
ShaikMaheer-MSFT 38,556 Reputation points Microsoft Employee Moderator

2022-01-12T16:37:20.64+00:00

Hi @Anonymous ,

Following up to see if the below answer helped. If this answers your query, do click and upvote for the same. And, if you have any further query do let us know.

Answer 1

ShaikMaheer-MSFT 38,556 Microsoft Employee Moderator

Hi @Anonymous ,

Thank you for posting query in Microsoft Q&A Platform.

In below video, explained how to create login and user for serverless sql pool in Azure Synapse Analytics. Kindly go through it once.
https://www.youtube.com/watch?v=CeC-DuzGP1I&list=PLMWaZteqtEaIZxPCw_0AO1GsqESq3hZc6&index=22

As pre-requisite to above video, kindly check below video once which explains about Administrative accounts in Synapse SQL.
https://www.youtube.com/watch?v=iTUK2ORlQmY&list=PLMWaZteqtEaIZxPCw_0AO1GsqESq3hZc6&index=21

Hope this is helpful. Please let us know if any further queries. Thank you.

---------------

Please consider hitting Accept Answer button. Accepted answers helps community as well.

ShaikMaheer-MSFT 38,556 Reputation points Microsoft Employee Moderator

2022-01-07T18:07:32.31+00:00

Hi @Anonymous ,

Just checking in to see if the below answer helped. If this answers your query, do click and upvote for the same. And, if you have any further query do let us know.
Eddynson Vega 152 Reputation points

2022-01-12T18:03:38.677+00:00

Hello @ShaikMaheer-MSFT , I was able to create the user, and even look at the views authenticating with the user, but I can not consult them.
Eddynson Vega 152 Reputation points

2022-01-12T18:06:48.493+00:00

This article helped me a lot.

https://www.serverlesssql.com/logical-data-warehouse/creating-a-logical-data-warehouse-with-synapse-serverless-sql-part-1-of-3-setting-up-and-querying-source-data/
ShaikMaheer-MSFT 38,556 Reputation points Microsoft Employee Moderator

2022-01-13T16:44:27.44+00:00

Hi @Anonymous - Thank you for sharing article. Indeed its good article. Kindly consider marking answer as accepted answer. Accepted answers helps community as well.

Share via

How to create SQL authentication user in Azure SQL serverless database

0 additional answers

Your answer