• Creator
  • #2144802

    SQL & AD connectivity issue.

    by kobirapps ·


    I have an AD (WinServer_08_R2) & a database server_Sql (WinServer_2016_R2);

    While trying to connect with my database it wont connect.

    But after pinging few minutes the TTL value increased from 64 to 128 and then it connects.

    recently database migrated from WinServer_08_R2 to WinServer_2016_R2.

    How can i connect to my sql easily without pinging?

You are posting a reply to: SQL & AD connectivity issue.

The posting of advertisements, profanity, or personal attacks is prohibited. Please refer to our Community FAQs for details. All submitted content is subject to our Terms of Use.

All Comments

  • Author
    • #2423466

      SQL & AD connectivity issue

      by ditstek ·

      In reply to SQL & AD connectivity issue.

      Try these steps, hope these will help

      1. Open SQL Server Enterprise Manager
      2. Go to the database server to which you will be adding the linked server
      3. Expand “Security”
      4. Right-click on “Linked Servers” and click on “New Linked Server…”
      5. Fill in the following:
      1. Under the General tab:
      2. Linked Server: adsi (or whatever you want to call it)
      3. Server type: select Other Data Source
      4. Provider name:select OLE DB Provider for Microsoft Directory
      5. Under Provider Options: check that Allow InProcess is checked
      6. Leave the rest of the fields blank

Viewing 0 reply threads