Login failed for user \.
I am trying to execute the following SQL Statement from MyServer...---------------------------------------------------------------------------DECLARE @NameSET @Name = SUSER_SNAME()--The @Name = 'Domain1\MyUserID'EXEC sp_AddLinkedServer 'YourServer', 'SQL Server'EXEC sp_addlinkedsrvlogin @rmtservername = 'YourServer', @userself = 'TRUE'SELECT * FROM YourServer.YourDB.DBO.YourTableEXEC sp_droplinkedsrvlogin @rmtservername = 'YourServer', locallogin = @Name---------------------------------------------------------------------------I am added as a user on YourServer and YourDatabaseOn the Select Statement an Error OccursServer: Msg 18456, Level […]
2004-01-29
4 reads