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

From: Rodney R. Fournier [MVP] (rod_at_die.spam.die.nw-america.com)
Date: 07/19/04 

Date: Mon, 19 Jul 2004 17:24:33 -0500

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

  • Re: Cluster IP Address change
    ... I've heard the same story from...after not hearing this in 2 years of SQL ... After changing sql ip address resource & sql name resource came online but ... sql server resource was failing. ... MVP - Windows Server - Clustering ...
    (microsoft.public.sqlserver.clustering)
  • Re: Sql Server 2005 Dev. Ed. on Windows Server 2003
    ... Check out this KB which is about transferring Logins: http://support.microsoft.com/kb/246133 ... Also, since this is running on a newly installed Windows Server 2003, is ... them from your older SQL Server instance to the newer one. ...
    (microsoft.public.sqlserver.setup)
  • Re: New Windows Infrastructure
    ... vendor's application runs on windows with an SQL database and I will also need a web server for a separate module which will allow our customers to access account data online. ... I would think that if the app runs on windows, I do not need the citrix server. ... It makes sense to have separate DCs though, because let's say you want to upgrade your Active Directory in two weeks time, with separate DCs it's easy, but if you've got a bunch of apps installed it could be a nightmare. ...
    (microsoft.public.win2000.setup_deployment)
  • Re: 4 Queries about DB clustering
    ... I support the Professional Association for SQL Server ... First you install MSCS (Clustering). ... >> on a single logical device physically connected to all host nodes. ...
    (microsoft.public.sqlserver.clustering)
  • How can I avoid using SQL Authentication with the Office Web Parts?
    ... We have a machine running Windows 2003 Server, IIS 6, and Windows SharePoint ... We are using Office Web Parts on several Web ... Part pages to display data retrieved from a SQL Server (SQL 2000 SP3 running ...
    (microsoft.public.office.developer.web.components)
Loading