• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 517
  • Last Modified:

mirroring on the mirror server

Hello anybody!
         i am mirroring a database.
1. Full backup with restore of log, with norecovery --ok
2. when i launch mirror from task, and when i try to connect to the mirror server (Database)

i get this error failed to conect to the server
login failed for user ......

User has all acess + roles...etc.

Thanks
0
shanj
Asked:
shanj
  • 2
1 Solution
 
Daniel_PLDB Expert/ArchitectCommented:
Are you trying to connect to mirrored database?
If so it's not possible to connect to mirror database and query it. If your login has that database as it's default it's the reason why it can't get connected.
0
 
shanjAuthor Commented:
NO..NO not trying to query a mirror db

I am implementing mirror.

when i go to the Mirror Server Instance (task -mirror)

give the name of the server, and click on the connect tab.
the error comes at once

0
 
kamindaCommented:
You can not log in to the mirrored database as it is not accessible. Anyway if you really want to access the mirrored database you can take a snapshot of the mirror and create a database from that to access the mirrored server data.
0
 
Daniel_PLDB Expert/ArchitectCommented:
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now