DSO Properties
This section explains the elements in the SQL Server Analysis Services configuration file that are related to Decision Support Objects (DSO).
To view or change the properties of the configuration file for an instance of Analysis Services, in SQL Server Management Studio, right-click the Analysis Services instance, and then click Properties. Also, the configuration file can be edited by opening the configuration file (msmdsrv.ini), usually found at C:\Program Files\Microsoft SQL Server\MSSQL.n\OLAP\Config, where n is a sequence installation number.
Note
Connection strings in the configuration file are kept encrypted. If you change any connection string and save the file, then the next time that you open the file, the contents of the connection strings will be encrypted. To see the values of connection strings, use the properties window for an Analysis Services connection in SQL Server Management Studio.
DSO\RepositoryConnectionString
RepositoryConnectionString is a standard OLEDB connection string that points to the SQL Server 2000 Analysis Services repository. If the repository is a Microsoft Access database (an .mdb file), then the path of the file is a local path.
RepositoryConnectionString is used by DSO when repository is locally available on the server. DSO checks the name of the server. If the name of the server is localhost or it is the name of the computer, then DSO uses RepositoryConnectionString, otherwise DSO uses RemoteRepositoryConnectionString..
DSO\RemoteRepositoryConnectionString
RemoteRepositoryConnectionString is a standard OLEDB connection string that points to the SQL Server 2000 Analysis Services repository. If repository is a Microsoft Access database (an .mdb file), then the path of the file is a path of a shared folder.
RemoteRepositoryConnectionString is used by DSO when the repository is located on a remote server. DSO checks the name of the server. If the name of the server is localhost or it is the name of the computer, then DSO uses RepositoryConnectionString, otherwise DSO uses RemoteRepositoryConnectionString.
DSO\LocksDirectory
LocksDirectory is a folder where DSO keeps locking information. Locking information is created and deleted in this folder without any user intervention. Complete access to create, modify, and delete files is required in this folder for all DSO applications.
LocksDirectory contains the path of the folder.
DSO\RemoteLocksDirectory
RemoteLocksDirectory contains the path of a shared folder where locks are kept for DSO applications. See DSO\LocksDirectory for a description of a locks directory.
Note
Security should be enabled in the shared folder so that any DSO application can write, update, or delete the lock files.
See Also