Instructions on how to download and connect your server with ms sql database

1) please download the migrated database from the provided link.
2) In the zip folder you will find MDF and LDF files. Please attach it to your mssql server.
2) On the SysAid server, please go to servics.msc and stop the sysaid server service.
3) Go to SysAidServer\root\WEB-INF\conf folder,locate the file called "serverconf.xml" and edit it with notepad.
4) Find the following lines:

<dbConf>
<dbDriver>org.apache.derby.jdbc.EmbeddedDriver</dbDriver>
<dbUrl>jdbc:derby:default</dbUrl>
<dbUser>sysdba</dbUser>
<dbPassword>masterkey</dbPassword>
<dbType>derby</dbType>
<dbEncoding>utf-8</dbEncoding>
<dbMultiply>false</dbMultiply>
<dbMainName>ilient</dbMainName>
</dbConf>

And replace them with these lines :

<dbConf>
<dbDriver>net.sourceforge.jtds.jdbc.Driver</dbDriver>
<dbUrl>jdbc:jtds:sqlserver://"replace this with your database server's IP:1433/"replace this with the database name"</dbUrl>
<dbUser>"replace this with the database user name"</dbUser>
<dbPassword>"replace this with your database password"</dbPassword>
<dbType>mssql</dbType>
<dbEncoding>utf-8</dbEncoding>
<dbMultiply>false</dbMultiply>
<dbMainName>ilient</dbMainName>
</dbConf>


5) Once you finished to edit this file, save it, and close it.
6) Go to services.msc and start SysAid server service.
7) Make sure that you are able to log into SysAid.

* Please note that it is best to use the "SA" user from the database server, since this user is usally not restricted by any password policies of the organization.
* Also it is best to have the database owned by the "SA" user.