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

[karthur1]

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

[Gabriel_Watson]

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...

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...

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...

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.

[karthur1]

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.

[ihayesjr]

@karthur1 

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

[CGBenner]

@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?  

[karthur1]

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