topic Re: ADMS Fails to start... session is in the kill state??? in Vault Forum

ADMS Fails to start... session is in the kill state???

karthur1 — Fri, 18 Mar 2022 02:29:20 GMT

Went to start Vault Basic 2020. Been using it for over a year and it would not start. Then I tried to start the ADMS to see if I could tell what was going on. Get a message that says " Unable to ensure the correct SQL Server permissions for the ADMS Server accounts - details below.......... Cannot continue the execution because the session is in the kill state.......

Not sure what to do. I checked the HD space, and I have 50 GB free space.

Tried rebooting and did not help. I have not installed or done anything differently over the last few weeks. This is Vault Basic V2020.2 (updated 10/5/2020)

How do I get my Vault back up?

Thanks

Kirk

Re: ADMS Fails to start... session is in the kill state???

Gabriel_Watson — Fri, 18 Mar 2022 03:47:16 GMT

It seems that your SQL user for Vault (the login/password used for Vault to connect to Microsoft SQL application) has been blocked.

I found this article about this error:
https://knowledge.autodesk.com/support/vault-products/troubleshooting/caas/sfdcarticles/sfdcarticles/Unable-to-ensure-the-correct-SQL-Server-permissions-when-trying-to-attach-a-Content-Center-library-in-a-Vault-connected-workgroup.html

But this article below gives you lots of information on what to check to ensure the SQL login is working and not blocked by Windows or security:
https://knowledge.autodesk.com/support/vault-products/troubleshooting/caas/sfdcarticles/sfdcarticles/Failed-connecting-to-SQL-Server.html

You will probably need to fire up SQL in the Vault server and see if you are able to sign in with whatever login information you had for Vault to use. At the ADMS (if you had access to open it), you would see that here:

... as pointed out in this other article:
https://knowledge.autodesk.com/support/vault-products/troubleshooting/caas/sfdcarticles/sfdcarticles/Change-the-password-for-VaultSys-and-ADMS-SERVERNAME-username.html

If none of those checks help you find the culprit, connect to your reseller or Autodesk support to get this sorted faster. I am sure it is not something unheard of.

Re: ADMS Fails to start... session is in the kill state???

karthur1 — Fri, 18 Mar 2022 11:28:08 GMT

Something is blocking it for sure. I can't get to the Global Settings page in ADMS. I never get the login screen in ADMS, all I get is the error message I posted above.

Re: ADMS Fails to start... session is in the kill state???

ihayesjr — Fri, 18 Mar 2022 13:00:13 GMT

@karthur1

This looks like SQL is in a bad state. Can you try to use the SQL Management Studio and connect to the instance?

Re: ADMS Fails to start... session is in the kill state???

CGBenner — Fri, 18 Mar 2022 14:15:30 GMT

@karthur1 @ihayesjr
It almost looks like SQL crashed, but did not shut down fully. Could it be as simple as rebooting the server that you have the ADMS on?

Re: ADMS Fails to start... session is in the kill state???

karthur1 — Fri, 18 Mar 2022 14:23:10 GMT

Thanks guys. I will be where I can take another look at it late this afternoon.