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
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
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:
Let us know how it goes.
Thanks
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
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
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
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.
4 people are following this question.