The connection to the  GN4 database is configured either in the Web.Config, or in the appSettings.xml files.

Web.config

web.config is one of main GN4 configuration files that determines number of system functionalities.

If you are using standard WEB.CONFIG as supplied in GNPORTAL.ZIP, it will be in \TERA\GN4\WEB\GNPORTAL.

Typically, the web.config simply points to the appsettings.xml file, e.g.:

  <appSettings file="..\..\appSettings.xml">

In that case, the real connection settings are in the appsettings.xml file.

Appsettings.xml

appsettings.xml is one of main GN4 configuration files that determines number of system functionalities.

If you are using standard appsettings.xml, it will be in the \TERA\GN4 folder.

When you open the file, it appears like this, with placeholder values in the value fields:

  <!-- Database server -->

  <add key="Db.Server" value="myServer" />

 

  <!-- Database user -->

  <add key="Db.User" value="myUser" />

 

  <!-- Database password -->

  <add key="Db.Pwd" value="myPassword" />

 

  <!-- Database name -->

  <add key="Db.Name" value="myDatabase" />

Modify values as below (the example assumes the database server name - where the SQL is installed - is CALISTO, without SQL instances, using Windows authentication, with the database named GN4 and volumes stored on a NAS with IP www.xxx.yyy.zzz.

<!-- Database server -->

<add key="Db.Server" value="CALISTO" />

<!-- Database user -->

<add key="Db.User" value="" />

<!-- Database password -->

<add key="Db.Pwd" value="" />

<!-- Database name -->

<add key="Db.Name" value="GN4" />

More details

DB.Server value

•For the server name with SQL installed as a single instance, enter the server name only, e.g. demoserver, or just dot

•If there are SQL instances, e.g. first enter the servername\instancename, e.g.
       demoserver\first.
If you are using the SQLExpress version, the instance name, unless you've selected "default instance", is sqlexpress.

DB.User value

•When using Windows integrated authentication for the SQL server, leave the user name empty.

•If the SQL server authentication is mixed, enter the name of the user, used for authentication, typically. sa.

DB.Pwd value

•When using Windows integrated authentication for the SQL server, leave the user password empty.

•If the SQL server authentication is mixed, enter the password of the user, whose name is specified in DB.User value.

DB.Name value

•It depends on your GN4 database name, typically it's GN4.

Important

If you edit APPSETTINGS.XML any time later on an already installed GN4 system, remember to close Ted4, Fred4 and browser and then recycle the application pool to apply changes.