Aras installation: connection to SQL server failed.

Hi,

did you use your server previously for something else, or is it a completely new instance? Which Innovator version do you try to install?

I assume you already googled your problem. Did you try any of the ideas of this site? stackoverflow.com/.../microsoftodbc-driver-manager-data-source-name-not-found-and-no-default-drive

Best regards

Angela

Hi,

It is a new installation for sql server and ssms since there were some login issues with older instances.

I tried to install Release 27 version and Aras 12 sp12 the older one just to check if installation works for the older version. But for both, it was same the error ODBC driver related.

Yes, tried setting system DSN for odbc driver manager, but it did not work. Let me try again thoroughly for setting DSN. I will revert once tested this approach.

Thanks and Regards, 

Rucha B 

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.

Hi Angela,

I have added DSN for ODBC over here 

Now I am able to connect to sql with sa login, but when I click on configure database it gives the error

Could you please suggest what to do?

Thanks and Regards,

Rucha

As you use Release 27 you can ask Aras support for this one, cause you obviously have an subscription.

I right now don´t know what can cause your error message. One common source of problems is, when you haven´t setup up the IIS environment correctly. 

You can check my video about IIS. https://www.youtube.com/watch?v=rlgyGM8yTTI
Maybe you found some notable difference to your settings. Although I have no idea which settings could be related to your described issue.

Thanks for the help. I will check