TechRepublic|Forums|Windows Forum

Windows Forum

Praise

  • Creator
    Topic
  • March 9, 2020 at 10:29 am #2144802

    SQL & AD connectivity issue.

    by kobirapps · about 4 years, 9 months ago

    Tags: 

    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?

  • Creator
    Topic

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
    Replies
    • March 11, 2020 at 11:46 am #2423466

      SQL & AD connectivity issue

      by ditstek · about 4 years, 9 months ago

      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
      Services
      5. Under Provider Options: check that Allow InProcess is checked
      6. Leave the rest of the fields blank

  • Author
    Replies
Viewing 0 reply threads