Skip to main content

Notifications

Microsoft Dynamics SL (Archived)

Database Authentication

(0) ShareShare
ReportReport
Posted on by 30

My company is about to deploy SL 2011 FP1. I would prefer to to use Windows authentication in my ODBC connections if possible. If I leave FRx out of the picture, can I use windows auth exclusively or is mixed mode still required?

Is the Master60SP user still necessary?

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Database Authentication

    Hello JEFF

    Sure, You could define Windows Authentication for SL 2011 FP1.

    Please find below the steps to be followed for Windows Authentication setup for Dynamics SL 2001 FP1.

    1) Open the OBDC Data Source Administrator  from Control Panel-> Administrative Tools

    2) Delete the existing ODBC connections for both Solomon Application and System databases if exists

    3) Open the Database Maintenance (98.290.00) screen under Control Panel-> Administrative Tools

    4) Connect the server using windows credentials

    5) Go the Update Database tab and select the appropriate SL System and Application databases

    6) Click the Set Authentication Type button & select the Windows Authentication (recommended) option and click Ok

    7) Specify the Windows Username for Microsoft Dynamics SL Administrator (SYSADMIN)  and click OK

    8) Once the process is completed try to launch Dynamics SL 2011 Fp1 with windows login credentials

    Even you can login the FRx using windows authentication

    For FRx you have to define the following configuration settings in ODBC connections for both Solomon Application and System databases

    1) Open the OBDC Data Source Administrator  from Control Panel-> Administrative Tools

    2) Select the SL Application Database - DSN

    3)  Click the Configure button

    4)  Verify the DSN name and Server information and click the next button

    5)  Select the Option box for "Connect to SQL Server to obtain default settings for the additional configuration options"

    6) Also select the option "With Windows NT authentication using the network login ID" and process the other steps as usual

    Hope this may helps you

    Thanks & Regards

    D.Santhosh

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans