I'm currently experiencing some trouble, seemingly because my application refuses to connect to the database if there is already another connection open from the same user (but in a separate process).
Based on my observations, it doesn't seem to matter how many or few other users are connected, and
@@MAX_CONNECTIONS is set to 0 (unlimited).
Is there any way such a connections-per-user limitation may have been defined on the database, and if so, how can I turn it off?
Here is my connection string:
[db] sql=MS SQL provider=SQLOLEDB.1 data source=foo\bar connection=Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=foobar
As you might be able to discern from the above, we are connecting to the database using Microsoft OLE ADO. The application is an old VB6 legacy program.
By "refuses to connect" I mean that the method
Open on the
ADODB.Connection object fails.
Sadly, there is currently no log of the error output from this method in the production environment. I'm currently waiting for a patch to the application to be applied, to see if I can get extended information here.