Database Connection Strings

WARNING NEWBIE QUESTION:

I dont have any clue where to look to find the database connection strings in Teamsite. Can someone point me in the right direction? We have an old sql server that is being moved to a new one. Im going to assume its in a config file somewhere but no clue.

Thanks a bunch!

Find more posts tagged with

Comments

Migrateduser

If only it were that easy.

You will have connection strings in many different places depending on what you have installed and how you have it configured. If you could start out by giving us the list of installed products and versions, it would be a help.

Some things you'll need to know:
1. Do you have the event subsystem configured?
2. Do you have ReportCenter configured?
3. Do you have OpenDeploy configured to use the scheduler DB
4. Do you have the OD reporting database installed?
5. Do you have any database deployments via either a standalone DataDeploy or DAS?
6. Do you have any UI customizations that might be using their own custom database?

shougom

1.) not sure
2.) not sure
3.) i think so
4.) not sure
5.) we use opendeploy to schedule deployments daily. There are web parts
or sections that get deployed from a user workflow every day. They are
stored in sql server. That is the data I need to move to a new server so I need to point teamsite to the new server via a connection string probably
buried in an xml file somewhere im guessing.
6.) i doubt it

PS. I was hired by a city government who is very thin on staff there are only two of us and both are new with 0 teamsite experience plenty of .net but no interwoven. So im used to finding a dbconn string in a web.config file.

We have teamsite version 6.7.1 sp2 installed and opendeploy. We do not have any other installations such as livesite, media bin, sitepublisher etc.

Thanks in advance.

Migrateduser

Since your main focus is the data that drives the web parts and it is stored in a database, I suspect that you have either DAS or standalone DD in play. Thankfully, all of the connection strings for those are nicely centralized.

Look in /etc/database.xml. Mind you, if you have target side DD, you'll be wanting to check the receivers as well as the base server.

For the scheduler db and other OD related fun, look in /etc/odbase.xml.

And just in case you are using the eventsubsystem, check in /eventsubsystem/conf/jmsconfignew.xml.

shougom

Thanks a million! I see the connection info im looking for in the etc\database.xml file.
Smiley Happy

jagadesh

Thanks a million! I see the connection info im looking for in the etc\database.xml file.

In windows even you can manage the DB connnection as ODBC(Datasources), it will applicable only odbc connections in windows