Sqlncli11 .Dll On Your
For more information see how to search your PC for. Check to see if you already have sqlncli11.dll on your computer. Dll file may have been moved or renamed by another application.
...
Click on Start menu, run – Enter regedit Select the /bi/samples/images directoryInstall SQL 2012 native client, to make old report connections work (SQLNCLI11).Open firewall ports 80 and 443 for clients, and ports 9300, 9362, 4300, 5701, 9301 for Cognos servers to be able to talk to each other.Setup SSO with Kerberos Active Directory is possible (but not covered here)Change the log on user for the IBM Cognos service to a domain account, instead of Local System.Set the server to trust for delegation inside the Active Directory.Instead of kerberos can you use old windows login, inside cognos configuration setup (enter below values) Save and restart Cognos, try to browse to Check that they are active in Manage – Configuration – System – Appearance.Please Note: In order to access the legacy studios, you must be using Internet Explorer or Mozilla Firefox.For CA11 installations with many users, you can increase the Windows TCP ports If you have anonymous access enabled, select True for Allow Anonymous Property Queries, and click Apply. Under Connections, expand your web server, Sites, and select Default Web Site. You must use lowercase letters on all server names in Cognos Configuration.Configure the AD connection to your domain.Remove the DB2 connection and create a new Microsoft SQL Server connection.Configure the Content Store connection to your SQL server.Save the configuration and start Cognos service.Setup IIS with script found in folder C:\Program Files\ibm\cognos\analytics\cgi-bin\templates\IISEdit the file to include your servers name, then run the CA_IIS_Config.bat from a administrator CMD window.
Set the properties for TcpTimedWaitDelay to use a value of 50 and a base of Decimal.The range for value is from 30 seconds to 300 seconds, with a default value of 240 seconds (4 minutes).After closing the regedit application, restart your computer.Data server connections to PA can give below error if TM1 cert is not loaded in the CA keystore.XTR-ERR-0005 A request to TM1 resulted in error: “ javax.net.ssl.SSLHandshakeException: com.ibm.jsse2.util.h: PKIX path building failed: com.ibm.security.cert.IBMCertPathBuilderException: unable to find valid certification path to requested target”.Add Planning Analytics cert to the keystore. In the same directory, add another DWORD-32 value named TcpTimedWaitDelay. Set the properties for MaxUserPort to use a value of 65534 and a base of Decimal.
Do the same for Maximum number of processes for the report service during non-peak period, and also for Maximum number of processes for the batch report service during non-peak period.Check that Number of low affinity connections for the report service during peak period is not below 8.Values you set, depend on number of users and your hardware.To show info about the Windows server, go to the command prompt and enter MSINFO32.EXE. Planning Analytics have UseSSL=T as default, if the line is missing from tm1s.cfg file.To be able to connect to old TM1 run installation of PA, on CA server, with issetup.exe from \\servername\fileshare\planninganalytics\tm1_winx64h_2.0.93.28_ml.tar\winx64h and select TM1APIs.Report performance can be adjusted in different ways to match your hardwareClick on All Servers drop down – go to Service – go to Report (or Batch Report)Right click on ReportService and select Set PropertiesClick on Settings tab – select Tuning in Category drop-down menu.Set Maximum number of processes for the report service during peak period to a higher value, maybe start with the same number of CPU cores you have on the server. Select C:\Program Files\ibm\cognos\analytics\ibm-jre\jre\lib\security\cacerts file and open it with password changeit.Switch to Signer Certificates and click Add.Browse for c:\install\ibmtm1.arm and open it and give it the name TM1ServerCert.Data Server Connections to PA can give below error if the UseSSL=T is not correct in data connections.XTR-ERR-0005 A request to TM1 resulted in error: “ java.net.SocketException: Connection reset”.Ensure that the Use SSL is marked if the UseSSL=T is in the tm1s.cfg file for the TM1 instance.
0 kommentar(er)
