ERAS MS-SQL

I'm trying to install the ERA in a database MS SQL but I'm not getting, can you help me?

User and password database I tested this and correct that already tested!

You have to configure anything in SQL? Or the machine?

 

I had the same problem and eventually just set up and System DSN in ODBC and used it. Then in the connect string I used "DSN=odbcsystemdnsname"

 

I have ERA setup to use SQL Server 2008 Standard and the connection string worked just fine for me. Have you confirmed that you can connect to the ESETRADB database using another application (Management Studio, Query Anaylzer etc..)?

Also, did you create the ESETRADB database on your SQL Server? it's been awhile since I set mine up, but I think I had to create the database, and then the installer added the tables.

 

The database is not created by the ERAS?

I have to create a database in SQL and basic set up after the install ERAS?

 

ERAS V4 support Microsoft SQL Server 2005 with CI collation.

In SQL Server 2005/2008 you have to use a Schema Name. I've used the default dbo, as shown in section 2.2.3.4.2 of the ERAS manual.

According to section 2.2.3.4.1 from the the ERAS manual the ERAS installer is capable of creating an empty MySQL database, which is automatically named ESETRADB. Therefor I manually created a SQL2005 database on SQL Server 2008.

Note: With ERAS V3 I had some problems using SQL Server. The installer was looking in the wrong folder for the sql script to create the tables. After reviewing the error log I manually copied them to the right location and restarted the installer.