Product:

Cognos Planning 10.1.1

Windows 2008 R2 server

Microsoft SQL 2008 R2

Symptom:

Can not load data into cognos planning application, where you use SQL alias to the datastore.

Error in PlanningErrorLog.csv file:

{DD2EF639-179C-4470-9F75-BF59A01CD86A}    6          2012-06-05 14:35:18.688 UTC +180       EAdminUI_10 10.1.3008.0     pgImportData             cmdLoad_Click            130      EAdminSQL7_10.SQL7.CheckOutputForErrors      -2147220469            Unable to Bulk Load the data.~~~~Error found in output.~~~~SQLState = 08001, NativeError = 53~~Error = [Microsoft][SQL Server Native Client 10.0]Named Pipes Provider: Could not open a connection to SQL Server [53]. ~~SQLState = 08001, NativeError = 53~~Error = [Microsoft][SQL Server Native Client 10.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.~~SQLState = S1T00, NativeError = 0~~Error = [Microsoft][SQL Server Native Client 10.0]Login timeout expired      CNS\CNSMANER            CNS\FIHECNS110AS            CNS\CNSMANER      CNS\FIHECNS110AS            4400    5056

 

Possible Solution:

If you are using SQL server alias to access the Microsoft SQL 2008 server, then you need to create the alias in both 32 bit and 64 bit drivers.

On the Cognos Planning server start SQL Server Configuration Manager

Expand SQL Native Client 10.0 Configuration

Right Click on Aliases and select New Alias.

Enter a alias name  (e.g. cognosds)

Enter the port no, if you do not know port number enter the instance name in the server name field ( servername\instancename )

Enter the Server name, (e.g. name of the SQL server)

Click OK

 

Repeat above for SQL Native Client 10.0 Configuration (32bit).