CRS XI; CMS Connection Error

[techie2]

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

 

[ramkrish11]

I would guess you will have to reinstall CRS to have the table etc recreated in the new database.

From the installation instructions, I remember (long time back) you are to have the DSN ready when you install.

That was of course my 2c.

 

[techie2]

I did try this step while installing, but could not get it to work. SO I end up installing MSDE just to make sure that installation is good.

I should be able to point to new DB based on DSN connection and this is where I am getting error message.

 

[techie2]

Thanks Guys, I sorted this out.