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.

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

[quoted text, click to view]
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.
[quoted text, click to view]

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.

[quoted text, click to view]
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..."
[quoted text, click to view]

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?

[quoted text, click to view]