How do you set up access to the Microsoft SQL database?

 
 

How can you access the Microsoft SQL Express database or the instance of the XPhone Server or Connect Directory / Virtual Directory Server, for example, to configure a backup?


C4B does not provide the sa password for the default SQL instances. You can, however, configure access to the SQL instance to grant access to users in the context of which e.g. a backup of the databases can take place.

The following description applies only to the Microsoft SQL Server 2014 SP1 Express instance of the XPhone Connect Server installed by the installation wizard. The configuration settings of the XPhone Server or the Connect Directory are located in the UCDATA database it contains.


In the XPhone Server or Virtual Directory program directory, e.g.  "C:\Program Files\C4B\XPhone Connect Server", open the atlas.xml file with a text editor. Navigate to the following section: 


    <Databases>
        <Main type="MSSQL" connection="Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=XPDATA;Data Source=(local)\XPCONNECT" autoLockDown="5" organisationDN="ou=Organisation" configurationDN="ou=Configuration" />
        <Stats type="MSSQL" connection="Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=XPSTATS;Data Source=(local)\XPANALYTICS" autoLockDown="5" />
        <VDir type="MSSQL" connection="Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=XPVDIR;Data Source=(local)\XPCONNECT" autoLockDown="5" />
  </Databases>

Change the value for autoLockDown from 5 to 13 at the places where the access permission is to be set. Save the setting and then restart the XPhone Server service.


Changing the autoLockDown value causes local administrators to have full access to the "XPCONNECT" instance (configuration data of the XPhone Connect Server and the Connect Directory) or "XPANALYTICS" (statistics data).

In XPhone UC V4 there is only one instance called UCS08, here the default value for autoLockDown is 7. Change the value here to 13 too, and restart the service.

Subscribe to our Newsletter

 
 
 
 
 
 
 

Thank you for subscribing. To confirm your subscription, please click the link in your registration email.

 
 

An error occured. Please try again.



Cookies ermöglichen eine bestmögliche Darstellung unserer Dienste. Mit der Nutzung der Seiten von C4B Com For Business, erklären Sie sich damit einverstanden, dass wir Cookies verwenden. mehr Infos