Description

How do you find out what databases are being used in a Foundation environment?

Applies To

Foundation

Solution

SharePoint

Config DB: Used by central administration to help manage all of your web  applications, site collections, service applications, what's server and services are on the farm etc.  To find out its name go to SharePoint Central Admin > System Settings > Manage Servers in Farms

Content DB: Stores content of web application can be find out through SharePoint Central Admin > Application Management > Manage Content Db. Note there will be one content DB for each web app, plus one for SharePoint.

Winshuttle

LMS: 1. Go  to LMS installation directory (browse from IIS) in services folder you will find a web.config  file in that search for connectionstring keyword you will be able to find database name in that tag.

2. For reporting database, on LMS server in start search for application Loupe Server Administrator , launch it on left side in application screen select Repository Under datastorage click on change for index that will pop up the current DB name used, cancel it after noting it down.

Foundation: From foundation site in settings page under database connection option you can get the name of DB used.

SAPIS: The connection string in the Server Utility on the APP server desktop will give you the name.