SQL Database Limiting Connections

[hennessy1]

I have a sql database and a third party program that I use to connect to that database and interact with it. How can I tell if MS SQL is limiting my connections or the third party program. I checked under the Connection properties and it is at unlimited is that the only place I would need to check for SQL?

 

[GaryJohnson]

One way to check is to use SELECT @@MAX_CONNECTIONS AS 'Max Connections'

http://msdn.microsoft.com/en-us/library/ms179874.aspx

 

[hennessy1]

I did that query and got 32767 as the max connections. So would that mean it is the app that is limiting it?

 

[LokutusofBorg]

Is SQL running on Windows Server? If so, then yes you need to look at the app...

The only things that could be limiting it on the SQL side are SQL Dev Edition, or running a Windows client OS, both of which limit you to 10 connections, I think.

 

[hennessy1]

The app is installed on each workstation but does not have to be running on the server for it to work. I am running sql standard on windows server. Just out of curiousity is there a usual name for a config file for apps that use sql? By that I mean for apps that work with sql do they have a standard file name that keeps the config settings?

 

[LokutusofBorg]

If this is a standard .NET app then you will generally find a .config file in the executable's directory, but if this is not .NET then all bets are off. Sometimes you'll see a separate CONFIG folder, sometimes a .conf or .cfg file.

In the case of an app that is limiting connections which is a form of monetization (pay more and you get more concurrent connections) then they will encrypt their config and you'll have zero luck trying to muck with it.

 

[hennessy1]

I know that before installing the upgrade there was not this problem but after their upgrade it seemed to resurface.

 

[rasczak]

Was the upgrade a major upgrade? Is it possible you need to reactivate your license?

 

[hennessy1]

I will try that. Any generic way of checking that or just under the 3rd party properties help and about section?