June 30, 2019 at 12:57 pm
Hi there,
I am trying to transfer one table from our production server to the replication server
this is my query :
INSERT INTO [ctr].[dbo].[customers] (id, CategoryNumber, StatusId, SentDate)
SELECT id, CategoryNumber, StatusId, SentDate From [178.54.55.30\s2017].[ctr].[dbo].[customers]
But i get this error :
Msg 18456, Level 14, State 1, Line 5
Login failed for user 'tal'.
My username and password are the same in both servers
Many Thanks
June 30, 2019 at 3:11 pm
Check how the linked server is setup and configured - there is a problem with the configuration and is not allowing you to connect.
Jeffrey Williams
Problems are opportunities brilliantly disguised as insurmountable obstacles.
How to post questions to get better answers faster
Managing Transaction Logs
June 30, 2019 at 7:28 pm
If you are using SQL authentication (shame on you :-p) something is messed up in the linked server as Jeffrey Williams said.
If you are using kerberos authentication, you need to connect to the instance by name, and not IP address and also enable the SQL account for delegation
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply