Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
scripter.loco
Starting Member
1 Post |
 Posted - 2010-01-07 : 01:34:31
|
| Newbie question, I have a DB running in a server A and I have to implement a process (job) to keep updated a table in A with information coming from a server B. The admin of B has provided to me a view and he email me an user and pwd to access that view. What should be the right way to attack this problem?I was wondering if I should add the username provided in A and try to run a INSERT there, some like this: Insert into MyTable Select * from B.DBName.Ownername.ViewNamebut im getting the fol. msg: Access to the remote server is denied because no login-mapping existsAny comments on this would be appreciated. Rgds,Ps. Both DB are 2k5. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-07 : 01:37:36
|
| you need to set up linked server and use mapped logins as message suggestshttp://www.databasejournal.com/features/mssql/article.php/3691721/Setting-up-a-Linked-Server-for-a-Remote-SQL-Server-Instance.htm |
 |
|
|
|
|
|
Retrieving records from an external server