Durango122
MIS
Hello
I'm new to this Crystal Server XI and i have some problem
Platform: win 2000
database: using ms access database
set as SQL Server system database
I install all went fine till it prompt me to insert user id and password to the cmc
it set as administrator and password to leave blank and connect to enterprise according to the instruction sheet
error get not a valid user
i try again this time using my nt connection and password and select nt autho in the drop list but no chance
i check the folder in the business object XI and select the cmc
and right click to start no luck
in the cmc proprety window under the configuration i click on it and i get this error:
Failed to retreive cluster name from database. Reason: Database access error. Reason[Microsoft][ODBC Microsoft Acess Driver]syntax error in Create Table statement...
Under the command line option i have
Port number 6400 and used default port number check
CMS datasource
i have this
Crystal_Server_DATABASE and click specify
i have select a data source check
and click ok
Select Database driver windows popup and i check SQL Server(ODBC)
i click ok
I select Machine data source
and select Crystal_Server_DATABASE
Type: system
Description
User and Group
click ok
then login window appaers
Data source
I see Crystal_Server_Database is inserted
as for authorization
Login anme and password are blank since when created the system dsn i did not specified a login or password
and i did select ms access driver in the creation of the connection
My access database has no table in it
just a blank database
just wanted to create data source to run the cmc
and then be able the schedule.
then when i'm able to schedule the report and save them in a pdf format i will move the pdf to enterprise and them available to view
2. My tomcat server will not start i tried and tried no luck
Thank for your help
I 'm loset here
thanks a million
Durango122
I'm new to this Crystal Server XI and i have some problem
Platform: win 2000
database: using ms access database
set as SQL Server system database
I install all went fine till it prompt me to insert user id and password to the cmc
it set as administrator and password to leave blank and connect to enterprise according to the instruction sheet
error get not a valid user
i try again this time using my nt connection and password and select nt autho in the drop list but no chance
i check the folder in the business object XI and select the cmc
and right click to start no luck
in the cmc proprety window under the configuration i click on it and i get this error:
Failed to retreive cluster name from database. Reason: Database access error. Reason[Microsoft][ODBC Microsoft Acess Driver]syntax error in Create Table statement...
Under the command line option i have
Port number 6400 and used default port number check
CMS datasource
i have this
Crystal_Server_DATABASE and click specify
i have select a data source check
and click ok
Select Database driver windows popup and i check SQL Server(ODBC)
i click ok
I select Machine data source
and select Crystal_Server_DATABASE
Type: system
Description
User and Group
click ok
then login window appaers
Data source
I see Crystal_Server_Database is inserted
as for authorization
Login anme and password are blank since when created the system dsn i did not specified a login or password
and i did select ms access driver in the creation of the connection
My access database has no table in it
just a blank database
just wanted to create data source to run the cmc
and then be able the schedule.
then when i'm able to schedule the report and save them in a pdf format i will move the pdf to enterprise and them available to view
2. My tomcat server will not start i tried and tried no luck
Thank for your help
I 'm loset here
thanks a million
Durango122