Hi All,

I was creating User Profile service application and it gave me error, so I created User Profile service application several times which left several User Profile dbs and now I want to remove all the dbs which are not connected to my content db 

I want to which which user profile db is connected to my content db ??

how can i find which user profile db is connected to my content db ??

Hi

this blog will help you out

http://www.toddklindt.com/blog/Lists/Posts/Post.aspx?ID=300

http://thesharepointfarm.com/2014/01/sharepoint-private-properties-in-powershell/

Hi Rajendra,

This did not work for me 

Unable to still find which user profile is connected to my content db 

Thanks 

Hi Jiniv,

As your description, my understanding is that you want to find which databases are connected to the working User Profile Service application. Is it right?

You can do as Central Administration->Application management->manage service applications, select your working User Profile Service application, not open manager profile services page, then select "Properties" under SERVICE APPLICATIONS, then you will see which profile database, synchronization database and social tagging database are connected to the user profile service application, like the screesnhot:

Thanks,

Wendy

Hi Wendy 

I did as you have described but the properties button is disabled and I don't know why 

I have already logged as Admin

Hi Jiniv,

Please make sure you have selected User Profile Service Application, not User Profile Service Application Proxy, like the screeshot:

Thanks,

Wendy

Thank you Wendy for the detailed description but I can assure you that I am selecting User Profile Service Application only 

Hi

If you have access to server, you can use PowerShell to get all SharePoint databases in use-

Get-SPDatabase | Select Name

This command will display all SharePoint databases in use.

Hope it helps.

Hi Jiniv,

Please make sure the account has Full control permission under Adminsitrators and Permissions, like:

Thanks,

Wendy