On Thu, Jul 1, 2010 at 9:51 AM, Jason King <[email protected]> wrote:
> From what > I've read, you almost always want to avoid SQL Server authentication > if possible, and use Windows Authentication only. Not sure where you read that, I've always read the exact opposite. :-) > This is what I'm > doing. I'm trying to create a Windows Account for OpenBD, and creating > a login in SQL server for that account. > Can you at least try it with SQL Server authentication so we can see if that's actually the issue? > > So I need to figure this out using Windows Authentication..... It > already works for me with SQL 2000 Server.. > Are you sure you have SQL Server 2008 configured correctly? Back in the olden days I recall there being a setting of some sort where you could tell SQL Server to ONLY accept Windows authentication, as opposed to "mixed mode" which will accept either, and using pure Windows authentication as opposed to using mixed mode are two completely different beasts. My money's on this being a configuration issue of that nature on the SQL Server side, since as you pointed out you at least know it's hitting the server and trying to log in. Is there an express version of SQL 2008? If so I can download it and try things later today, but I don't have a SQL Server 2008 box handy. -- Matthew Woodward [email protected] http://blog.mattwoodward.com identi.ca / Twitter: @mpwoodward Please do not send me proprietary file formats such as Word, PowerPoint, etc. as attachments. http://www.gnu.org/philosophy/no-word-attachments.html -- Open BlueDragon Public Mailing List http://www.openbluedragon.org/ http://twitter.com/OpenBlueDragon online manual: http://www.openbluedragon.org/manual/ mailing list - http://groups.google.com/group/openbd?hl=en
