Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Replication (2008)
 creation of mirroring database

Author  Topic 

scazikiss
Starting Member

12 Posts

Posted - 2013-03-27 : 06:47:50
hi,
from the principal serveur , i'd like to creation a mirroring database and when it is asking to connect to the mirroring serveur , i get the error message:

"login failed.login IS FROM an untrusted domain AND cannot be used WITH windows authentification"

just want to say that 2 servers are not in a domain , just a workgroup
any help please.?
Thanks

regard

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2013-03-27 : 13:35:47
Setup mirroring with a certificate.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

scazikiss
Starting Member

12 Posts

Posted - 2013-03-29 : 05:28:20
hello,
sorry but i see nothing about the "setup mirroring with certificate" that you talk about...

regard
Go to Top of Page

prett
Posting Yak Master

212 Posts

Posted - 2013-03-31 : 23:03:38
Check the solution from here: http://blog.sqlauthority.com/2012/09/06/sql-server-fix-error-cannot-connect-to-login-failed-the-login-is-from-an-untrusted-domain-and-cannot-be-used-with-windows-authentication-microsoft-sql-server-error-18452/
Go to Top of Page
   

- Advertisement -