Web Data Administrator - <span id="Helpheader1_TitleLabel">LOGGING IN</span>
 
 
  Creating
  Editing
  Deleting
  Querying
  Importing
  Exporting
  Properties
  Roles
  Creating
  Editing
  Deleting
  Querying
  Creating
  Editing
  Creating
  Editing
  Server Logins
LOGGING IN
Before you can use the Web Data Administrator, you will need to login to the server you wish to administer. Web Data Administrator supports integrated Windows authentication or SQL authentication. Web Data Administrator must be configured to deny anonymous access if you want to use integrated Windows authentication. Also, in order to use SQL Authentication, the SQL Server must be running in "Mixed Mode" (see the SQL Server documentation for more information).

Because Web Data Administrator runs on two different types of web servers that are different in capabilities and architecture the way you logon is also different. Below are the differences between the two web servers.

IIS Web Server
Windows Authentication
Username: Populated for you.
Password: Populated for you.
Server: You enter this data. Default is (local)

SQL Server Authentication Username: A valid SQL login.
Password: Password for SQL login for username specified in Username field.
Server: You enter this data. Default is (local)


Cassini Web Server Cassini Web Server is an open source web server developed using the Microsoft® .NET® Framework. You can find more information on Cassini Web Server here. Using the Cassini Web Server to host the Web Data Adminstrator application give you an added feature of being able to use a Windows account other than the one you are currently logged in as. Warning: You will have to provide your credentials manually when using the Cassini Web Server which means they are passed in clear text back to the server (see next section for fix). Verify that you can even request from other computer

Windows Authentication
Username: You must fill out this section. (Example: domain|computer\login)
Password: You must fill out this section. (Example: password)
Server: You enter this data. Default is (local)

SQL Server Authentication
Username: A valid SQL login.
Password: Password for SQL login for username specified in Username field.
Server: You enter this data. Default is (local)

If you are using SQL authentication, you are prompted for your user name, password, and the server with which to connect. If you are using Windows authentication, Web Data Administrator automatically obtains your username credentials, so you only need to specify a server name.

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.

After you successfully log in, the Web Data Administrator displays a list of databases viewable by your user account. From this screen you can create a new database or edit, query, and delete an existing one. You may also import or export a database to/from this server.