Problem connecting sql servers : LUSENET : SQL Server Database Administration : One Thread

I am new to sql server 7.0. I have to truncate a table after the replication process. But this table is lying on different server. I tried to configure linked server from the enterprise manager but could not find the remote server. Now I have added my remote server in the list of remote servers and my local server in the list of remote servers on the remote server.

Then I executed exec remoteserver.database.dbo.sp_sqlexec "select * from remote_server_table"

message came user "domain\NT username" is not defined as a remote login at the server.

when I tried to add my nt user name as remote login with exec sp_addremotelogin 'remote server' , 'domain\nt_user_name', 'domain\nt_user_name'

message came 'domain\nt_user_name' is not a local user

Please advise me what to do. Still I don't know either sp_sqlexec would be able to truncate my tables on the remote system or not.



-- Anonymous, June 29, 2001



The SQL Server Books Online entry on sp_addremotelogin talks about mapping a remote SQL Server login to a local SQL Server login. I don't think it is expecting NT logins with domain qualifiers. I believe that this is what is causing the error.

Hope this helps,


-- Anonymous, July 01, 2001

Moderation questions? read the FAQ