November 5, 2007 at 3:42 pm
not sure if this is the correct forum for this or not but....
I need to authenticate a windows active directory user given a domain, username and password. I had written an assembly in vb.net but it used the system.directoryservices assembly which sql server 2005 won't let me import. Can someone point me in another direction?
Thx.
November 6, 2007 at 5:47 am
Without writing your own assembly, you could create a Credential for the SQL windows login and then try to access a network resource with it. If the username, password, or domain is no good, the operating system would let you know.
Look at "Credentials" in books online.
If that does not suit you, look at "UNSAFE assemblies" to allow you to load assemblies that are not in the SQL Server "safe" list. I am not a fan of doing anything unsafe in my databases.
Finally, (I say this a lot), you can create a web service to do your AD lookup on your login information. You can add any web service to your CLR procedure.
November 6, 2007 at 9:03 am
Thanks, I'll check into the credentials ... if that won't work for me, I'll look into the web services..
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply