Aras installation: connection to SQL server failed.

Hello,

I am facing this error while installing Aras. I tried with windows authentication also, but it shows the same error.

The error is: [Microsoft] [ODBC Driver Manager] Data source name not found, and no default driver specified.

I don't have any old Aras instance installed right now and don't have Innovator solutions database to use existing database option.

Restarting the PC also did not solve this issue.

Does anyone have any idea how to solve this?

Thanks,

Rucha B

Parents
  • Ensure that the required ODBC driver for your database is installed on your system. For Aras, commonly used databases include Microsoft SQL Server or Oracle. Make sure you have the corresponding ODBC driver installed.
    Open the ODBC Data Source Administrator on your machine. You can find it in the Control Panel or by searching for "ODBC" in the Start menu.
    In the ODBC Data Source Administrator, go to the "System DSN" tab.
    Check if the required data source for your database is listed. If not, you may need to add it.
    Click the "Add" button in the System DSN tab to create a new data source.
    Choose the appropriate ODBC driver for your database.
    Configure the connection details, such as server name, database name, and authentication.
    After creating the data source, use the "Test" button to verify that the ODBC connection is successful.
    Check the Aras installation documentation for specific requirements and steps related to ODBC configuration. The documentation may provide guidance on configuring the data source.
    If you suspect an issue with the ODBC driver, consider reinstalling the driver. Ensure that you are using a version compatible with your Aras installation.
    If you are using Windows Authentication for your database, ensure that the user account running the Aras installation process has the necessary permissions to access the database.
    Check if any firewall or antivirus software is blocking the connection. Temporarily disable them during the installation to see if it resolves the issue.
    If the issue persists, consider reaching out to Aras support or consulting their community forums for assistance. They may have specific recommendations based on your environment.

Reply
  • Ensure that the required ODBC driver for your database is installed on your system. For Aras, commonly used databases include Microsoft SQL Server or Oracle. Make sure you have the corresponding ODBC driver installed.
    Open the ODBC Data Source Administrator on your machine. You can find it in the Control Panel or by searching for "ODBC" in the Start menu.
    In the ODBC Data Source Administrator, go to the "System DSN" tab.
    Check if the required data source for your database is listed. If not, you may need to add it.
    Click the "Add" button in the System DSN tab to create a new data source.
    Choose the appropriate ODBC driver for your database.
    Configure the connection details, such as server name, database name, and authentication.
    After creating the data source, use the "Test" button to verify that the ODBC connection is successful.
    Check the Aras installation documentation for specific requirements and steps related to ODBC configuration. The documentation may provide guidance on configuring the data source.
    If you suspect an issue with the ODBC driver, consider reinstalling the driver. Ensure that you are using a version compatible with your Aras installation.
    If you are using Windows Authentication for your database, ensure that the user account running the Aras installation process has the necessary permissions to access the database.
    Check if any firewall or antivirus software is blocking the connection. Temporarily disable them during the installation to see if it resolves the issue.
    If the issue persists, consider reaching out to Aras support or consulting their community forums for assistance. They may have specific recommendations based on your environment.

Children
No Data