none
SQL Alias not working for Sharepoint 2013 standalone configuration

    Question

  • Sharepoint 2013 standalone is hosted on server A. Now we have a requirement to change sql to server B. We are trying to setup sql alias but its not working. please suggest.
    vendredi 18 mai 2018 14:05

Toutes les réponses

  • Hi PV5454,

    would please share more info about your environment and logs in the event viewer and SharePoint ULS ?

    1- are the servers in the same domain ?

    2-have you checked if the firewall is turned of on the 2 servers ?

    3- have you checked if port (i assume you use standard port 1433) is accessible from sp server?

    try this command ( C:\ telnet  sqlserver 1433) .

    4- check the sql server services are running.

    5- share with us how you configure the sql alias on the sp server.

    SQL Alias for SharePoint
    https://blogs.msdn.microsoft.com/priyo/2013/09/13/sql-alias-for-sharepoint/

    Configuring SQL Server alias with SharePoint Server 2013
    https://blogs.technet.microsoft.com/gabn/2014/04/14/configuring-sql-server-alias-with-sharepoint-server-2013/


    Best Regrads, Ahmed Madany MCTS @twitter http://twitter.com/ahmed_madany @Blog http://ahmedmadany.wordpress.com @LinkedIn http://eg.linkedin.com/pub/ahmed-madany/35/80/2b6


    vendredi 18 mai 2018 20:56
  • Hi Ahmed,

    Thank you for your reply.

    Please find my comments below for your queries:

    1- are the servers in the same domain ?  Yes the servers are in the same domain. It's a standalone server which has both SP and SQL server on same machine.

    2-have you checked if the firewall is turned of on the 2 servers ? Yes 

    3- have you checked if port (i assume you use standard port 1433) is accessible from sp server? 

    try this command ( C:\ telnet  sqlserver 1433) . Yes port is accessible from sp server

    4- check the sql server services are running. Yes

    5- share with us how you configure the sql alias on the sp server.

    configure same as in link below -> https://blogs.technet.microsoft.com/gabn/2014/04/14/configuring-sql-server-alias-with-sharepoint-server-2013/

    Is it possible to set SQL alias for a Standalone server?

    mardi 22 mai 2018 08:52