Cognos 8 - Local with SQL Server

[bradrhine]

Cognos 8 and Personal Sql Server are loaded on my notebook. Cognos services will not start, as it does not recognize seem to recognize the instance of MS SQL Server.

Error Msg:
CM-CFG-5063 A Content Manager configuration error was
detected while connecting to the content store.CM-SYS-5003 Content Manager is unable to access the content store. Verify your database connection parameters and then contact your database administrator.Failed Logon:com.jnetdirect.jsql.g: TCP/IP connection failed to host:localhost java.net.ConnectException: Connection refused: connect url:jdbc:JSQLConnect://localhost:1433/cm.

Any suggestions would be helpful.

 

[xs4citrix]

A default installation of sql server (just hitting next during install) will put the system on allowing windows validation only.

Open sql enterprise manager, right click the server select properties, go to the security tab and put the option on both windows and sql validation.
Then try to start the service again.

Stefan

http://www.printingsupport.com

 

[misscognos]

i dont' believe cognos supports sql server personal edition. check on their support site just to be sure.

 

[xs4citrix]

The personal edition is the same as the full version with some performance caps. (2 concurrent queries and some more)

Maybe not officially supported for performance issues, but works perfectly fine.

Stefan

http://www.printingsupport.com

 

[bradrhine]

Thank you for the suggestions and discussion points. It's all good, but I am still having issues connecting to the (local) on Sql Server.
I sign on to my laptop as a user who has admin rights on the machine.
I think it may have something to do with my laptop name.

Any thought?

 

[xs4citrix]

In the content store config, change the "localhost" sql server entry for the real laptopname and do the same in the environment section of congnos configuration.

Stefan

http://www.printingsupport.com

 

[mfgf]

If you are running SQL Server 2000 Personal Edition, you will also need an update to SQL Server to get it to be recognised by Cognos 8. SP3a or above is required.

Regards,

MF.

 

[JPCogAdmin]

Brad,

Have you tried the local ip address: 127.0.0.1 instead of localhost? Give it a try.

Also do this test. Can you connect through MS-Query Analyser using the localhost as well as 127.0.0.1

Use the one that works. I've ran into such problem before and resolved it through the IP address.

JP

 

[CognosProfessional]

Make sure IIS web extensions allow .cgi files.

CP

 

[bradrhine]

Thanks for the tips. Final solution was to reload the JDBC drivers. Somehow ... I had removed them (one of those phantom deletion episodes). Went to the Microsoft site and downloaded and re-installed them.