question

RohitKulkarni-6062 avatar image
0 Votes"
RohitKulkarni-6062 asked KranthiPakala-MSFT commented

IR service Issue

Hello team

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

104741-image.png



Thanks in advance

Regards
RK

azure-data-factory
image.png (56.6 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

KranthiPakala-MSFT avatar image
0 Votes"
KranthiPakala-MSFT answered KranthiPakala-MSFT commented

Hi @RohitKulkarni-6062,

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://docs.microsoft.com/en-us/sql/relational-databases/errors-events/mssqlserver-916-database-engine-error?view=sql-server-ver15

Here are related docs:

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

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





· 5
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @RohitKulkarni-6062,

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

0 Votes 0 ·

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

0 Votes 0 ·

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 :

105896-image.png



Please advise.

Regards
Rk



0 Votes 0 ·
image.png (23.8 KiB)

Hi @RohitKulkarni-6062,

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.

106825-image.png

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

106848-ssisirstartstop.gif

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



0 Votes 0 ·
image.png (134.6 KiB)
ssisirstartstop.gif (235.8 KiB)
Show more comments