A caoonection could not be established.....

Server A
SQL 2000
Win 2003
Server B
Sql 2005
Win 2003
Publications were created on Server A. Pull subscriptions were created
on Server B.
When the distribution agent is run on Server A, I get the message.....
A connection could not be established to R00S-SQLa.
Reason: Login failed for user 'SQLAdmin'
Please verify the SQL Server is running and check your SQL Server
registration properties (by right clickking on the R00S-SQLa node) and
try again.
There were two if us setting this up (we have 15 locations & & multiple
publications at each location). The same message appears when the
distribution agests are fired off at each location, with the exception
of...some have a difference of....'domain.com/sqladmin' rathen than
just 'sqladmin'.
I really do not want to delete/disable replication.
HELP!!!!!!
AHIA,
LArry....
I'm a newbie to replication but I had similar problems;
Use the ODBCPING.EXE to check the connection as I found that Packet filters
were blocking outgoing requests.
Also, Client Network Utility and the alias setup for the subscriber(s)
Dont use trusted connections for SQL Agents, I used SQL Auth and sa.
Probably wont help much but its a start.
TIM
"LPR-3rd" wrote:

> Server A
> SQL 2000
> Win 2003
> Server B
> Sql 2005
> Win 2003
> Publications were created on Server A. Pull subscriptions were created
> on Server B.
> When the distribution agent is run on Server A, I get the message.....
> A connection could not be established to R00S-SQLa.
> Reason: Login failed for user 'SQLAdmin'
> Please verify the SQL Server is running and check your SQL Server
> registration properties (by right clickking on the R00S-SQLa node) and
> try again.
>
> There were two if us setting this up (we have 15 locations & & multiple
> publications at each location). The same message appears when the
> distribution agests are fired off at each location, with the exception
> of...some have a difference of....'domain.com/sqladmin' rathen than
> just 'sqladmin'.
> I really do not want to delete/disable replication.
> HELP!!!!!!
> AHIA,
> LArry....
>
|||Tim,
Thanks....
ODBCPING.EXE -Sr00s-sqla logs in fine, but when I specify a user/pass
it fails.
Larry...