thanks for your help, its not a MS SQL problem, its a direct communication issue as the error shows when clicking the server in SolidCP. So its not an MS SQL error, I can communicate with the MS SQL server directly from the master server. It seems just a soap issue with a character in the XML call 🙁

ah,

And if you copy over someone elses web.config password key

and then in the database --> Servers --> select the password that belongs to that server you copied --> and then paste it into the SQL Servers password box directly in the database

this should make the password settings identical (and working).

Additionally you can also remove + re-setup the server component but i would assume it will currently download latest stable v1.1.0 (this does have 1 known portal bug which will be fixed in the next 12 hours).

the password thing you are saying is confusing me, can you go into more detail please?

Ok,

To keep things simple:

In normal situations you encounter this aspect:

1. You enter a password during the SolidCP Server setup for the :"Connection"
2. You then enter that password in the Portal to connect to the SolidCP Server

This involves a few aspects:

1. Any password stored in the database uses the Enterprise Cipher key to encrypt and decrypt (so it's NOT stored in plain text)
2. Any password in the SolidCP Server is stored in an encrypted key, this is not the password you entered.

To get your password equal you need 3 things:

1. The correct Enterprise cipher key
2. The Correct SolidCP Server password
3. The Correct Password stored in the database.

Now due to your error one of the above 3 is not correct.

to fix this you can simply use one of your SolidCP servers that does work 100%

You then do the following:

1. Go to the WORKING solidcp server web.config,  copy it's Password value
2. Go to the BROKEN solidcp server web.config, paste in the password value copied from step 1
3. Go to mssql management, open up the SolidCP Database (or upgraded WebsitePanel database), Go to the Servers table --> check out the server you used for step 1. copy the "Password" value in the colomn of the working server
4. In the same table check out the broken server, and paste the encrypted password copied in step 3, and paste it into the password colomn of the broken server.

then simply review it, and your connectivity should be 100% working.