Question:
How can I establish communication between E3 and SQL 2005 Express ?
Solution:
To do so, add a database to E3, access its properties, and set it up as described below:
- At Database, select SQLServer.
- At Server, add .\SQLEXPRESS (.\ signals the name of the machine where the SQL server is running, and SQLEXPRESS is the name of the SQL server).
- At Database, add the name of the database created in SQL.
- At User, add SQL user.
- At Password, add the SQL password.