Re: SQL Logins using local user accounts on a clustered instance.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Srini (Srini_at_discussions.microsoft.com)
Date: 07/20/04 

Date: Tue, 20 Jul 2004 11:29:01 -0700

Actually I did everytihng on my server. I picked the virtual instance and added the domain account to it as a login. That part is working fine. I was just trying to know if it is possible to add local account on node as a login for the SQL. I will create the same windows local user account on all nodes(servers) of the cluster. So it sould not be a problem for failover? I am just trying to know. I am trying to know this for information only.

Thanks.

"Rodney R. Fournier [MVP]" wrote:

> First of all the SQL Book Online are wonderful. Very, very helpful. More
> answers below...
>
> Cheers,
>
> Rod
>
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering
>
> "Srini" <Srini@discussions.microsoft.com> wrote in message
> news:DE45B74E-0D9D-469A-8D6F-B31B439FBDEC@microsoft.com...
> > The error displayed is as follows
> >
> >
> >
> > 15401 Windows NT user or group LocalServerName\UserAccountName has not
> found. Check the name again.
>
> It does not lie, the local user is not found. Create it in the Domain and
> then add it to SQL. If you use the local machine that could be a problem
> with failover, so always select a domain account. I have not tired using a
> lcoal clustered account for SQL.
>
> >
> >
> > I got a basic question here. When we have a clustered SQL server, we will
> have the instance of the SQL server/database running on each server which
> are part of the cluster. So, when we add the userShould we pick the SQL
> server instance or local instance?
>
> You always use the Virtual Instance name. But in your case the user is from
> the Domain right? So pick the domain account.
>
> >
> > How did you add the local account? Is there a step-by-stepo instruction
> that I can use?
>
> I don't think you can add a local account, use a domain account. Maybe a SQL
> MVP will know for sure. The books online have the steps to adding a user.
>
> >
> > Thanks,
> > Srini
> >
> > "Rodney R. Fournier [MVP]" wrote:
> >
> > > SQL allows you to create either a SQL login or re-use an already
> existing
> > > NT/AD account. More answer inline below...
> > >
> > > Cheers,
> > >
> > > Rod
> > >
> > > MVP - Windows Server - Clustering
> > > http://www.nw-america.com - Clustering
> > >
> > > "Srini" <Srini@discussions.microsoft.com> wrote in message
> > > news:F36329F9-6CA9-41B4-9410-F60D812AC4D8@microsoft.com...
> > > > Hi,
> > > >
> > > > We have a clustered SQL server 2000. I would like to know If it is
> > > possible to create SQL login for a local NT useraccount using windows
> > > authentication on that clustered server. And later I would like to use
> that
> > > login as a user for one of the databases.
> > > >
> > >
> > > Yes, create the account under windows and then under Security - Logins
> in
> > > SQL. You can even browse for the user account to add. Use the third tab
> > > Database Access (of SQL Server Login Properties) to give DB access and
> grant
> > > a role as a user in that DB. Remember SQL has logins, DBs have users.
> > >
> > > > I could successfully add a domain user account as SQL Login using
> windows
> > > authentication. But when I tried to add the Local windows NT user
> account as
> > > an SQL login, it comes back and says something like "Can not find the
> > > user..."
> > > >
> > >
> > > Hmmmm, you should be able to add either a domain or local user account.
> I
> > > just did that on one of my SQL Clusters successfully. What is the error
> > > number in the event log? Do you have Admin rights on the box and SQL?
> > >
> > > >
> > > > If anyone knows the answer please let me know.
> > > >
> > > > Thanks in advance.
> > > > Srini
> > >
> > >
> > >
>
>
>

Relevant Pages

  • It can be Done
    ... I just installed a 3 SQL Server 2005 instances on a 2 node Active/Passive cluster. ... IWiz will then offer you a choice of Group on where you can install teh Fail Over Clustered Instance of SQL. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Create SQL cluster on 2003
    ... Since you are in a cluster configuration, ... Microsoft SQL Server MVP ... We only about about 20 databases - all ... Move Databases Between Computers That Are Running SQL Server ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL Server 2005 Cluster Setup Quiz
    ... the first instance on the cluster. ... SQL Server 2005 failover cluster has been installed? ... drive of a SQL Server 2005 failover cluster installation? ...
    (microsoft.public.sqlserver.clustering)
  • Re: Unable to Apply SP4 to SQL 2000 Cluster (new Node)
    ... Rebuild the node in the failover cluster. ... Scenario 1" in SQL Server 2000 Books Online. ... This setup process updates to SP4 only the binaries on the new ...
    (microsoft.public.sqlserver.clustering)
  • Re: A complicate cluster configuration...
    ... The SQL Server 2000 EE will be running just in one node, ... It is possible that an operator can manage the cluster from a terminal ... > and SFTPs them to a remote machine. ...
    (microsoft.public.windows.server.clustering)