0
I have services (WCF) that do searches in Active Directory to provide data to various applications that use Microsoft Membership Provider, and also need some of this information in some queries in a database Sql Server 2008, I generated a dll and registered it on my Sql server, but I have a performance problem with my services, with the number of users increasing the services stop frequently, after some reports noticed that the use of memory increases exponentially. I would like to know what is the best practice to communicate with Active Directory, register a Dll in Sql Server or use OLE DB Provider for Microsoft Directory Services ?
Basically I have a layer with WCF services where I have several methods, Getuserbyid, Getuserbyname, Usersinrole, Getrolesbyuser, Getusergroups, Getusersingroup, etc.
In my database I have a DLL that refers to this service, and I use these methods as a function of the database to search for the information I need and thus filter my data.
This is a BI site, I have different levels of access to information, and all security is based on Active Directory and should be managed by the information security team. The purpose of my question is to know if it is a good practice to use this DLL with the functions in Sql Server, or if I should do the LDAP searches directly in my queries within the database.
You have code examples to put in the body of the question?
– Leonel Sanches da Silva
Man, it would be tricky to show code because it would be a lot of stuff, my biggest concern is about best practice and best performance.
– Rafael Carvalho
what version of the server?
– Pablo Tondolo de Vargas
Using the local administrator account on windows server 2012, you can connect to
internal database(\.\pipe MICROSOFT##WID tsql query), I don’t know if you’ll find what you’re looking for.– Pablo Tondolo de Vargas
what you do is more or less http://www.codeproject.com/KB/system/getuserfrmactdircsharp.aspx?display=Print?
– Pablo Tondolo de Vargas
The servers are Windows Server 2008, I can’t access with the local Adm account, the data I search using LDAP on .net. and register a Dll in Sql Server to be able to use my methods within Sql Server.
– Rafael Carvalho
It’s just that without some code it’s hard to help you.
– Leonel Sanches da Silva