Share via

Figuring out SQL alias

sns 9,246 Reputation points
2023-02-28T18:09:36.89+00:00

In Sharepoint WFE, I could figure it out SQL alias from windows -system32 -> CLI.exe file

but from respective sql server -> configuration manager ->I don’t see alias details , it’s empty

so please suggest where this sql alias mapped in the backend ? How to trace it out?

because SQL team is not aware of it.

Second question:

after migrating to new sql server , is there any Powershell command to update at all places in Sharepoint farm at once?

third question:

before backup dbs , is it mandatory to stop all SP services ?

Microsoft 365 and Office | SharePoint Server | For business
0 comments
Accepted answer
  1. Stefan Goßner 656 Reputation points Microsoft Employee
    2023-02-28T21:47:08.3633333+00:00

    There is no mapping in the backend. The mapping is done on the SharePoint WFE. SQL client components evaluate the connection string and identify the alias. Then they route the request to the mapped SQL server instance.

    SQL server would only be aware of the alias if the same configuration is done on the SQL server which is optional.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.