Hello,
Before I start, here are the specs for my laptop:
Windows 7 Professional
MS SQL Server 2000
Cognos 10
I am trying to bridge the connection between Cognos 10 and SQL Server 2000. I created a cm database within SQL Server, but when I try to connect to it through Cognos Configuration, I get an error while testing the newly created content store. Also, when I look at properties of the cm database I have created, the collation name is blank, even though I specifically chose SQL_Latin1_General_CP1_CI_AS. I have tried deleting and recreating the database with this collation name, still, under properties, it is blank. So I went to Query Analyzer and typed this in:
"ALTER DATABASE cm COLLATE SQL_Latin1_General_CP1_CI_AS"
Then, the collation name exists under properties. But when I exit out of query analyzer, the collation name goes back to blank/null.
I have used sa/sa as my username and password.
What is going on? Why can't cognos connect to my cm database?
Before I start, here are the specs for my laptop:
Windows 7 Professional
MS SQL Server 2000
Cognos 10
I am trying to bridge the connection between Cognos 10 and SQL Server 2000. I created a cm database within SQL Server, but when I try to connect to it through Cognos Configuration, I get an error while testing the newly created content store. Also, when I look at properties of the cm database I have created, the collation name is blank, even though I specifically chose SQL_Latin1_General_CP1_CI_AS. I have tried deleting and recreating the database with this collation name, still, under properties, it is blank. So I went to Query Analyzer and typed this in:
"ALTER DATABASE cm COLLATE SQL_Latin1_General_CP1_CI_AS"
Then, the collation name exists under properties. But when I exit out of query analyzer, the collation name goes back to blank/null.
I have used sa/sa as my username and password.
What is going on? Why can't cognos connect to my cm database?