KNOWLEDGE BASE

Error "An error occurred while communicated with the Microsoft SQL Server Database data source ... Login failed for user" Connecting to SQL Azure


Published: 23 Apr 2015
Last Modified Date: 02 Jun 2016

Issue

When connecting to SQL Azure, the following error might occur.

An error occurred while communicated with the Microsoft SQL Server Database data source
[Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user 'xxx'.

[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot open database "master" requested by the login. The login failed. 
[Microsoft][SQL Server Native Client 11.0][SQL Server]This session has been assigned a tracing ID of 'xxxx'. Provide this tracing ID to customer support when you need assistance.
Invalid username or password.

Environment

  • Tableau Desktop
  • Microsoft SQL Azure

Resolution

Work with your database administrator to have user added to the Master database. 

Cause

The user does not exist in the Master SQL Azure database.
 
Did this article resolve the issue?