The Multifunctioning DBA

Aug 31 2011   10:00AM GMT

SQL Server Authentication

Colin Smith Colin Smith Profile: Colin Smith

I love when I am working with a Application team and they request an account to be created in order to have x access to y database on the server. The AD account gets created and I add that login to the server and map it to the database and give it the level af access that the application team has specified. Then I get a call saying that it is not working and I look in the logs and see that they are attempting to use SQL level authentication and not Windows. I mention that to them and they tell me that windows will not work with the application.

It just baffles me that people with the title of application and database architect do not have a basic understanding of authentication methods in SQL Server. I mean it is not that complex at a high level and we only have two methods for authentication.

All I can say is that if you ask for an account you need to know what type of account you need. The DBA may need to change the server to mixed mode and perhaps that is a major security concern on that instance so the DBA really does need to know this information. Please know what you need before you request it and if you are not sure go talk to the DBA. Most DBA’s are willing to help in order to get it done right the first time.

 Comment on this Post

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members comment.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: