How to pull connection string details out of a Sharepoint portal site.
using System;
using Microsoft.SharePoint.Portal;
using Microsoft.SharePoint.Portal.Topology;
namespace SPConnStrings
{
///
/// Summary description for Class1.
///
class Class1
{
///
/// The main entry point for the application.
///
[STAThread]
static void Main(string[] args)
{
//
// TODO: Add code to start application here
//
TopologyManager topology = new TopologyManager();
PortalSite portal = topology.PortalSites[new Uri("http://cleanportal")];
Console.WriteLine("Site db :: " + portal.SiteDatabase.SqlConnectionString.ToString());
Console.WriteLine("Profiles db :: " + portal.UserProfileDatabase.SqlConnectionString.ToString());
Console.WriteLine("Services db :: " + portal.ServiceDatabase.SqlConnectionString.ToString());
Console.ReadLine();
}
}
}