Is there a way to find out the sql server database instance that one of our Epicor test environment is pointing to? I would like to do a database refresh of the test environment but can’t find or it was moved to a different sql server.
Where do you begin to look where the ODBC is located to review the data source?
Go to the Control Panel – Administrative Tools applet on the Application Server or use search to find it. The Application Server that the environment points to is in the lower right portion of the client screen.
64bit ODBC Data Source Administrator:
Start > Run > c:\windows\system32\odbcad32.exe
32bit ODBC Data Source Administrator:
Start > Run > c:\windows\syswow64\odbcad32.exe
1 Like
All of this assumes that an ODBC connection was even created.
Shouldn’t the SystemAgent have info about the App Server, and then use the App Server console to see which DB is used.
Found the server and the ODBC connection. It turns out it was the correct sql server but wrong instance. Thanks for the help.