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 

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 

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