SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


multiple domains in Idera??


multiple domains in Idera??

Author
Message
kerobin jesu
kerobin jesu
SSC-Enthusiastic
SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)

Group: General Forum Members
Points: 170 Visits: 375
Hi

Can any one help to find whether Idera Sqlsafe will work in different domain...?

In my office we have a sqlsafe respository and we have jobs running from diff instances with same domain...

Now i'm planning do the same to my other server which is in diff domain... do i have to set up a new repository for that server domain or it will work with my old repository itself..??

Thanks in Advance!
- Kerobin
Steve Jones
Steve Jones
SSC Guru
SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)SSC Guru (61K reputation)

Group: Administrators
Points: 61683 Visits: 19099
Kerobin,

I sent a note to Idera on this and hopefully they will respond soon.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
LC-392911
LC-392911
Grasshopper
Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)

Group: General Forum Members
Points: 15 Visits: 44

We run SQLSafe in our environment which has multiple untrusted domains. The official word I got from Idera is that no, they don't support SQLSafe agents communicating across domains but it's possible to make it work. Be aware tho that however you register/enter the server name determines how you reference that server down the road. Meaning if you specify the FQDN then you must use that name at all times in your backup job. Here's the response I got from Idera a while back regarding backing up db's across domains (if your domains are trusted then it's probably a nonissue). Hope this helps.

LC

The communication between all SQLsafe components uses authentication, which means that each service will only respond to communication coming from Windows user accounts it recognizes. Therefore SQLsafe will not communicate across non-trusted domains. The only SQLsafe connection that does not require Windows authentication is the connection the the SQLsafeRepository SQL database. Both the Management Service and Management Console can be configured to connect to the repository using SQL authentication, which can cross non-trusted domains.

Because SQLsafe components will only function inside a domain or among trusted domains, we recommend that you generate your licenses using the SQL instance name without the FQDN, such as SERVER\INSTANCE. If necessary, you could connect to the SQL instance hosting the SQLsafeRepository database using a FQDN.

The licenses are specific to the exact SQL instance name used to generate the license, so attempting to backup SERVER.DOMAIN.COM\INSTANCE when the license applied is for SERVER\INSTANCE will fail, or, if within the first 14 days, will use a trial license.

The following solution should contain the information necessary to assist you in overcoming this issue:

Solution Title:

How can I use SQLsafe to perform operations outside the local domain when there is not a domain trust?

Solution Details:

Non-trusted domains are not supported by the current release of SQLsafe, but it is often possible to make SQLsafe work in this situation.

To do this, install all of the SQLsafe components in the primary domain (The SQLsafe Management Service, Management Console, and Repository). Then install all components except for the repository in the second domain. Set the management service in the second domain to send status events back to the repository database in the primary domain. This allows the user to monitor the status of all jobs from their centralized console. Please note that the SQLsafe Management Console in each domain will be able to trigger ad-hoc backups and restores only to other servers in its own domain.


Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search