Any problems connecting to SQL Server 2008 through SDAC?

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Jeff Gallant
Posts: 5
Joined: Wed 22 Oct 2008 16:08
Location: London

Any problems connecting to SQL Server 2008 through SDAC?

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

I'm using the trial version of 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


Devart Team
Posts: 925
Joined: Thu 17 Nov 2005 10:53

Post by Challenger » Fri 24 Oct 2008 13:09

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

Posts: 48
Joined: Tue 25 Oct 2011 17:47

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".


Post by AndreyZ » Wed 26 Oct 2011 09:34

Post Reply