Database Server Connection

Owned by René Pape
Last updated: 23 Sept 2014
1 min read

The Database Server connection string is responsible for connecting the DVI application to the database server.

The connection string is stored in the "web.config" file of the DVI application, located in the "bin" subfolder of the "Plass.Id.Web" site.

Step-by-step guide

  1. Open the Internet Information Services (IIS) Manager

  2. In the left column, expand "Sites" and "Default Web Site", find "Plass.Id.Web", select it and then double-click the "Connection Strings" icon in the right area

    (click image to enlarge)







  5. Data Source=PDS-VSSQL-05\DVI;Initial Catalog=DVI5;Integrated Security=True;MultipleActiveResultSets=True

     KeyDescription  Sample Value
    Data Source

    The DNS name of the SQL Server, appended with "\" and any SQL Instance name.
    The \ and instance name is only necessary if it is not the default instance.
    On the free SQL Express server, it is mostly "\SQLEXPRESS", and the complete
    name on a stand-alone is then ".\SQLEXPRESS" where "." denotes the local machine.

    		PDS-VSSQL-05\DVI
    Initial CatalogThe name of the database on the SQL ServerDVI5 
    Integrated SecurityWhether the connection should authenticate to the SQL Server using the user
    assigned to the application pool.    		True
    MultipleActiveResultSetsAllows the connection to serve multiple ongoing processes with different simultaneous queries.True