Hi,
As usual no success talking to BO Support.
I am trying to setup CRS XI implementation. Installed all the components including ASP.Net WCA on one machine with IIS 5.1. CRS installation did installed MSDE for CMS database and everything works fine till here, which means the installation is good.
As part of architecture, I have to point CMS to different SQL Server database sittinng on different box. This is what I did.
Created new database with user having dbo rights.
Created a ODBC DSN from server where CRS XI is installed, which is successfully pointing to DB on other server.
Went to CCM, stopped CMS and pointed to this new database I created.
Started the CMS and everything works fine. I think at this step, CMS initialised and created few tables in the DB.
Now, problem is, when I stop CMS and try to start again, I am getting the following error message. I picked this error message from event log:
---------------
The root server reported an error Initialization Failure. (Reason: Database access error. Reason [Microsoft][ODBC SQL Server Driver][SQL Server]There is already an object named 'CMS_InfoObjects4' in the database..).
---------------
Every time I try to start the CMS, it is trying to create the tables everytime.
Since I was able to create tables; when CMS ran for the 1st time, this means that all the users accounts I am using for connections have required permissions.
Does anybody encountered this problem or any solutions.
Thanks,
Vic
As usual no success talking to BO Support.
I am trying to setup CRS XI implementation. Installed all the components including ASP.Net WCA on one machine with IIS 5.1. CRS installation did installed MSDE for CMS database and everything works fine till here, which means the installation is good.
As part of architecture, I have to point CMS to different SQL Server database sittinng on different box. This is what I did.
Created new database with user having dbo rights.
Created a ODBC DSN from server where CRS XI is installed, which is successfully pointing to DB on other server.
Went to CCM, stopped CMS and pointed to this new database I created.
Started the CMS and everything works fine. I think at this step, CMS initialised and created few tables in the DB.
Now, problem is, when I stop CMS and try to start again, I am getting the following error message. I picked this error message from event log:
---------------
The root server reported an error Initialization Failure. (Reason: Database access error. Reason [Microsoft][ODBC SQL Server Driver][SQL Server]There is already an object named 'CMS_InfoObjects4' in the database..).
---------------
Every time I try to start the CMS, it is trying to create the tables everytime.
Since I was able to create tables; when CMS ran for the 1st time, this means that all the users accounts I am using for connections have required permissions.
Does anybody encountered this problem or any solutions.
Thanks,
Vic