Loading

Executed as user: NT SERVICE\SQLSERVERAGENT. Conversion fail

Pappu Kumar

8y3.1k

Executed as user: NT SERVICE\SQLSERVERAGENT. Conversion failed when converting the nvarchar value 'Access to the remote server is denied because no login-mapping exists.' to data type int. [SQLSTATE 22018] (Error 245). The step failed.,00:00:00,16,245,,,,0

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rajneesh Chaubey8y ago
Accepted answer
Hi,
The meaning of the error is when you are using linked server SQL Server through non admin account, you have to add the parameter User IDJust add "User ID=Username" into the provider string on your linked server.
Hope you get it.
Thanks.
Pappu Kumar8y ago
could you please send more detail about it
Thanks
Amit Gupta8y ago
The error seems you are passing nvarchar type which has to be an integer. Doing so will resolve your issue.