Setup MSDE for bandwidth usage stats

To create a new database in MSDE, follow these steps:

  1. Open command prompt (cmd.exe) on ISA Server computer.
  2. Go to BWStats folder:
    cd "%PROGRAMFILES%\Microsoft ISA Server\Bandwidth Splitter\BWStats"
  3. Run setup_msde.bat. It has one optional parameter which allows you to specify name of database to be created. If parameter not specified, the default name is BWStats.
  4. Ensure that you don’t see any error messages in resulting output.
  5. Grant database access to user account which will be used for authentication. (This step is optional if all 3 components of bandwidth usage reporting are installed on single server.)

    a) If you use Windows account, run (replace BWStats with desired database name if needed; replace Domain\User with domain account that you have created for this database):

    grant_access.bat (local)\MSFW BWStats Domain\User
    b) If you use SQL Server account, run (replace BWStats with desired database name if needed; replace User and Password with desired SQL Server account name and password. Note that this command will create a new SQL Server account based on this data):
    grant_access.bat (local)\MSFW BWStats User Password

Enabling remote access to MSDE

By default, only local applications can access the MSDE database. If you are going to install Bandwidth Splitter reporting service and its management web application on another server, then you also need to enable network access to MSDE database using SVRNETCN.exe tool. (Usually it can be found in the following path: %PROGRAMFILES%\Microsoft SQL Server\80\Tools\Binn\.) Run this tool and move TCP/IP to the list of enabled protocols. After you click OK, you will be notified that SQL Service restart required for this change to take effect. You can do it by restarting MSSQL$MSFW service in system services console. Note that it will also restart the Firewall service.

See also
Setup database for bandwidth usage stats
Setup SQL Server for bandwidth usage stats
© BNTC Software. All rights reserved.