dbTalk Databases Forums  

SQL Logins using local user accounts on a clustered instance.

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.clustering SQL Logins using local user accounts on a clustered instance.

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss SQL Logins using local user accounts on a clustered instance. in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Srini
 
Posts: n/a

Default SQL Logins using local user accounts on a clustered instance. - 07-15-2004 , 05:50 PM





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.

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..."


If anyone knows the answer please let me know.

Thanks in advance.
Srini

Reply With Quote
  #2  
Old   
Rodney R. Fournier [MVP]
 
Posts: n/a

Default Re: SQL Logins using local user accounts on a clustered instance. - 07-15-2004 , 06:40 PM





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 (AT) discussions (DOT) microsoft.com> wrote

Quote:
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.
Quote:
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.

Quote:
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..."
Quote:
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?

Quote:
If anyone knows the answer please let me know.

Thanks in advance.
Srini



Reply With Quote
  #3  
Old   
Rodney R. Fournier [MVP]
 
Posts: n/a

Default Re: SQL Logins using local user accounts on a clustered instance. - 07-19-2004 , 05:24 PM


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 (AT) discussions (DOT) microsoft.com> wrote

Quote:
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.

Quote:

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.

Quote:
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.

Quote:
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 (AT) discussions (DOT) microsoft.com> wrote in message
news:F36329F9-6CA9-41B4-9410-F60D812AC4D8 (AT) microsoft (DOT) 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



Reply With Quote
  #4  
Old   
Rodney R. Fournier [MVP]
 
Posts: n/a

Default Re: SQL Logins using local user accounts on a clustered instance. - 07-20-2004 , 01:38 PM


I have not tested it, so I really have no idea. Maybe someone else knows?

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering

"Srini" <Srini (AT) discussions (DOT) microsoft.com> wrote

Quote:
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.
Quote:

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 (AT) discussions (DOT) microsoft.com> wrote in message
newsE45B74E-0D9D-469A-8D6F-B31B439FBDEC (AT) microsoft (DOT) 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 (AT) discussions (DOT) microsoft.com> wrote in message
news:F36329F9-6CA9-41B4-9410-F60D812AC4D8 (AT) microsoft (DOT) 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



Reply With Quote
Reply

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top