SQL Server Performance

local user for cluster

Discussion in 'SQL Server Clustering' started by fqiao70, Apr 7, 2004.

  1. fqiao70 New Member

    Hi all
    I have SQL server instance running on clustered servers( node1 & node2) I have to create a local user (node1user) to use the database, I want to know when failed over how to solve it without changing to node2user?????????

    Thanks a millon!
  2. Twan New Member

    Hi ya,

    I think that your only options are:
    - use a domain account
    - use a sql account

    you can't fail-over a local user to another machine, nor can you have the same SID on both

    cheers
    Twan
  3. fqiao70 New Member

    I have to use local users that application maual says. I have a virtual name, can it be created like virtualnodeuser?
  4. bradmcgehee New Member

    Ignore the instructions. First create the account as a domain account, and then add this account to the appropriate local groups on the servers in the node, and then use this domain account as the SQL Server account. It should work. If not, return your software, as it is poorly coded.

    -----------------------------
    Brad M. McGehee, MVP
    Webmaster
    SQL-Server-Performance.Com
  5. fqiao70 New Member

    no, it's actually a DMZ web server needs that local users, it doesn't belong to domain

    thanks
  6. Argyle New Member

    So it's the web service on another server that runs under a local user account and needs access to the sql server with windows authentication? Or how is your setup?

    If it's like above and you have no domain that can issue account delegation you need to create a local user on the webserver and the sql server nodes that have the exact same name and password.

    To get it to work with a cluster first add the local users on node1 as node1myuser, then failover and add node2myuser.

    Then in the connectionstrings you specify "Trusted_Connection=Yes" instead of username and password.

    Now the web service can access the cluster with this account. You need to set rights on both accounts in sql server for it to work after a failover as well.

Share This Page