Luminai 0 Posted August 15, 2015 Share Posted August 15, 2015 Hello, I'm getting the aforementioned error when I try to connect to the database server. I installed SQL Server Express using the installer included in the full setup package of ERA. I have set-up the server so it listens on port 1433 and I am also able to make an ODBC to the server however I'm still not able to connect in the setup. Attached: Full error message. Link to comment Share on other sites More sharing options...
Former ESET Employees Timos 8 Posted August 17, 2015 Former ESET Employees Share Posted August 17, 2015 (edited) Ensure SQL Server is listening on port 1433. If it did not help, try using database type "MS SQL Server via Windows Authentication" on port 1433 instead of "MS SQL Server" Edited August 17, 2015 by Timos Link to comment Share on other sites More sharing options...
marc_x 0 Posted August 17, 2015 Share Posted August 17, 2015 I am running in the same issue, I have two existing SQL Server (One local to where I am installing and one remote to where I am trying to setup the database). both server are up and are reachable with SQL Server Management Studio. I have tried all (SQL Server) drivers and both username/Password Widows security, instance name or none... Link to comment Share on other sites More sharing options...
Administrators Solution Marcos 5,273 Posted August 17, 2015 Administrators Solution Share Posted August 17, 2015 I am running in the same issue, I have two existing SQL Server (One local to where I am installing and one remote to where I am trying to setup the database). both server are up and are reachable with SQL Server Management Studio. I have tried all (SQL Server) drivers and both username/Password Widows security, instance name or none... Have you checked the port SQL server is listening on? By default it's 1433 (Client protocols -> TCP/IP in the SQL Server Configuration Manager). Also make sure the database type is set to "MS SQL Server via Windows Authentication" in the ERAS setup: Link to comment Share on other sites More sharing options...
marc_x 0 Posted August 17, 2015 Share Posted August 17, 2015 Yes I have checked the port and we have business application running on that server so I would have greater problems if the server would not work.. . both method of authentication have also been tried. How do you attach a screenshot, can't find this option here Link to comment Share on other sites More sharing options...
Luminai 0 Posted August 17, 2015 Author Share Posted August 17, 2015 Thank you, switching to MS SQL Server via Windows Authentication did the trick for me (after also changing the login mode on the SQL server). Link to comment Share on other sites More sharing options...
Recommended Posts