IR service Issue

Rohit Kulkarni 691

Hello team

I am trying to create a Integration service in Azure data factory.but i am getting below mentioned error :

Thanks in advance

Regards
RK

1 answer

KranthiPakala-MSFT 46,462 Reputation points Microsoft Employee

2021-06-11T18:42:27.433+00:00
Hi @Rohit Kulkarni ,

Thanks for reaching out.

Could you please confirm if you are receiving this error when creating Linked service or Integration runtime? By looking at the sql error code it seems like the user/service principal you are trying to use to access the master db doesn't have required permissions, login might have access to the SQL server instance but not to the database mentioned in the error. Could you please make sure the the login had required permissions for master database?

For more clarification please refer to this doc: https://learn.microsoft.com/en-us/sql/relational-databases/errors-events/mssqlserver-916-database-engine-error?view=sql-server-ver15

Here are related docs:

https://learn.microsoft.com/azure/azure-sql/database/authentication-aad-service-principal

https://techcommunity.microsoft.com/t5/azure-sql/azure-ad-service-principal-authentication-to-sql-db-code-sample/ba-p/481467

Let us know how it goes.

Thanks
Please sign in to rate this answer.
KranthiPakala-MSFT 46,462 Reputation points Microsoft Employee

2021-06-14T17:10:21.127+00:00

Hi @Rohit Kulkarni ,

Just checking in to see if the above information was helpful to resolve your issue. In case if you have already found a solution, please do consider to share it here with community, as it would be helpful for others reading this thread. And if you have further query do let us know.

Thanks

Rohit Kulkarni 691 Reputation points

2021-06-15T10:10:56.517+00:00

Hello Kranthi,

I have created the IR services and it is getting failed .Please refer the error in the below:

Error details
Notifications
Error code: CatalogDbCreationFailure. Error message: Failed to create catalog database. Sql Error Number: 262, Message: CREATE DATABASE permission denied in database 'master'.. Activity ID: dc4d6f40-c9f2-449f-90e3-f27a46f3da3e

Please advise.

Regards
RK

Rohit Kulkarni 691 Reputation points

2021-06-15T17:19:06.637+00:00

Hello team,

I have created the IR Service(SSIS Integration Dev) with different User id.It is working fine now.
But in the IR service the sub-type is blank.Please refer the screenshot below :

Please advise.

Regards
Rk

KranthiPakala-MSFT 46,462 Reputation points Microsoft Employee

2021-06-18T06:04:56.793+00:00

Hi @Rohit Kulkarni ,

Apologies for the delayed response and glad to know that your permission issue was resolved.

For Azure SSIS IR status issue, it seems like your integration runtime is in stopped state. By selecting its name or hovering over on it, you can select the relevant buttons to monitor/start/stop/delete your Azure-SSIS IR. By stopping and starting it as you see fit, you would be able to manage the cost of running your Azure-SSIS Integration Runtime.

Please select the SSIS IR and click on start to start your Azure SSIS IR. It will take sometime to get started. You will get a notification in the notification section once the SSIS IR is started.

Please see below GIF (Please note that it will take some time to start your SSIS IR):

Hope this helps. Do let us know how it goes.

KranthiPakala-MSFT 46,462 Reputation points Microsoft Employee

2021-06-21T18:31:54.387+00:00

Hi @Rohit Kulkarni ,

We still have not heard back from you. Just wanted to check if the below suggestion was helpful? If it answers your query, please do click “Accept Answer” and/or Up-Vote, as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

IR service Issue

1 answer

Your answer