Re: More SQL Clustering Fun

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

On Jul 22, 11:52 am, Ryan McCauley
<RyanMcCau...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
Have you confirmed that the cluster proxy account has the rights in AD to
join a computer with the SQL Virtual Server name to the domain? We ran into
this problem because our network group had created a computer with that name
in the domain, but hadn't granted rights to join it to the right account. Our
cluster runs as SQL_Cluster_Proxy (note - not SQL_Proxy, the account the runs
the actual SQL service), and granting rights to this user allowed it to join
the domain successfully.

This is new to SQL 2008/Server 2008, BTW - earlier versions of Windows or
SQL just needed to create the Virtual Server name in DNS - the new versions
actually need to add a machine in AD.

Ryan:

Thanks for the suggestion. It's something good to check. If I'm
understanding you correct. The account that the SQL Server Service
runs as has to have rights to add a computer account to the domain. In
our case the Computers OU. I created a test account for the SQL
Server Service that was in the domain admins group for the domain in
question. I then ran the installation and things still failed.
Am I understanding your suggestion correctly? Please advise. I
really do appreciate the suggestion. Thanks again.

Drew Flint
Plex Systems
.

Relevant Pages

  • Re: Default or named instances??
    ... this with SRV records, i didnt see a _sql records, lots of other types.. ... I've setup the cluster and tried to install the second instance as ... For each instance I need a virtual server name and an instance name ... The second named instance is accessible by the new virtal servers' name ...
    (microsoft.public.sqlserver.clustering)
  • Re: Default or named instances??
    ... The SQL alias name becomes the service name. ... It has to be a named instance. ... I will have to disagree with the analogy you gave though about treating the cluster as a single system and that's exactly what I'm trying to resolve here. ... According to your explanation about the relationship between SQL instance and virtual server I would change the analogy to say I could treat the VIRTUAL SERVER as I would a single system. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Cant get SQL 2000 installed on new node in Cluster
    ... You can apply a service pack to a new node without taking the Virtual SQL ... server offline. ... When the install is asking for a virtual server name, ... So which of the two virtual server names do we use: the one for the MSCS cluster or the one for the SQL cluster? ...
    (microsoft.public.sqlserver.clustering)
  • Re: Default or named instances??
    ... I did see an SRV record though that has predefined services but no SQL. ... It has to be a named instance. ... I will have to disagree with the analogy you gave though about treating the cluster as a single system and that's exactly what I'm trying to resolve here. ... According to your explanation about the relationship between SQL instance and virtual server I would change the analogy to say I could treat the VIRTUAL SERVER as I would a single system. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Default or named instances??
    ... SRV record though that has predefined services but no SQL. ... I've setup the cluster and tried to install the second instance as ... It has to be a named instance. ... instance and virtual server I would change the analogy to say I could ...
    (microsoft.public.sqlserver.clustering)