Yes i restart the SQL server and i changed both SQL Server Service and agent as well

Yes, i changed the password also.

yes new account has been added to local administrator group.

Hi,

I am also facing the same issue in my production database whenever right click database >> Task >> restore >>database.

Server configuration :

32 GB RAM

64 bit O/S

2 processors

Intel(R) Xeon(R) E5620...

Thanks.

Thanks Ram...

many thanks...

Its for business requirements...

Eg:

1) Source database 'A' already configured log shipping to Destination database 'B' (Its working fine)

2) Same Source database 'A' need to be configure merge replication to other...

Thanks suresh...

thanks suresh, but we have around 600 databases in one particular instance.

So database by database right click and generate the script is very painful work.

Is it having any scripts along...

Thanks suresh,

Successfully executed the script and also executed the "sp_help_revlogin" but database roles not affected

Is it having any scripts to transfer roles also.

what is the meaning for the below one

"Timeout value for determining partner outage"

Ex:ALTER DATABASE [AdventureWorks] SET PARTNER TIMEOUT 20;

Hi Mohammed,

Yes, we are going to change 64 bit OS.

yes robert, now i can able to mirror with different endpoint port.

Thanks for your helping...

Robert, Pls find the attached one for more clarification.