Posted by: Colin Smith
Rant, SQL Server
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.