I am facing an issue: Please help me in this ...
My data in residing in SQL Server 2008 (ex- Northwind). I am using Cognos 10 Framework Manager to create a model and establish data source connection. While doing so, I get success at first test but It fails at second step. [/img]
Error message:
XQE-DS-0006 Unable to logon to the datasource.
The connection to the host ,named instance failed. Error: "java.nety.SocketTimeoutException: Receive timeout".Verify the server and instance names and check that no firewall is blocking UDP traffic to port 1433
:-[
How are you connecting to SQL Server - by SQLNCI or by JDBC? Sounds like you might be trying to use the JDBC connection which might not be correctly configured. Try creating a model without the DQM option checked.
MF.
Sent from my iPad using Tapatalk HD