SQL Connection Information is Invalid

Hi everyone,

I’m trying to add a database connection while setting up an application server in the
Epicor Administration Console, but I’m encountering an error. Has anyone faced this issue before? Any guidance on how to resolve it would be greatly appreciated!

I mean, that’s a pretty straightforward error. It would seem your password is incorrect for the server you specified.
Is your SQL database on the same server that you’re setting up the app server on? If not, then (local) is inappropriate and you would need to specify the server location \\MySQLServerName.

Hi, I checked whether my password is correct, and it is and Yes, my SQL database is on the same app server—I verified that as well what else can cause this error any idea.

Check the instance name - it could be localhost\sql2019 or similar.

How does the database appear in the database manager section within Epicor Admin console?

I checked the server name and corrected it but I am still getting this error, my database should show in the SQL management studio but it is not showing here any idea how can I add it there?

So your SQL server does have an instance name - it’s MSSQSERVER… or something. The screenshot cuts it off.

okay I added that as an Instance name there Thank you, but I still cannot connect the database is not showing in the drop down or in the SQL management studio. Am I missing a step here do I need to add the database to the SQL management studio separately?

You have to create the database before you try to create the application pool.

1 Like