Solved

mirroring on the mirror server

Posted on 2011-03-15
4
481 Views
Last Modified: 2012-05-11
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
Comment
Question by:shanj
  • 2
4 Comments
 
LVL 14

Expert Comment

by:Daniel_PL
ID: 35136115
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
 

Author Comment

by:shanj
ID: 35136196
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
 
LVL 9

Expert Comment

by:kaminda
ID: 35136200
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
 
LVL 14

Accepted Solution

by:
Daniel_PL earned 500 total points
ID: 35136221
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question