?
Solved

mirroring on the mirror server

Posted on 2011-03-15
4
Medium Priority
?
506 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 2000 total points
ID: 35136221
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Suggested Courses

764 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