Monday, July 22, 2013

[SQL Server 2008 issues] SQL erroring for windows authentification when mixed is selected

[SQL Server 2008 issues] SQL erroring for windows authentification when mixed is selected

SQL erroring for windows authentification when mixed is selected

Posted: 21 Jul 2013 07:13 PM PDT

Login failed for user ''. Reason: An attempt to login using SQL authentication failed. Server is configured for Windows authentication only. [CLIENT: 10.5.34.152]I am getting the above error over and over in my SQL log but SQL is 100% enabled for mixed mode. I have restarted SQL to ensure it is and also ran SELECT SERVERPROPERTY('IsIntegratedSecurityOnly'); which returns 0.Any idea where this error might of appeared from?

Do you allow Entity Framework? / Database Security Permissions

Posted: 21 Jul 2013 11:37 AM PDT

I know this topic has been talked a lot but, i'm having this issue right now, the Developers team at work want to start using Entity framework, and that would mean to low down database security because we'd have to assign permissions over tables or views. Untill now, we only assigned permissions on SPs. I know that EF can be used with SPs but developers are like hypnotized by microsoft and say all the time that using EF is more performant than SPs and bla bla bla. I'm only worried on having to trust our DBs security a little more on what they develop because of the fact that i won't be seeing querys like before. I have to give them an answer about this issue, so:my question, FOR DBAs: Do you allow EF on your databases and assigning permissions over tables or views? What is your experience with it as a DBA?Thanks!
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog