Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL forum
Suggested answer

Database Authentication

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?

  • 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

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,558 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,645 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans