connection to database failed help

[fabena 1]

I show this error when try to run accountserver.exe by the way group server is okey it is running. 

[V3ct0r 2,117]

Hello @fabena!

 

AccountServer.exe can't connect to MSSQL Server.

Show us AccountServer.cfg. Have you entered correct MSSQL Server address in AccountServer.cfg? Have you created an user for AccountServer database in MSSQL Management Studio and entered its login and password in .cfg? Note: password should be encrypted.

 

Also there is a lot of threads about such problem in 'Questions & Help' section.

[fabena 1]

hello vector thank you for your attention  I create a pko_account and its password is 1993 I write its encrypted state in .cfg . I edited IP adressed.

[V3ct0r 2,117]

@fabena

 

Change IP from '172.20.10.4' to '127.0.0.1' everywhere. Try take password of 9 letters length. After encryption it should look like 'XXXXXXXXXXXXXXXXXXXXXX=='

[fabena 1]

I did these but still cant connect database

[V3ct0r 2,117]

@fabena

 

Try to enter MSSQL Server instance name instead of IP address (without port):

[db]
dbserver = <Instance name>

[fabena 1]

İs it true? again fails

[V3ct0r 2,117]

@fabena

dbserver = storm

 

(without <> brackets)

[fabena 1]

again cant connect database

[V3ct0r 2,117]

@fabena

Do you can login with name 'pko_account' and decrypted password in MSSQL Management studio? Does this user have read/write access to AccountServer database?

[fabena 1]

Oh permissions are failed. I grant permissions for pko_account and finally I can access database thank you so much v3ct0r