Problem connecting sql serversgreenspun.com : 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