I was having some intermittent problems with the connector. When I turned on the connector it would soon be unable to connect to the SQL database.
I was thinking it maybe be had something to do with the SQL server limiting connections.
The code below will show you the amount of connections and how many on each database. I found it in this forum post
DB_NAME(dbid) as DBName, COUNT(dbid) as NumberOfConnections, loginame as LoginName FROM sys.sysprocesses WHERE dbid > 0 GROUP BY dbid, loginame
And this gives the total:
SELECT COUNT(dbid) as TotalConnections FROM sys.sysprocesses WHERE dbid > 0