dcsimg

Database not available at jdbc:jtds:sqlserver://SERVERNAME:1433;DatabaseName=wt_sched

Products

Webtrends Analytics 8.x

Issue

Webtrends installed successfully but when attempting to view reports the following error displays:

Error:
——————————————–
Message: The Scheduler database specified in the web.xml file (jdbc:jtds:sqlserver://SERVERNAME:1433;DatabaseName=wt_sched)
could not be accessed for the following reason:
Database not available at “jdbc:jtds:sqlserver://SERVERNAME:1433;DatabaseName=wt_sched”.
——————————————–

Cause

The installation uses MS SQL 2000 with Service Pack 3 or less.

Resolution

Install Service Pack 4 for MS SQL Server 2000, then log into Webtrends and attempt to view reports again. Also, check the SQL installation and make sure that TCP/IP pipes are enabled.

Further information:
MS SQL Server 2000 Service Pack 4 can be downloaded from the following location:

http://www.microsoft.com/downloads/details.aspx?familyid=8E2DFC8D-C20E-4446-99A9-B7F0213F8BC5&displaylang=en

For Webtrends Analytics 8.7d refer to the article on “JDBC error when accessing the Webtrends user interface