ODBC Error: SQLState 28000 & Server Error 18452

Try sp_adduser to make sure that the login is identified as trusted by SQL Server.

Link for sp_adduser : http://msdn2.microsoft.com/en-us/library/ms181422.aspx

RajKasi-MSFT at 2007-9-3 >

Hi ,

I am facing Same problem and it is as follows:-

There are two servers ‘A’ and ‘B’. At server ‘A’, there is installed Window server at server ‘B”, there

is installed Window Server2000. And both servers have SQL SERVER 2000. I have created link server from A to B. I have to insert data into table of server ‘B’ from server ‘A’. When I used directly insert command like

Insert into [server name (B)]. [Database]. [Owner].[table name]

Select * from [server name (A)]. [Database]. [Owner].[table name]

The data is inserted successfully.

But when I created trigger (for insertion) on table of server (A) (because I want as there is insertion in the table of server(A), rest

Records that are not in the table of server (B) , are automatically inserted into the table of server(B)).

The Insertion is not complete and there is shown system message which is as follows:-

“Server: Msg 7391, Level 16, State 1, Procedure rms_trn_con_details_insertion, Line 6

The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction.

[OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator. ]”

I have searched in Google , I found that there are problems in heterogeneous system.

But till today, I have no solution for it. Temporary, I find solution through Job Scheduling.

Try to find out solution for this problem.

NikhilChaturvedi at 2007-9-3 >