SQL Cluster - Help

  • Hi

    I am trying to setup the virtual cluster environment using VMWare.

    I have created two nodes with Windows 2003 RS x64.

    I have promoted one node to Domain controller and another node as member of the DC node. I have installed cluster services and configured it. I am able to ping the both nodes and able to access the shared drive. I have installed the MS-DTC as well. Now I am trying install the sql 2005 EE, I am getting the following message

    "The Virtual Server name you provided is not valid. To proceed, provide a virtual server name. For more information, see Instance Name, in SQL Server Books Online."

    Can anyone tell me what could be the issue? I just underestand from some articles that we cant install sql server on DC node, is it true?

    Thanks

    Shuaib

  • The virtual server name has to be a network name that does not currently exest on the network.

    heres a good white paper. http://www.microsoft.com/downloads/details.aspx?FamilyID=818234dc-a17b-4f09-b282-c6830fead499&DisplayLang=en

    Here is some info on Domain Controllers

    http://support.microsoft.com/kb/281662

    For security reasons, Microsoft recommends that you do not install SQL Server 2008 on a domain controller. SQL Server Setup will not block installation on a computer that is a domain controller, but the following limitations apply:

    -On Windows Server 2003, SQL Server services can run under a domain account or a local system account.

    -You cannot run SQL Server services on a domain controller under a local service account or a network service account.

    -After SQL Server is installed on a computer, you cannot change the computer from a domain member to a domain controller. You must uninstall SQL Server before you change the host computer to a domain controller.

    -After SQL Server is installed on a computer, you cannot change the computer from a domain controller to a domain member. You must uninstall SQL Server before you change the host computer to a domain member.

    -SQL Server failover cluster instances are not supported where cluster nodes are domain controllers.

    -SQL Server is not supported on a read-only domain controller.

  • How to check if the virtual server name exists in the network and how to add to network if it doesnt exists?

    Thanks

    Shuaib

  • You could look on your DNS server, or just "PING SERVER" at the command line.

    You specify the virtual server name and the sql setup registers it with your DNS server.

  • I tried several times to install sql 2005, the setup is unable to register the Virtual server name. I am keep on getting the message

    "The Virtual Server name you provided is not valid. To proceed, provide a virtual server name. For more information, see Instance Name, in SQL Server Books Online."

    Is there any way to manually add virtual sql server name to DNS?

    Thanks

    Shuaib

  • Are you setting your cluster up for production, or is this a test lab on an isolated network?

    Where is your DNS? You could try creating it there.

    I remember there being a checkbox saying 'DNS registration must succeed'. If that is there, you could try unchecking it to get the install to work.

  • I am trying to setup a test environment. I dont see any check box saying "register must succeed".

    Thanks

    Shuaib

  • Where is your DNS?

  • NODE1 is my DNS server.

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply