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

Question

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,

Answer 1

@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.

Answer 2

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.