Try using the following video to guide you creating a new linked service to your Azure SQL Database:
https://www.youtube.com/watch?v=0ZvFP1AI7xg
------------------------------
If this is helpful please accept answer.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hello everybody!
Me and my team are struggling to get to use a database inside the built-in Serverless SQL Pool in Synapse.
We could create a database manually on Develop (using a script and executing it), but when we want to create a linked service, the only database available for us to choose from the list is master (important: the settings from Account selection method we chose are "From Azure suscription")
How can we create another database (different from master) in order for us to use it in our linked service?
Thanks!
Kind regards,
Mateo
Try using the following video to guide you creating a new linked service to your Azure SQL Database:
https://www.youtube.com/watch?v=0ZvFP1AI7xg
------------------------------
If this is helpful please accept answer.
Hello @Mateo Estrada Bazan ,
Thanks for the question and using MS Q&A platfrom.
As per the official document - in order to pass the built-in serverless sql pool you need to
Enter Manuallyserverless SQL pool in Azure Synapse from the Azure portal.
Step1: Get the Serverless SQL endpoint from your synapse workspace as shown below:
Step2: Create a linked service for a serverless SQL pool in Azure Synapse from the Azure portal: by choosing Azure Synapse Analytics and select Enter manually as shown below:
Hope this will help. Please let us know if any further queries.
------------------------------
or upvote
button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how