Forum Discussion

aadhilkhan's avatar
aadhilkhan
Frequent Visitor
8 months ago

Copy Job from on prem SQL to Fabric SQL Database Error

Hi there Fabric Experts.   I am trying to copy data(using Copyjob) from SQL on prem to fabric SQL database. My connection works just fine and I can connect to the datasource,view the tables, select...
Need Help
sql database
v-venuppu's avatar
v-venuppu
Icon for Community Support rankCommunity Support
8 months ago

Hi aadhilkhan ,

May I ask if you have resolved this issue? Please let us know if you have any further issues, we are happy to help.

Thank you.

aadhilkhan's avatar
aadhilkhan
Frequent Visitor
8 months ago

Hi @v-venuppu  lbendlin 

 

Thanks for your prompt response, I have managed to test it out but got the below error:

 

Code: AuthenticationError, Type: UserError, Message: Microsoft SQL: Caller is not authorized to initiate the requested action. Sysadmin privileges are required., ErrorCode: AuthenticationError ArtifactId: 123.

 

 

Does this mean that the user login used for SQL mirroring needs to get added to the Sysadmin role to mirror the database into fabric?