I have a Delphi Application that is connected to a SQL Server db using SDAC component from DevArt, we have 200 installations of the software and only to a customer, with some users, I notice the following error:

"Connection is busy with results for another command" = "La connessione รจ occupata dai risultati di un altro comando".

SQL vers.: SQL Server 2008 R2 Express with filestream full enabled

My application create both db users and SQL account logins:

  1. creating a new user, then there aren't problems
  2. changing user code in my application, it means that another db user and SQL account login is created, I have the error
  3. this problem happens only with some users, not all ones

What I've already tried without luck:

  1. deleted and re-installed database
  2. uninstalled and re-installed SQL Server Instance
  3. checked users/account properties in SQL Server (all ok)

If you need specific infos please tell me

------------NEW INFORMATIONS------------

I checked better all the Instance properties from Studio Management and I've noticed that CPU's are not checked (see image below). CPU's flags not checked

Instead in all the other normal installations of SQL Server, I see filled checkboxes. Could it be the problem?

I hope this help you to help me...

sql-server delphi database-connection sql-server-2008-r2
Edit
Report