1

Under 'Manage Content Database Settings' in Central Administration, where it says 'Database Information' on the left, is a name under 'Database server' on the right that I do not recognize, say DBCA. There is a database server in the farm with all the right databases, but that server has a different name, say DBSQL. I have looked at the Server Configuration Manager on DBSQL for aliases, but there are none. Also, SSMS does not see a server by the name DBCA anywhere on the network.

The site is working. My SharePoint experience has focused on development rather than administration, but I ran across this troubleshooting another issue, and it has me stumped. Can anyone shed some light on how this might be?

Improve this question

1 Answer 1

Reset to default
0

Couple of thing you can try to solve the mystery.

  1. open the command prompt and ping dbcs, you will get ip if it is correct. Tum command prompt on SharePoint server as well.
  2. Check the host file on the SharePoint server, maybe someone has entry which points to dbsql.
  3. From central admin..system settings..cluck on manger server in this farm...check which db server listed here.
  4. Also Check on the SharePoint servers, if someone configured the SQL Alias on the servers.
Improve this answer
5
  • Good suggestions, thanks Waqas Sarwar. Here is what I found when I tried them: 1) DBCA does not ping, DBSQL does. Not sure what you mean by "Turn command prompt on SharePoint server as well. 2) No entry for DBCA in host file. 3) DB server listed in 'Servers in Farm' is also DBCA.
    – Echo Train
    Jul 14, 2017 at 13:30
  • i mean ping the DBCA from SharePoint server? do you have SQL Alias Configured on the SharePoint server
    – Waqas Sarwar MVP ♦
    Jul 14, 2017 at 13:34
  • follow this guid to test the connection...blogs.msdn.microsoft.com/priyo/2013/09/13/… dont create new entry just check it
    – Waqas Sarwar MVP ♦
    Jul 14, 2017 at 13:36
  • The suggestion to "follow this guide..." solved the mystery. Basically, the guide involves running the "SQL Server Client Network Utility" which I did not know about. Clicking the "Alias" tab in this utility showed an alias of DBCA mapped to DBSQL. Putting this together with what I know about the farm's backup policy, I conclude this was done to simplify switching over to the backup database in the event of the primary's failure. Thank you so much!
    – Echo Train
    Jul 14, 2017 at 14:18
  • great, i am happy we able to resolve the mystery. This is one of the best practice that create sql alias to make DR or failover easy.
    – Waqas Sarwar MVP ♦
    Jul 14, 2017 at 14:20

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.