Skip Navigation

123 Reg - data admin

The Web Data Administrator uses SQL authentication or integrated Windows authentication in order to establish a connection to the database server. If you are connecting to Microsoft SQL Server using SQL authentication, it should be running in "Mixed Mode" (see the SQL Server documentation for more information).

Note: The SQL authentication security credentials are passed from the web browser to the Web Data Administrator using a normal plain-text form POST over HTTP. When using the Web Data Administrator over an unsecure network (the Internet, for example) it is recommended you enable secure socket layer (SSL) for this application.

All operations in the Web Data Administrator are performed on behalf of the logged in user account. If the database server disallows certain priviledges to that account, an error will be returned and displayed. While account priviledges cannot be administered through the Web Data Administrator, it will respect any security restrictions enforced by the backend database server.