Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jassie
Constraint Violating Yak Guru
332 Posts |
 Posted - 2014-02-08 : 23:33:13
|
| In a sql server 2008 database, the person that has dba access thinks the user security rights are controlled by the active directory. The .net application and database was written by contractors that are no longer with the company. There is no documentation for the appliucation.Thus we are trying to determine how the security is setup. I stepped through the .net 2012 code and found what active directory values were setup. However with sql server 2008, I do not know how to tell how the security is setup via active directory contols. Thus can you tell me and/or point me to a reference that will tell me how to accomplish my goal? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-02-08 : 23:35:08
|
| Just look at the users in the database and link that to the login to verify what type of account it is. If it's a SQL account, then it isn't using Active Directory. SQL authentication is what's typically used for application access, though Windows authentication is preferred.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
sql server using active directory