how to validate a windows login in domain through SQL queries

Question

Post reply

how to validate a windows login in domain through SQL queries

SSRfromChennai

Ten Centuries

Points: 1120
More actions
March 28, 2012 at 7:20 am

#391896

how to validate a windows login in domain through SQL queries

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323518 More actions · Answer 1

sureshrajan (3/28/2012)
how to validate a windows login in domain through SQL queries

not sure what you mean...do you want to test if mydomain\sureshrajan has a login or has access to a server/ database?

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

SSRfromChennai Ten Centuries Points: 1120 More actions · Answer 2

Yes. When you create a login in SQL, it should validate through a script whether it is valid windows login.

Lowell SSC Guru Points: 323518 More actions · Answer 3

the CREATE LOGIN process already does that.

for example if you try this command:

CREATE LOGIN [fakedomain\fakeuser] FROM WINDOWS WITH DEFAULT_DATABASE=[master]

you get this error:

Msg 15401, Level 16, State 1, Line 1
Windows NT user or group 'fakedomain\fakeuser' not found. Check the name again.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Perry Whittle SSC Guru Points: 234013 More actions · Answer 4

SSRfromChennai (3/28/2012)
how to validate a windows login in domain through SQL queries

use the stored procedure xp_logininfo

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

Orlando Colamatteo SSC Guru Points: 182279 More actions · Answer 5

Perry Whittle (3/28/2012)
SSRfromChennai (3/28/2012)
how to validate a windows login in domain through SQL queries
use the stored procedure xp_logininfo

xp_logininfo only validates windows accounts after the SQL Server Login is created.

There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato