SQL Failover Cluster w/o Domain
Results 1 to 3 of 3

Thread: SQL Failover Cluster w/o Domain

  1. #1
    Senior Member Blunted One's Avatar
    Join Date
    Dec 2005
    Posts
    183

    Question SQL Failover Cluster w/o Domain

    I am setting up a failover cluster for SQL (Principal, Mirror, Witness). Everything seemed to be in order, until I began working on the servers they gave me and noticed that I am not joined to the companies domain. As anyone with MS SQL experiance knows that SQL doesn't like to play nice with other computers that are not on a domain and there in lies my problem.

    I am unable for the life of me to get the 3 machines to talk to each other (by which I mean syncronize). All settings are correct, everything that might block communication is turned off. But alas I still get the same errors every time complaining that it cannot find/connect to the other servers (which is BS and I know the error msgs in SQL are usually misleading).

    The only way I have found so far to accomplish this task (since they won't let me join the computers to their domain) is to create certificates.

    Is this really the only way? Is there any way around this or perhaps someone has some reading material for me to look at?

    Thanks in advance for any insight.

    More INFO:

    I even created a dns suffix (test.com) so that perhaps I could scoot around this non-domain issue, but alas no. I was also told not to make any of the servers into domain controllers, because of possible unforseen issues on their network (I am on a vlan). What can I do to get this up and running? I hate making certificates (I am also inexperianced in creating them) so I am asking for your insight on either how to do this quickly or perhaps a way around it.

    I have two Win2K3 SP2 standard application servers (principal and mirror) and one XP SP2 (witness)

    If I missed anything just tell/ask me and I'll provide it ASAP.
    It's not a war on drugs it's a war against personal freedoms!

  2. #2
    Senior Member Blunted One's Avatar
    Join Date
    Dec 2005
    Posts
    183
    So yesterday I taught myself how to write up certificates for SQL and after a while I was able to get everything working.

    Time and patience can be keys when working with SQL and its command sequences for creating certs.

    I was wondering if it is at all possible to modify certs after they are created? What I am specifically asking about is can certs be modified to entend out their exp. date? Or do I have to start all over again?
    It's not a war on drugs it's a war against personal freedoms!

  3. #3
    AO übergeek phishphreek's Avatar
    Join Date
    Jan 2002
    Posts
    4,325
    Quote Originally Posted by Blunted One
    So yesterday I taught myself how to write up certificates for SQL and after a while I was able to get everything working.

    Time and patience can be keys when working with SQL and its command sequences for creating certs.

    I was wondering if it is at all possible to modify certs after they are created? What I am specifically asking about is can certs be modified to entend out their exp. date? Or do I have to start all over again?
    As far as I know, you'll have to recreate the cert. Once it has been issued, you can use it, revoke it or wait till it expires. It's not something that can be changed. That is by design.
    Quitmzilla is a firefox extension that gives you stats on how long you have quit smoking, how much money you\'ve saved, how much you haven\'t smoked and recent milestones. Very helpful for people who quit smoking and used to smoke at their computers... Helps out with the urges.

Similar Threads

  1. Windows Error Messages
    By cheyenne1212 in forum Miscellaneous Security Discussions
    Replies: 7
    Last Post: February 1st, 2012, 02:51 PM
  2. SQL Tutorial – Basics
    By mikester2 in forum Other Tutorials Forum
    Replies: 5
    Last Post: January 31st, 2005, 01:16 PM
  3. SQL Tutorial
    By ch4r in forum Other Tutorials Forum
    Replies: 5
    Last Post: January 18th, 2005, 08:20 AM
  4. Heads Up - Cumulative Patch for Microsoft SQL Server (815495)
    By CXGJarrod in forum Microsoft Security Discussions
    Replies: 0
    Last Post: July 23rd, 2003, 11:00 PM
  5. requirements for a .ca website?
    By Krimlin in forum Miscellaneous Security Discussions
    Replies: 3
    Last Post: June 16th, 2003, 09:26 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •