Sql server7 Transaction Replication Error 18452, 08001, 3726

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.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Sql server7 Transaction Replication Error 18452, 08001, 3726

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-09-20 : 09:18:33

kalpaj writes "sir

i am trying to do Transaction replication i am having three
windowsNT4 & one windows 2000 server. all are stand alone server.
server name is tdwneat, tdwuser, tdwdba, tdwiris (win 2000 server)

i have loaded sql server7 on all machine.
tdwneat server is distributor & publisher i am trying to
replicate tdwuse & tdwdba as push replication.but
is is giving error as follows

Distrtibution Agent Error Details
The process could not connect to Subscriber 'TDWDBA'. 18452
rror information

ODBC		Source  	Number
Data Source	TDWDBA	        18452

The process could not connect to Subscriber 'TDWDBA'. 08001
Error information

ODBC		Source 			Number
Data Source	ODBC Sql srever Driver	08001

Could not drop object 'authors' because it is referenced by a FOREIGN KEY constraint. 3726
Error information

ODBC		Source 		Number
Data Source	tdwuser		3726

if i go to distribution agent
i go to properties of the multiple replication
it is showing me

category REPL-Dirtibution
owner distributor_admin (what is all for & which i select)
sa
TDWNEAT\administrator

before start repliation i loging to all server as administrator.
can you help me in this matter i want to replicat my company`s
main server as soon as posible.

one more thing that i go for immidiate update it is asking me
that timestamp calumn will automatically add the table &
insert, select statment will get problem.

there is any other option is there from where i can do
immdidiate update without adding timestamp column.

if you give some tips on this error then it will be great
help for me.

thank you
kalpaj"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources