Share via

Getting the Integration run time error while created the linked service for Sql server in datafactory

Anand Raj 0 Reputation points
2024-05-01T12:28:59.37+00:00

Getting the Integration run time error while created the linked service for Sql server in data factory, can anyone help to solve this error

Cannot connect to SQL Database. Please contact SQL server team for further support. Server: 'mylearningsql.database.windows.net', Database: 'mylearningsqldb', User: 'anand'. Check the linked service configuration is correct, and make sure the SQL Database firewall allows the integration runtime to access.

Cannot open database "mylearningsqldb" requested by the login. The login failed.

Login failed for user 'anand'., SqlErrorNumber=4060,Class=11,State=2,

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,877 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,724 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 102.2K Reputation points
    2024-05-01T12:55:10.75+00:00

    The error suggests one of:

    1. The database mylearningsqldb does not exist. (Which could be because you are connecting to a different instance than you intended to.)
    2. The database exists, but is in single-user mode or restricted mode.
    3. The database exists, but the principal you are trying to connect to does not have permission to the database.

    I hope that this information will help you with further troubleshooting.

    0 comments
  2. phemanth 6,630 Reputation points Microsoft Vendor
    2024-05-01T13:41:43.13+00:00

    @Anand Raj Dorai

    Thanks for using MS Q&A platform and posting your query.

    The error message suggests a few potential issues:

    1. Incorrect Login Credentials: The error message “Login failed for user ‘anand’” suggests that the username or password might be incorrect. Please double-check your login credentials.
    2. Database Accessibility: The error “Cannot open database ‘mylearningsqldb’ requested by the login” could mean that the database doesn’t exist or the user ‘anand’ doesn’t have the necessary permissions to access it. Please ensure that the database exists and the user ‘anand’ has the correct permissions.
    3. Firewall Settings: The error message also suggests checking if the SQL Database firewall allows the integration runtime to access. Please verify your firewall settings and ensure that your current IP address is allowed.
    4. Linked Service Configuration: Please check the linked service configuration in Azure Data Factory and make sure it’s correct.

    Hope this helps. Do let us know if you 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.