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 |
|
Bill_C
Constraint Violating Yak Guru
299 Posts |
 Posted - 2011-03-31 : 02:58:12
|
I have two linked servers sql_A and sql_BI update a table in a database on sql_A, then once this has been done I want to set a flag in a table on sql_B to state the table on sql_A has been successfully updated.I have tried this with a straightforward SQL command such as:-UPDATE sql_B.mydatabase.myschema.mytableSET UpdateFlag = 1WHERE id = 1234 I get the following error:-The UPDATE permission was denied on the object 'mytable', database 'mydatabase', scema 'myschema'I have RPC set on both servers but the problem persists. |
|
|
ajthepoolman
Constraint Violating Yak Guru
384 Posts |
Posted - 2011-03-31 : 10:44:20
|
| Does the linked server need a specific user set up that mimics the one hitting sql_A? I have only done simple select statements from linked servers, so I am just throwing ideas out there. Since it specifically says UPDATE permission denied, I wonder about a user setting on sql_B.Hey, it compiles. |
 |
|
|
Bill_C
Constraint Violating Yak Guru
299 Posts |
Posted - 2011-04-02 : 08:17:44
|
| I have admin rights on both servers and thought I would automatically be able to change data due to this? |
|
|
|
Bill_C
Constraint Violating Yak Guru
299 Posts |
Posted - 2011-04-02 : 08:29:46
|
| I have also tried creating a stored procedure on the remote server which performs the same action through passing in the record number that needs to be updated.This also gives me the same message, UPDATE permission denied......I'm a little stumped on this one. |
|
|
|
|
|
|
Update permission denied on linked server?