Announcement

Collapse
No announcement yet.

Setup SQL Server connection , Active Directory Group

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Setup SQL Server connection , Active Directory Group

    My Database (SQL Server 2005) has an AD User Group Authentication MyADGroup , in that group there are several AD Users, for example Jonny
    In the ScriptCase Connection Configuration of my App, i set the Jonny user in my Connection, but it does not connect to the Database, it says invalid user or password.

    Is that possible to set up ? or do i need to create a single user in the Database ?


    Thanks in Advance..

  • #2
    I have no idea what you do but a simple ldap_connect followed by an ldap_bind is all wat we do to check a user. e.g. see here: http://www.scriptcase.net/forum/show...irectory-Group
    But it is a bit of custom code.

    Comment


    • #3
      @nfxmap1:

      Try <domain>\Jonny as User.

      What environment do you use (server os, workstation os)?
      Best regards: - Reinhard -

      I use ScriptCase 8 Enterprise Edition, Version 8.(latest)

      Comment


      • #4
        RHS We tried that, domain\user but did not work, OS = Windows 2008 R2 , workstation OS = Windows 7 Pro.

        I do not know how scriptcase generate the connection string in the background to connect the Application to the Database, But i do not see any other option to setup my connection App. to do a Windows Authentication. IF SOMEBODY from Scriptcase enlighten us in this matter..

        In a .Net app using OLEDB is just a matter to do the correct connection string and done.

        Thanks all.

        Comment


        • #5
          I am talking about the Application connection, not a logical user access authentication with AD.

          Comment


          • #6
            Originally posted by nfxmap1 View Post
            RHS We tried that, domain\user but did not work
            Ok. Then you must change the SQL Server authentication mode from "Windows Authentication mode" to "SQL Server and Windows Authentication mode" (see here). After that you can create a connection with SC (user "sa" and password für SQL Server or create a new user).
            Attached Files
            Last edited by RHS; 02-17-2015, 12:37 PM.
            Best regards: - Reinhard -

            I use ScriptCase 8 Enterprise Edition, Version 8.(latest)

            Comment

            Working...
            X