Sudden logout / License connection limit crash when opening SQL Server projects (Scriptcase 9.9.014)

Scriptcase 9 General
#1

Hi everyone,

I am experiencing a severe issue with Scriptcase where I cannot open any project connected to a Microsoft SQL Server database.

Environment:

  • Scriptcase Version: 9.9.014
  • Edition: Enterprise Gold
  • PHP Version: PHP 8.1 (default for SC 9.9)

Issue Details:

  1. The Primary Issue: Whenever I attempt to open any project that uses a Microsoft SQL Server database, Scriptcase immediately crashes or drops the session, redirecting me straight back to the Scriptcase login screen.
  2. The Secondary Issue (License Connection Limit): Due to these repeated silent crashes/redirects, PHP sessions are left unclosed. Shortly after, I get locked out with the error:

“You have reached your license connections limit, please choose which session you want to disconnect to log in.”

What I Have Verified / Tested:

  • Database Connection: Testing the SQL Server connection directly inside Scriptcase returns OK.
  • Database Health: The target SQL Server database is running fine.
  • Internal Database: The internal SQLite database (nm_scriptcase.db) is intact.
  • Other Databases: Projects using MySQL / non-MSSQL databases open and work completely fine without any issues.

It seems like opening an MSSQL project causes a silent fatal error or memory crash in the background (possibly related to pdo_sqlsrv or memory limits), which instantly destroys the PHP session and forces a logout.

Has anyone encountered this issue on version 9.9.014 or know how to resolve it? Any advice on PHP configuration tweaks or driver fixes would be greatly appreciated.

Thank you!

#2

[SOLVED] SOLUTION: Scriptcase Project Crashes / Auto Logouts When Opening SQL Server Database

Hi everyone,

I wanted to update this thread and share that the issue has been fully resolved. The root cause turned out to be a very simple oversight with a big impact.

Root Cause:
This issue was not caused by a corrupted Scriptcase installation, license misconfiguration, or missing PHP SQL Server drivers.

The actual cause was special characters (specifically a single quote ') present in one of the database table names within SQL Server.

This happened unintentionally during a data import from Excel using the SQL Server Import and Export Wizard (DTS Tools), where the target table name accidentally retained the ’ character from the Excel sheet name.

Why Did It Cause Crashes & Auto Logouts?
When opening a project, Scriptcase automatically scans and parses the schema metadata for all tables in the connected database. The presence of a single quote ’ in a table name triggered a silent syntax/parser error in PHP during this schema discovery phase.

As a result, the PHP process crashed instantly, destroying the active session and redirecting me straight back to the Scriptcase login screen. Because the session was killed abruptly (ungraceful shutdown), the ghost session remained active in the background, eventually triggering the “reached your license connections limit” error.

How to Fix It:

  1. Open SQL Server Management Studio (SSMS) and connect to your database.
  2. Review the list of tables and look for any table names containing special characters (such as ').
  3. Rename the table to remove any special characters.

Once the table name was sanitized, the project opened smoothly in Scriptcase without any further crashes or forced logouts.

Key Takeaway: If you ever encounter an issue where opening a Scriptcase project instantly logs you out—regardless of the DBMS (SQL Server, MySQL, PostgreSQL, etc.)—always check your table names. Ensure no table names contain special characters (such as ', ", or leading/trailing spaces).

Hope this helps anyone who runs into a similar issue in the future!