The project database has not been connected - Error

Hey guys!!

Promise version: 08.11.13.96

Lately we had moved to a different SQL server and the project database was restored and the IT helped us to create new logins for the database. 

On the setup screen. The I am not having any problem login into the server. The message "Configuration is saved" pops up as shown in the image below. When I move to the next screen. During the parts database path selection. " The project database has not been connected " error shows up. 

The SQL server seems to be running correctly. Can anyone let me know if I have missed anything on the way?

  

  • Hi Vivek,

    For the above issue you are facing with Promis.e can you confirm if you are facing the issue with a particular machine or all the Machine ? Can you try to reproduce the issue on other user machine ?

    As you have mentioned users have been created for new database, can you try using one of them instead of the SA password and check weather the users have below minimum SQL permissions ?



    After you get the above message if you click Ok and then again go to Project Database tab and select Apply dose it still say configuration saved ?

    Regards,
    Satish Saptasagar

  • Hey satish,

     

    I have added my answers in BOLD.

     

    For the above issue you are facing with Promis.e can you confirm if you are facing the issue with a particular machine or all the Machine ? All the machines and user.

     

    Can you try to reproduce the issue on other user machine ? Yes. I am able to reproduce the issue in another machine.

    As you have mentioned users have been created for new database, can you try using one of them instead of the SA password and check weather the users have below minimum SQL permissions ? Minimum SQL requirements checked and the current database is complaint.

    After you get the above message if you click Ok and then again go to Project Database tab and select Apply dose it still say configuration saved ?  After the above message, If the click OK. The password gets removed from the field and If I type the password back and click on OK and the Configuration is saved message reappears. 

    I have added firewall exclusions as well. But the error is still persisting.