How to set Enterprise database for WebStatistica

How to set Enterprise database for WebStatistica

book

Article ID: KB0073256

calendar_today

Updated On:

Products

Statistica

Description

The DSN information for Webstatistica may need to be updated in the below scenarios :
1. The Enterprise meta database was moved from one server to another
2. There is a need to point to a different Enterprise database that is non default DSN

3. When the user sees the error : Failed to connect to Webstaitsitca Enterprise database please contact your system administrator

 

Issue/Introduction

This article details how WebStatistica can be pointed to a non-default Enterprise database

Resolution

There are two ways of changing the Enterprise DSN for WebStatistica : 

Method 1: Using  WebStatistica Administration tool on the Application server.

   Note : This method maybe used even in legacy versions of Statistica (Version 10 and later) 
  1. Select All Programs >> Statistica [version] >> Webstatistica >>Administration. Alternatively, simply type "Administration" in windows search bar. 
       2. In the Statistica server configuration dialog, expand WebStatistica >> Main Site [Server name] >>Settings >> Other  (or All) in the left pane.  

             User-added image

        3. Double click on SEWSSConnectionString setting. If this value is blank, it implies that Statistica is using the default DSN (Enterprise Meta Database) that was used during installation.    
 
                 User-added image

      4. Put the DSN, user, and password in the “Value” field in the following format :   DSN=SEWSS;UID=Enterprise;PWD=******

                   User-added image

  This information should match the DSN in the lower half of the Statistica Enterprise login dialog.

                 User-added image

           5. Launch Control Panel >> System and Security >> Administrative Tools >>Services or simply type services.msc in Windows Run or Search box. Find the service named WebStatistica.  R
e-start the WebSTATISTICA service for the DSN changes to take effect.

              User-added image
        
Method 2: Updating Default DSN

 
     Note : This method can be followed on Statistica version 12.5 and later only

     The default DSN can be changed from the Enterprise login screen on the application server.  This method will update the registry underneath the hood. 

          1. Login to the application server as a user with administrator privileges.

          2.  Right click on the Statistica icon on and hold down the shift key until the login window opens (if integrated login is enabled). Select Run as administrator

  
            User-added image

         3.    Enable the option "Set as default System DSN " and then click OK. 


                  User-added image

         4. Restart the WebStatistica service as detailed in Method 1, Step 5.