Create SWA User
Safran Web Access uses a database known as "SWAMaster" to store configuration data, activities, reports and more.
This can be an MSS or Oracle database, depending on your preference.
The SwaUser creation must be done after the database initiation.
Create SWAUser for "connecting" to the SWAMaster database.
Please create a new user, name it SWAUser, on your database server and grant the role SWARole. This user is not a DB-owner but holds the preconfigured SWARole on the SWAMaster database.
You need to grant dba to SWAUSER if you use Oracle database for your SWA install.
| |
Log into SWA System Administrator with the SWAUser account credentials you just created.
Click "3. Configure SWA Connection String".
.png)
Allow the System Administrator to edit the Web.config-file:
.png)
.png)
Suppose you cannot automatically edit the "Web.config". In that case, you will need to check that the user trying to edit the file has the necessary permissions in Windows or manually edit the file to add the SWA database connection information.
Do the following if you have to edit the file manually:
1. In File Explorer, navigate to the SWA install directory ("C:\inetpub\wwwroot\SWA") and open the "Web.Config" file in Notepad.
2. Under the Tag connectionStrings, edit the "SwaMasterConnectionString" connection.
For demonstration purposes, let's say this is my database server credentials in an MSS environment:
| Server | SQLServer |
|---|---|
| Database | SWAMaster |
| Username | SWAUser |
| Password | safran |
Please exchange the parts marked with XXXX below with the correct values, as shown above.
| Server = | Data Source |
|---|---|
| Initial Catalog = | Database |
| User ID = | Username |
| Password = | Password |
**From this:**
<add name="SwaMasterConnectionString" connectionString="Data Source=XXXX;Initial Catalog=XXXX;Persist Security Info=True;User ID=XXXX;Password=XXXX" providerName="System.Data.SqlClient" />
**To this:**
<add name="SwaMasterConnectionString" connectionString="Data Source=SQLServer;Initial Catalog=SWAMaster ;Persist Security Info=True;User ID=SWAUser;Password=safran" providerName="System.Data.SqlClient" /