Getting error "Login failed for user '

Question

I have a resource group under which I have created a sql pool and Synapse workspace. Whenever I am running a query like "CREATE SCHEMA foodmart" it is giving the following error. "Login failed for user '

Answer 1

@Shiv - Thanks for the question and using MS Q&A platform.

The error "Login failed for user" in Azure Synapse Analytics typically indicates an issue with authentication or permissions.

Here are some steps to troubleshoot and resolve this issue:

• Verify User Credentials: Ensure that the credentials you are using to connect to the SQL pool and Synapse workspace are correct. Double-check the username and password.
• Check User Permissions: Ensure that the user account you’re using has the necessary permissions to create schemas in the SQL pool. You might need to grant the appropriate roles or permissions.
• Azure Active Directory Authentication: If you are using Azure Active Directory (AAD) authentication, ensure that the AAD user or service principal has been assigned the necessary roles and permissions within the Synapse workspace and SQL pool.
• Firewall and Network Security: Ensure that the firewall settings of your SQL pool allow connections from your IP address or the Azure services. You can configure this in the Azure portal under the SQL pool's networking settings.
• Connection Strings: Double-check the connection strings you’re using to connect to the SQL pool. Ensure that they are correctly formatted and include the necessary authentication details.
• Diagnostic Logs: Check the diagnostic logs in the Azure portal for more detailed error messages. These logs might provide additional context about why the login failed.
• Clear Cache and Cookies: If you’re accessing Synapse Studio through a web browser, try clearing your browser’s cache and cookies or using a different browser.

For more information, refer to this: Resolve Azure Synapse Studio connectivity issues

Hope this helps. Do let us know if you have any further queries.  

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

If this answers your query, do click `Accept Answer` and `Yes` for was this answer helpful. And, if you have any further query do let us know.