How do I identify where a sharepoint datasource is defined ?

Question

We are migrating from Sharepoint 2013 to Sharepoint 2016

I have run the stsadm tool (on the sharepoint 2013 server) and in the output there is a line that says

<Database Sitecount="140" Name ="WSS_Content_App1" DataSource="SPSQL"

Which seems to indicate that it expects the database to be on a server called SPSQL - i.e SPSQL is an alias for the database server. However i cannot see where this alias is defined (there is not DNS entry for SPSQL).

Concerned that we wont have this alias (or it will still point to the 2013 db server) when we migrate.

Answer 1

Hi Greg,

if this is a SQL alias it is configured using the SQL Server Client Network Utility directly on the SharePoint machines.

You can launch the SQL Server Client Network Utility from here: c:\windows\syswow64\cliconfig.exe

Cheers,
Stefan