DCSIMG
המידע שקיבלת במסגרת בלוג זה הינו מידע כללי בלבד ואין לראות ו\או להסתמך על מידע כאמור כייעוץ ו\או תחליף לייעוץ מכל סוג שהוא ו\או להסתמך עליו לעניין כלשהוא. November 2009 - Posts - Business Intelligence,Technology, Thoughts, Thinking
Sign in | Join | Help

November 2009 - Posts

Israeli BI User Group meeting (#8) - NOV 25th, Wednesday 17:30

Hi All,

I'd like to invite you to our next Israeli BI Group meeting (#8).
When: NOV 25th, Wednesday 17:30.
Where: Microsoft Offices, Ra'anana, 2 Hapnina Street, floor 0, DEKEL meeting room near the reception.

Program:
17:30 - 17:45   Gathering
17:45 - 19:15   Franck Sidi - Microsoft Israel. Comprehensive review on the Madison DWH  Architecture & platform.
19:15 - 19:30   Break  
19:30 - 20:45  Tsahi Nisim - Attunity technical manager. Attunity CDC for SSIS, a complete and affordable solution for integrating continually-changing enterprise   data   using SQL Server     Integration Services (SSIS)
20:45- 21:00    Q&A

Hope to see you there,

Ronen Chenn

How to install ProClarity Analytics Server (X86) on Windows Server 2008 x64

ProClarity installation and configuration

Before installing PAS you must Install IIS7 and the roles services required for ProClarity, then install and configure ProClarity Analytics Server 6.3:

1. Open Server Manager, click Roles, then ‘Add Roles’

2. Check ‘Web Server (IIS)’ and click Next. Then, click Next again.

3. In addition to the defaults, ProClarity requires the following Role Services:

o ASP (which will also add ISAPI Extensions)

o Server Side Includes

o Security: Basic and Integrated (can be either or both)

o IIS6 Management Compatibility (all 4 sub services)

clip_image002

4. Install PAS 6.3 SP2, Install PAS 6.3 SP3

5. After the installation, ProClarity will not work correctly because the application pool identity is unable to read the IIS configuration file. To resolve this follow these steps:

o Navigate to %windir%\System32\inetsrv\config\

o Right click on ‘applicationHost.config’ and select properties

o On the Security tab, click Edit -> Add

o Select ‘Locations’, scroll to the top of the list, and select the computer <servername> and click ‘ok’

o Click the object name ‘Network Service’ and then click ok. This will default to ‘Read’, and ‘Read & Execute’ permissions, which is the required access level.

o Click ok -> yes -> ok. (Note: If another account is going to be used to run the application pool, follow these steps to grant required access to that account).

o Stop the following 3 services: ‘IISADMIN’, ‘WAS’, ‘W3SVC’ and then start all 3 (Hint: a good place to do this is from server manager > Roles > Web Server node)

clip_image004

6. At this point the ProClarity website is functioning however when libraries and books are created the web interface will loop between the library and book level. To fix this follow these steps (see also: http://support.microsoft.com/kb/927947):

o Navigate to %root%\inetpub\wwwroot\PAS

o Right click on the ‘cache’ folder and select ‘Properties’

o Click the Security tab -> Continue -> Continue and notice the Network Service account already has the required NTFS permissions for this folder. If it did not, you would need to grand Read & Modify rights to the application pool identity account.

o Click ok -> Advanced -> Continue -> Continue and select ‘NETWORK SERVICE’ in the list so it is highlighted.

o Check ‘Replace all existing inheritable permissions on all descendants with inheritable permissions from this object’ and click ok -> Yes.

o If a non-administrator account other than ‘Network Service’ is running the worker process, follow these steps to grant the required access to that account.

clip_image006

Install WebDav (optional)

Cumulative update package 4 for SQL Server 2008 Service Pack 1 - build 10.00.2734

Click here to see what is it for.

Be aware for this Known issues:

After you apply this cumulative update, you may encounter an issue when you try to use SQL Server Agent. For more information about this issue, click the following article number to view the articles in the Microsoft Knowledge Base:

976761 (http://support.microsoft.com/kb/976761/ ) FIX: Error message when you perform a rolling upgrade in a SQL Server 2008 cluster : "18401, Login failed for user SQLTEST\AgentService. Reason: Server is in script upgrade mode. Only administrator can connect at this time.[SQLState 42000]"

976953 (http://support.microsoft.com/kb/976953/ ) FIX: The SQL Server 2008 agent does not automatically resume running after you upgrade to SQL Server 2008 CU7 or SQL Server 2008 Service Pack 1 CU3/CU4 in a stand-alone environment

 

Bye.

Ronen

How to Install ProClarity Professional 6.3 On windows 2008 SP2

This Blog will help you to Install PAS 6.3 On windows 2008 SP2 & to update ProClarity Analytics Server 6.3 with SP3:

Before starting do 3 important things:

1.Backup

2.Backup

3.Backup

Now we are ready to begin, so  follow this steps to install PAS 6.3 and pas 6.3 SP3.


1. Extract the service pack components to your computer. Always extract the components to your hard drive, typically the C drive.
2. Double-click PAS63Hotfix2222.exe. Note: The installation program will stop and restart Internet Information Services (IIS).
3. Clear the PAS cache. For instructions, see step 9 in the section titled Verifying the Application Pool identity and configuring IIS access, later in this document.
To update ProClarity Professional 6.3 with SP3:
 Double-click PRO63Hotfix2222.exe. You may be prompted to restart the computer after the service pack has been installed.
To distribute SP3 to ProClarity Professional 6.3 users:
1. On a computer that is running ProClarity Analytics Server 6.3, open the PAS Administration Tool.
2. In the left pane of the Administration Tool, right-click the Components folder and select New Component.
3. In the New Component dialog box, browse to the location of the hotfix components and select PRO63Hotfix2222.xml.
4. Click OK. The update will display in the Details pane of the PAS Administration Tool.
 
Uninstalling ProClarity 6.3 SP3
These service packs cannot be removed (uninstalled) independently of the products (ProClarity Professional 6.3 or ProClarity Analytics Server 6.3). To remove a service pack, you must uninstall the entire application.
Installing ProClarity Analytics Server 6.3 on Windows Server 2008 (SP2 or R2)
The following instructions describe the steps for installing ProClarity Analytics Server 6.3, the full product, on either Windows Server 2008 SP2 or Windows Server 2008 R2 prior to installing ProClarity 6.3 SP3.

Installing and configuring IIS 7
Before installing ProClarity Analytics Server 6.3 on Windows Server 2008 (SP2 or R2), you must install and configure IIS 7.
1. In Administrative Tools, open Server Manager and click Roles.
2. Click Add Roles.
3. Select Web Server (IIS) and click Next, and then, click Next again.
4. In addition to the default settings, ProClarity Analytics Server 6.3 requires the following Role Services:
• ASP (which also adds ISAPI Extensions)
 ISAPI Filters
 Server Side Includes
• Security (Basic and/or Windows Authentication)
• IIS6 Management Compatibility (including all 4 sub-services)
5. Complete the standard ProClarity Analytics Server 6.3 installation process.

Verifying the Application Pool identity and configuring IIS access
After you have installed ProClarity Analytics Server 6.3, you will need to verify the application pool identify and configure access to IIS.
1. Open IIS Manager and click Application Pools.
2. Right-click the DefaultAppPool and select Advanced Settings.
3. Verify the Application Pool Identity. In Windows 2008 R2, click the Identity property and change the value from ‘ApplicationPoolIdentity’ to ‘Network Service’ or an appropriate domain account.
4. Navigate to the following directory: %windir%\System32\inetsrv\config\ .
5. Right-click applicationHost.config and then select Properties.
6. On the Security tab, click Edit, and then click Add.
7. Select Locations, scroll to the top of the list, and select the computer <servername>. Click OK.

8. Specify the object name. (This is the value you set in step 3; by default, this is Network Service). Then click OK. This defaults to Read and Read and Execute Permissions, which are the required permissions.
9. Click OK, then Yes, and then OK. Set security for the Cache directory as follows (see also: List of the NTFS permissions that ProClarity Analytics Server requires KB 927947 (http://support.microsoft.com/kb/927947):
a. Navigate to the following directory: %systemdrive%\inetpub\wwwroot\PAS
b. Right-click the Cache directory and select Properties.
c. In the Security tab, verify that the account you selected in step 3 (by default, Network Service) has Read and Modify permissions.
d. To add these permissions, click Advanced and Edit.
e. From the list, select the account you selected in step 3 (by default, Network Service).
f. Select the Replace all existing inheritable permissions on all descendants with inheritable permissions from this object check box.
g. Click OK, and then click Yes.
10. Open an administrator command prompt and run the following command: iisreset/noforce.

Installing and configuring WebDAV
If you intend to use the “Publish Files” feature in ProClarity Analytics Server 6.3 SP3, then you must install WebDAV. If you do not plan to use this feature, then WebDAV is not required.
1. If you are deploying ProClarity Analytics Server 6.3 on Windows Server 2008 SP2, you can download WebDAV from one of the following locations:
• 32-bit: http://go.microsoft.com/fwlink/?LinkID=141805
• 64-bit: http://go.microsoft.com/fwlink/?LinkId=105145

If you are deploying ProClarity Analytics Server 6.3 on Windows Server 2008 R2, do the following:
a. Open Server Manager and select Roles.
b. Under the Web Server section, click Add Role Services. Verify that WebDAV Publishing is checked.
c. Click Install.
2. Enable WebDAV functionality in IIS. For instructions, see Installing and Configuring WebDAV on IIS 7.0 (http://go.microsoft.com/fwlink/?LinkID=108052).
3. Add the appropriate WebDAV authoring rule to the PASUploads site.
a. Allow Access enables administrators to restrict the types of files that are published to ProClarity Analytics Server.
b. Allow Access to this Content to enables you to specify which user accounts and groups that have publishing rights.
c. Permissions enable you to assign Read/Write permissions.
4. Restart IIS.
Note: All clients that were connected to the PAS server when WebDAV was enabled must be re-authenticated to the server.

After you have installed and configured ProClarity Analytics Server 6.3, you can install ProClarity Analytics Server 6.3 SP3.

Additional  Info:

 ProClarity forum on Microsoft TechNet (http://go.microsoft.com/?linkid=9647723)
To download ProClarity 6.3 Service Pack 3 for ProClarity Analytics Server 6.3 and ProClarity Professional 6.3, refer to one of the following links:
 Microsoft ProClarity Analytics Server 6.3 SP3 (http://www.microsoft.com/downloads/details.aspx?FamilyID=e6b784a8-e7c2-4e27-9d98-41e2f2fd7467)
 Microsoft ProClarity Professional 6.3 SP3 (http://www.microsoft.com/downloads/details.aspx?FamilyID=62fb965a-987e-4e40-924e-20456db4710d)
=