Error 65535 during setup

[Luminai 0]

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.

[Timos 8]

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

[marc_x 0]

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...

[Marcos 5,070]

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:

 

[marc_x 0]

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

[Luminai 0]

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).