Configuring Microsoft SQL Server 2008 for Visitor Data Mart
SQL Server 2008 configuration instructions for Visitor Data Mart.
- Create two empty SQL Server Standard or Enterprise Edition databases. Name one of them wtMaster and the other wt_Sched.
- Configure a login account using SQL Server 2008 Authentication. The login
account must be a member of the sysadmin server role.
This login account should also be db_owner of the
Webtrends databases. The installation requires the user name and password for
this user. For more information, see the Microsoft SQL Server 2008
documentation. Note: The Webtrends master database uses port 1433 on Microsoft SQL Server installations. Ensure that port 1433 is selected, and that there are no port conflicts with other services that you plan to run on your Webtrends computers.
- Enable the TCP/IP Protocol for Microsoft SQL Server as described in Enabling the TCP/IP Protocol for Microsoft SQL Server 2008 R2
- Start the SQL Agent.