One step learning SQL Server Bi--analysisservice servers configuration

Analysis Services in Sqlserver2005 supports two ways to connect to a database

(1) Windows Authentication Mode (like "Data source=limj"; Catalog=analysis Services Tutorial; connectto=9.0;integrated Security=sspi ");

(2) HTTP authentication mode (like "Provider=msolap"; User Id=administrator; password=119; Persist Security info=true;initial catalog=datacenterdw;data Source=http://limj/olap/msmdpump.dll ")

Because of the needs of the company's software architecture, I choose the latter way here. Let me explain the configuration process on the WINDOW2003 server in this way. (The following article is from Microsoft MSDN)

Overview

Microsoft®sql server™2005 Analysis Services provides HTTP access using the same architecture as SQL Server Analysis Services.

The pump component is loaded into IIS (Internet information Services) and is used as an ISAPI extension to transfer data between the client and the Analysis Services server.

This white paper describes the entire process of using Microsoft Windows server™2003 SP1 to set up HTTP access to analysis Services.

Figure 1 shows an overview of the component architecture.

Get binary data

Get Binary data:

Copy the contents of the%installation Folder%\olap\bin\isapi directory to the folder that you want to use as the basis for the virtual directory in IIS.

In this example, we will copy all the files in the C:\Program Files\Microsoft SQL Server\mssql.1\olap\bin\isapi folder to the C:\inetpub\wwwroot\olap directory.

Note: To use full security settings, it is important to ensure that the folder underlying the virtual directory is on a drive formatted as an NTFS file system.

The path to the directory cannot contain spaces because of IIS restrictions.

If you want to run the HTTP pump on a different server than the analysis Services server, make sure that OLE DB is installed for the Analysis Redistributable Packet.

To create an application library:

1. To open the Computer Management console, open Control Panel, Administrative Tools, and Computer Management in turn.

(Or, right-click the My Computer icon, and then choose Manage on the shortcut menu.) ）

2. In the Computer Management console, expand the Services and Applications node and the Internet Information Services node in turn.

If the Internet Information Services node cannot be found, it may be because IIS is not already installed on your computer. If you want to install, open Add or Remove Programs in Control Panel. Select Add/Remove Windows components. IIS is then added to Windows.

3. Right-click application Pool to open the shortcut menu, select New, and then select the application pool.

4. Specifies the name of the application pool. In this case, we'll name it OLAP. (see Figure 2.) ）

Figure 2

To create a virtual directory:

1. To open the Computer Management console, open Control Panel, Administrative Tools, and Computer Management in turn.

(Or, right-click the My Computer icon, and then choose Manage on the shortcut menu.) ）

2. In the Computer Management console, expand the Services and Applications node and the Internet Information Services node in turn.

If the Internet Information Services node cannot be found, it may be because IIS is not already installed on your computer. If you want to install, open Add or Remove Programs in Control Panel. Select Add/Remove Windows components. IIS is then added to Windows.

3. Right-click Web to open the shortcut menu, select New, and then select the virtual directory.

4. Specify the name of the virtual directory. In this case, we'll name it OLAP.

The content directory should point to the folder you just created. In this case, point to C:\inetpub\wwroot\olap.

5. Make sure that only the second check box is selected to run the script (such as ASP) under access rights. (see Figure 3.) ）

Figure 3