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 |
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
 Posted - 2010-05-21 : 02:20:58
|
| Hi, Problem with the Linked Server.On the src server from which the Linked server is fetching/pulling the data, the DTC (distributed Transaction Coordinator) service is running under Network Service service account.On the src server we have 2 databases db1 and db2 and Linked Server default database after loging is "db1".Now from target server, when i say select * from <linkedservername>.<db1>.dbo.<tname> , i am getting the result.But when am saying the i.e trying to access the "db2" on the same source server select * from <linkedservername>.<db2>.dbo.<tname> , i am getting below ERROR.Server: Msg 7391, Level 16, State 1, Line 1The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction.OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x8004d00a].[OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator. ]i checked the Linked server properties Under Security TabBe made using the login's current security context radio button is selected.Under Server options -Data Access-RPC-RPC Out-Use Remote Collation are checked.Do we need to create another Linked Server?Do we need to give any permission on db2 to Linked Server?Any immediate fix???Thanks in Advance. |
|
|
|
|
|
Linked server problem