How to enfore SharePoint 2007 server to uses latest protocol to connect to sql 2008 R 2 server RRS feed

  • Question

  • Hi all,

    We have a medium sharepoint farm impletmented with 2 web, 2 app and cluster sql servers. All runing Windows 2008 r2 and SQL server 2008 R2. I user following query to find out the version of driver/protocol used by web servers to my surprise i find that sometime the web/app server is using older version to communicate with sql server.

    How do we ensure or enforce that my SharePoint server always uses Native protocol ver 1930035203 to communicate with back SQL server 2008 R2.

    Thank you in advnace


    Ramakrishna Pulipati SharePoint Consultant Logica Bangalore, INDIA
    Thursday, January 6, 2011 7:31 AM


All replies