Database Mirror failover from Principal to Mirror

All,

I have two sql servers setup for Data Mirroring. when I do a failover to the
mirror server. The application can not connect to the database Mirror server
that has become the Principal server. I'm using sql authentication for the
application.

I have to drop the user in the Database and recreate it to allow it to
connnect to the database. Below is the error message:
The server principal "nyccs" is not able to access the database "jztest"
under the current security context.

What security context do I have to setup the data Mirror inorder to
automatically failover without any failures.

Thanks,
Naana.

--
Message posted via http://www.sqlmonster.com

.

Relevant Pages

  • Re: Cant start mirroring
    ... It raises that error because you did not restore your database on the ... mirror server in norecovery mode. ...
    (microsoft.public.sqlserver.setup)
  • Re: Another Mirroring Question
    ... Backup transaction log ... restore database on mirror server - make sure to set NO RECOVERY option, ... restore database transaction logs -- make sure again to set NO RECOVERY ... My mirror server db changes from "restoring.." ...
    (microsoft.public.sqlserver.clustering)
  • Re: The remote copy of database is not recovered far enough to enable database mirroring.
    ... How about taking a up to date transactional log backup from the primary and restore it in norecovery mode to the mirror database and then finalize the setting up your database mirroring operation? ... on my mirror server, I then received the error "The remote copy of ...
    (microsoft.public.sqlserver.replication)