CODEWITHSUNDEEP
sharepointsharepoint-2010
Acaz Souza
Acaz Souza

Reputation: 8631

How do I know which database is configured SharePoint?

I'm in a machine that has already SharePoint installed, so when I started the SharePoint Central Administration to config, this message appear to me: "Can not connect to the database configuration."

How do I know which database is configured SharePoint?

Upvotes: 0

Views: 2247

Answers (2)

Paul Leigh
Paul Leigh

Reputation: 1231

Normally the Admin database is created using the naming convention SharePoint_AdminContent_{GUID}. However if there's more than one, you'll need to use SQL Management studo or other tool to look inside the DBs, look for a table called "DatabaseInformation" which will contain two items, look in the AlternateAccessMappingXML entry and look for the XML tage IncomingUrl, that should help you narrow it down.

Or just use the SQL profiler and watch for connections.

Upvotes: 2

Shadow Wizard
Shadow Wizard

Reputation: 66389

By default SharePoint will install the Database on the same machine as the web server, but you can ask whoever installed SharePoint on the machine.

Anyhow, most likely it's not relevant and something else is the problem, follow the resolution methods described here and you'll probably have it fixed.

Upvotes: 0

Related Questions