Connection to MSSQL Database
Last updated
Was this helpful?
Last updated
Was this helpful?
In this chapter you will find detailed information on how to install and configure the MSSQL Database in order to connect your aqua server to the database. If you want to use an Oracle Database, please follow the installation steps described in the chapter Oracle Database.
You can download a free version of MSSQL Database using the following link. However, please note that this version is limited to 10GB per Database. Hence, we do not recommend using this version for productive use and do not provide support in case your database has reached this limitation. LINK
Then download ENU\x64\SQLEXPRADV_x64_ENU.exe Execute the file that the SQL Server Installation Center opens. Install a New SQL Server stand-alone installation.
Read the license terms, accept them, and click on Next. It is possible to include SQL Server product updates if available.
The updates are downloaded, extracted and installed in the next step. Now, the actual installation will start. Choose the following options and click on Next.
In the next window, the instance name is defined. The default value is SQLExpress. You may rename it, but be sure to remember this name for later configuration. This Wiki description continues to use the default value SQLExpress. After configuration, please click on Next.
In the following step, the database authentication mode is configured. For the setup, Mixed Mode is used and an Administrator password entered.
After that, proceed to the next step. In Reporting Services Configuration, chose Install and configure and click on Next. Then click on Next twice to begin the installation process. Finally, the installation is completed, and you can close the SQL Server 2012 Setup Window.
Open SQL Server Management Studio and login as Administrator.
Importing database
You have received at least five SQL scripts in your installation package. They are numbered. Please execute all of them in their sequence. You can do so, by dragging and dropping the files into the SQL Server Management Studio. The first script creates the database, the db user and the necessary permissions and settings. The scripts 2-5 must be executed against the aqua database.
This can take about 10 seconds. After executing the queries, there should be a green hint, stating that the query was executed successfully.
Configuring aqua Database Connection
Connect the aqua server to your MSSQL Sever. In order to do so, open the following XML Configuration File with Notepad:
C:\Programm Files\andagon GmbH\aqua for IIS\Web\Webservice\Web.config
Your database connection is specified in the following line. Please change this line accordingly.
<add key="Database" value="DataSource=localhost\SQLExpress;Initial Catalog=aqua;User Id=aqua_db_user;Password=aqua"/>
If you are not using SQLExpress, please remove the '\SQLExpress' after the database name.
Now your aqua server is connected to the database. In order to start your aqua server, open the Internet Information Service Manager (in the following IIS Manager) and make sure that all three aqua Application Pools are started.
In order to check if an aqua client is able to connect to your aqua server, please install your aqua client locally on the server. In order to do so, install aqua.msi. Follow the instructions and complete the installation.
After installation, start aqua. A login screen will be displayed. Here you have to enter:
Username:
Administrator
Password:
aqua
Server:
localhost
Try to Log in with the given aqua credentials.
