December 21, 2004 at 1:52 pm
I am trying to link two servers together using EM (SQL Server 2000, SP3). I have the following setup on Server A and on Server B.
Under the General Tab I click the SQL Server Radio Button.
Under the Secuirty Tab I click the "Be made using this security context:" Radio Button and specify the "Remote Login:" and "With password:".
Under the Server Options Tab the first five checkboxes are checked.
When I try to view the Tables or Views on the Linked Server I receive the following error:
Error 18456: Login failed for user 'sqlagent'.
Thanks in advance for any assistance you can provide, Kevin
December 21, 2004 at 4:29 pm
Is 'sqlagent' a SQL account on the linked server with at least read permissions on the required tables? If you are trying to use a windows account, it won't work the way you describe.
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
December 23, 2004 at 10:39 am
Double check to make sure you have the client network setup correctly. Also make sure you have selected SQL Server under General tab of linked servers, And like Kathi said - its most likely a permission issue on the remote server for sqlagent user.
December 23, 2004 at 10:41 am
Kevin did reply to me personally that my solution was correct.
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply