# SAP, I'll Pass In case of SAP ASE, it is a hell of a mess. We have so many products, I'm wondering why. Problem: Couldn't connect to by server, even after the correct credentials and port. Got the error ### 1. Connection Already Closed ``` // SQL Error [JZ0C0]: JZ0C0: Connection is already closed. ``` * services, on windows, restart * if that doesn't work, kill pid of the service. * start again. could be issue of space not being enough. ### 2. Curious case of 'Connection Already Closed' but we did the above step: The users of my SAP ASE instance, especially team DataStage, who run automated tests on the instance, were getting connection refused or connection already closed. I restarted the server like above, it worked for me as an `sa` but it didn't for them. I was on the verge of crying, when angel Pallavi Koganti helped me with the command: ```sql sp_configure "number of user connections", 200 reconfigure sp_configure "number of user connections" ``` This helped me solve the frequently logged out issue. Thanks, Pallavi! ### 3. Timed out on CREATE statements Did some digging around (*cough \*chat GPT\* cough) and* realised that space might have run out of CONOPS database, so I increased it, with the following commands.