The K2.net 2003 SP1 installation allows you to select between SQL Authentication and Integrated Authentication and based on the selection the following connection string is stored in the K2Server.config (Default location C:Program FilesK2.net 2003Bin )
SQL Authentication:
<Database ConnectionString="server=(local);database=K2;uid=sa;pwd=password;pooling=true;enlist=false;Min Pool Size=5" />
<LogDatabase ConnectionString="server=(local);database=K2Log;uid=sa;pwd=password;pooling=true;enlist=false;Min Pool Size=20" />
Integrated Authentication:
<Database ConnectionString="server=(local);database=K2;Integrated Security=SSPI;pooling=true;enlist=false;Min Pool Size=5" />
<LogDatabase ConnectionString="server=(local);database=K2Log;Integrated Security=SSPI;pooling=true;enlist=false;Min Pool Size=20" />
Note: For Integrated Authentication Make sure that the K2.net 2003 Server service is running under an account with the appropriate rights to perform the following task in SQL Server: Insert, Delete, Update and Select
To change the connection string after the installation, simply open the K2Server.config update the connection string as illustrated and restart the K2.net 2003 Server.
