Problems define Database Enviroment (SQL Server Express)

Dark_V

Hi, we're newbies in Aware IM. :oops:

We're using licensed Aware IM 3.0 and try to enter username (abcd), password (wxyz), machine name and database name (db_ABC) in Database Enviroment for a new Business Object Persistence.

The machine name have this format: ABC-123AA567

When use SQL Server Managment Studio Express, Server Name have this value: ABC-123AA567\SQLEXPRESS. We use this value in Instance Name.

When don't use this values for machine name and show this error:
Aware IM server encountered the following error . Network error IOException: conection refused: connect..

When try to Discover Attributes show me this error:
Aware IM server encountered the following error . Server ABC-123AA567 has no instance named ABC-123AA567\SQLEXPRESS.

Aware IM are instaled with MySQL.

How to configure this properly?
Can we reinstall Aware IM to use ONLY SQL Server Express?
Have problems with Machine name format?

Please we need help ASAP.... 🙁 :cry: 🙁 :cry: 🙁

Thanks!

aware_support

Do you want to connect to existing SQL Server tables that yoou have from other applications? If yes, you do not need to re-install Aware IM for a different database and you need to resolve the setup problem. If not, and you want Aware IM to create and manage SQL Server tables automatically you need to re-install or change BASServer.props file to point to the SQL Server Express database.

So if you want to use the existing tables you need to resolve this problem. Machine name is the name of the SQL Server Express instance if you have any (check SQL Server Express doco). By the looks of it you don't have an instance so you should leave this field blank. The error you are getting could be a port problem - you need to specify the port where SQL Server is listening (if it's not a default port) and make sure it is un-blocked.

If you want us to look at this issue with you please purchase a support ticket.

Dark_V

Lets see...

Before initial post we configure Connection Manager and disable all protocols excepts TCP/IP and try to use Port Number value empty and with 1433 value and set up mixed authentication too.

The database was created with new tables and tested with abcd user.

May be use SQL Server Express will help me with all other issues.

List of process, just to be sure...

Do i have to download this? http://www.microsoft.com/downloads/details.aspx?FamilyId=C47053EB-3B64-4794-950D-81E1EC91C1BA&displaylang=en
In BASServer.props file in bin directory and find a few lines:
DriverTestURL=jdbc:mysql://localhost:3306/BASDBTEST?user\=abcd&password\=wxyz
DriverURL=jdbc:mysql://localhost:3306/BASDB?user\=abcd&password\=wxyz
BootstrapURL=jdbc:mysql://localhost:3306/?user\=abcd&password\=wxyz
DriverClassName=com.mysql.jdbc.Driver

I have to change this lines for:
DriverTestURL=jdbc::sqlserver://localhost:1433/BASDBTEST?user\=abcd&password\=wxyz
DriverURL=jdbc::sqlserver://localhost:1433/BASDB?user\=abcd&password\=wxyz
BootstrapURL=jdbc::sqlserver://localhost:1433/?user\=abcd&password\=wxyz
DriverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver

Need replace localhost for ABC-123AA567\SQLEXPRESS?

BASDBTEST and BASDB database will be created automatic?

Thanks for your help.

Dark_V

Answers???

Dark_V

Answers???

aware_support

Connection to the SQL Server is explained in the Installation Guide and in the User Manual. This has been tested many times and is known to work properly.

If you are having problems with this and want us to help please purchase a support ticket.