Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision		 Previous revision
docs:1100_inst_guide:0350_db_integration:0200_msql [2023/07/22 07:55] – created seandocs:1100_inst_guide:0350_db_integration:0200_msql [2025/10/29 23:58] (current) – aware_support3
Line 1: Line 1:
-{{tag>Index}} +{{tag>Index Installation Integration DB MSQL}} 
-===== Integrating Aware IM with MS SQL Server database =====+[<10>] 
 +===== MS SQL Server =====
  
  
 If you do not have MS SQL Server database software you can download the free version (SQL Server Express) from the Microsoft web site. Make sure that MS SQL Server or SQL Server Express is running and perform the integration steps described below. If you do not have MS SQL Server database software you can download the free version (SQL Server Express) from the Microsoft web site. Make sure that MS SQL Server or SQL Server Express is running and perform the integration steps described below.
  
-<callout type="warning" icon="true" title="important">Support for the full version of MS SQL Server database is optional in Aware IM. Before integrating this database with Aware IM make sure that this option is available in your Aware IM edition.</callout>+<callout type="warning" icon="true" title="important">Support for the full version of MS SQL Server database is optional in AwareIM. Before integrating this database with AwareIM make sure that this option is available in your AwareIM edition.</callout>
  
   - Make sure that your MS SQL Server database is configured to use TCP/IP protocol – please refer to the MS SQL Server manual for details.   - Make sure that your MS SQL Server database is configured to use TCP/IP protocol – please refer to the MS SQL Server manual for details.
-  - Start the Aware IM Control Panel+  - Start the AwareIM Control Panel
   - Select the Settings/Database menu item and select SQL Server as the database engine   - Select the Settings/Database menu item and select SQL Server as the database engine
   - Enter credentials of the SQL Server account.    - Enter credentials of the SQL Server account. 
   - Specify SQL server name and the port number where SQL Server listens to requests (if these are different from the default values)   - Specify SQL server name and the port number where SQL Server listens to requests (if these are different from the default values)
-  - Click OK and restart Aware IM+  - Click OK and restart AwareIM
  
  
  
-If you installed Aware IM as Windows service you can perform database integration manually without using the Aware IM Control Panel. To do this:+If you installed AwareIM as Windows service you can perform database integration manually without using the AwareIM Control Panel. To do this:
  
  
Line 22: Line 23:
   - Delete the default ''AwareIM/bin/BASServer.props'' file which contains default database settings   - Delete the default ''AwareIM/bin/BASServer.props'' file which contains default database settings
   - Rename the file ''BASServerMSDE.props'' to ''BASServer.props''   - Rename the file ''BASServerMSDE.props'' to ''BASServer.props''
-  - Use any text editor to modify the following lines in the ''BASServer.props'' file located in the ''BIN'' directory of your //**Aware IM**// installation:+  - Use any text editor to modify the following lines in the ''BASServer.props'' file located in the ''BIN'' directory of your //**AwareIM**// installation:
  
 <code> <code>
Line 42: Line 43:
  
 ^Cause of failure   ^What to do  ^ ^Cause of failure   ^What to do  ^
-^Aware IM fails to authenticate with MS SQL Server.    |Check that you specified correct user name and password in the BASServer.props file| +^AwareIM fails to authenticate with MS SQL Server.    |Check that you specified correct user name and password in the BASServer.props file| 
-^Aware IM cannot connect to the MSQL Server through the default TCP/IP port|1. Check that SQL Server is configured to use TCP/IP. Restart the SQL Server service after you make the changes.\\ \\ 2. If SQL Server is listening for connections on a different port than the default port 1433, specify this port number in the BASServer.props‎ file‎ after‎ ''localhost''‎ in‎ the 3 lines mentioned in the previous sections, for example ''localhost:1450''\\ \\ 3. Check that the port on which SQL Server is listening for connections is not blocked by a firewall.|+^AwareIM cannot connect to the MSQL Server through the default TCP/IP port|1. Check that SQL Server is configured to use TCP/IP. Restart the SQL Server service after you make the changes.\\ \\ 2. If SQL Server is listening for connections on a different port than the default port 1433, specify this port number in the BASServer.props‎ file‎ after‎ ''localhost''‎ in‎ the 3 lines mentioned in the previous sections, for example ''localhost:1450''\\ \\ 3. Check that the port on which SQL Server is listening for connections is not blocked by a firewall.|
  
-If //**Aware IM**// does not start it could be for reasons described in the following table (which also suggests what to do):+If //**AwareIM**// does not start it could be for reasons described in the following table (which also suggests what to do):
  
  
 {{simplenavi>docs:1100_inst_guide:0350_db_integration:0200_msql:}} {{simplenavi>docs:1100_inst_guide:0350_db_integration:0200_msql:}}
  • Last modified: 2023/07/22 07:55