Hi,
How can I find the CMS datbase name and details if I don’t have them ? Please note the CMS is down so I cant login to the CMC to check.
Unfortantly a QA instance I support (as a favour) has gone down, everytime I try and start the CMS it moans about the CMS db, however not one bit of the documenation I was given lists the CMS db name ggrrrrrr
Fiona 
(BOB member since 2002-12-16)
Can you not log on to your database server to find this out?
Mak 1 (BOB member since 2005-01-06)
For security reasons, when you enter the CMS db username/password it gets stored encrypted.
The downside, you can not retrieve the details.
hitman (BOB member since 2008-08-14)
Thats the thing I dont know the db server, name or anything at all 
Is it in a config file anywhere the db server name ? Just want to get the DBA’s to look at it.
Fiona (BOB member since 2002-12-16)
You can pretty much find out the database server name, database name, user name. Most likely you won’t be able to find out the password but you can ask the DBA to reset it - just be carefut to change the password everywhere it is used.
First you need to find out which DBMS is is using - MS SQL server? Oracle? MySQL? Then things become much easier - MS SQL would have an ODBC DSN, Oracle would have a TNSNAMES.ORA file, etc. If you have no clue what DBMS it is using - ask your DBA. Also you can poke around trying to find out all the possible files.
Once the database is decided, it is much easier to find out the user name. For SQL server, the user name is right in the ODBC DNS definition, and your DBA should be able to find the user name based on the the database server side as well.
newgun 
(BOB member since 2007-08-01)