Replication timeout

Hi all

I changed the 'sa' password and after that I got the following errors in the subscription job history:

1-Connecting to Subscriber 'SAONT045\REPORT'
2-Login failed for user 'sa'.
3-The process could not connect to Subscriber 'SAONT045\REPORT'. The step failed.
4-The job failed. The Job was invoked by User sa. The last step to run was step 1 (Run agent.).

What can I do??
Are there anything that I can do to solve that problem without recreate the replication again?

Thanks in advance

Manuel Rodriguesthis is just a hunch but is the sa password the same on both the publisher and subscriber.|||Sounds like you need to check security settings on the Distribution agent. I usually set it to impersonate using Windows authentication, since both SQLAgent services are running under the same Windows account (easier to maintain).|||Make sure the credentials used by SQL serer agent successfully logs into subscriber
Masanam

**SQL-DMO Error 21776

Hi
I want to change the sa password ,but following error appearred,
"Error 21776; SQL-DMO the name 'dbo' was not found in the user collection
,if the name is a qualified name,use [] to seperate various parts of the
name, and try again."
I'd be grateful if anybody can help me.Hi
Will these help:
http://support.microsoft.com/defaul...kb;en-us;218172
or possibly:
http://support.microsoft.com/defaul...kb;en-us;239133
John
"maryam rezvani" wrote:

> Hi
> I want to change the sa password ,but following error appearred,
> "Error 21776; SQL-DMO the name 'dbo' was not found in the user collection
> ,if the name is a qualified name,use [] to seperate various parts of the
> name, and try again."
> I'd be grateful if anybody can help me.
>
>
>

**SQL-DMO 21776**

Hi
I want to change the sa password ,but following error appearred( the picture
enclosed),
"Error 21776; SQL-DMO the name 'dbo' was not found in the user collection
,if the name is a qualified name,use [] to seperate various parts of the
name, and try again."
I'd be grateful if anybody can help me.DMO doesn't like NULL database owners. You may get this message when one or
more database owners are invalid due to a restore, attach or because the
database owner's Windows account was removed.
You can identify problem databases with:
SELECT name
FROM master..sysdatabases
WHERE SUSER_SNAME(sid) IS NULL
You can then use sp_changedbowner to specify a valid database owner login.
See the Books Online for more information.
Hope this helps.
Dan Guzman
SQL Server MVP
"maryam rezvani" <rezvani@.parskhazar.net> wrote in message
news:%23Yx%236ohKFHA.244@.TK2MSFTNGP12.phx.gbl...
> Hi
> I want to change the sa password ,but following error appearred( the
> picture
> enclosed),
> "Error 21776; SQL-DMO the name 'dbo' was not found in the user collection
> ,if the name is a qualified name,use [] to seperate various parts of the
> name, and try again."
> I'd be grateful if anybody can help me.
>
>
>