Any problems connecting to SQL Server 2008 through SDAC?

Jeff Gallant · Post by **Jeff Gallant** » Wed 22 Oct 2008 16:21

I'm using the trial version of 4.50.0.36 through Delphi 2006 professional.

I was OK with SQL Server 2005 express but have upgraded to SQL Server 2008 developer.

Now, I can't seem to get access to my database with SQL Server authentication although I can with Windows authentication.

Are there any known issues with SDAC and SQL Server 2008 or should I persevere trying to sort this out through the SQL Server security model which I confess is challenging me. I suspect it's the latter but I thought I would ask.

The user I'm trying to connect with was brought across when I attached the old database but the server login is new.

Best wishes

Jeff

Challenger · Post by **Challenger** » Fri 24 Oct 2008 13:09

We have not encountered such problems before. Can you connect using Management Studio?

jrheisler · Post by **jrheisler** » Wed 26 Oct 2011 00:31

I noticed the same problem trying to login to 2008 R2.

I am using the most current demo UniDacDemo.exe.

Here is a screen shot of my login for MS SQL Server 2008 R2:

So, how do I login with the demo, which tells me "login failed for jrheisler-PC\jrheisler".

AndreyZ · Post by **AndreyZ** » Wed 26 Oct 2011 09:34

I have answered you here: http://www.devart.com/forums/viewtopic.php?t=22401