Announcement

Collapse
No announcement yet.

Need help with SQL Server authentication

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

  • Need help with SQL Server authentication

    I am a complete N00b at this...so I am leaning to the experts here at Petri.
    I have a SQL Server 2008 setup. I have it completely configured. I need a script that I can use in my Group Policy to automatically insert the LoginID and the Password that is being used by my System DSN. I want SQL Server authentication to be the mode chosen as well. I have over 100 computers that I would have to do this for, so I need to be able to do this by GPO's preferably.

    Is this possible?

  • #2
    Re: Need help with SQL Server authentication

    Ok...a little more info. I don't need to use a script for the loginid or password, all I need is a script to point to the correct server and the correct system DSN.

    Comment


    • #3
      Re: Need help with SQL Server authentication

      Man, the things people want to do in code...
      ok, so if I understand this correctly, you've got 100 boxes to configure and you want to set the DSNs for each one to use sql auth and a specific individual username/password... prob a separate one for each box... is that correct?
      Sean McCown, SQL Server MVP

      See my FREE SQL Server training videos at:
      http://www.MidnightDBA.com

      Blog Author of:
      Database Underground -- http://infoworld.com/blogs/sean-mccown
      DBA Rant http://dbarant.blogspot.com

      Comment


      • #4
        Re: Need help with SQL Server authentication

        ODBC connections are saved in the registry.
        Have you tried to create one on your own PC, export the registry and import it again?
        Marcel
        Technical Consultant
        Netherlands
        http://www.phetios.com
        http://blog.nessus.nl

        MCITP(EA, SA), MCSA/E 2003:Security, CCNA, SNAF, DCUCI, CCSA/E/E+ (R60), VCP4/5, NCDA, NCIE - SAN, NCIE - BR, EMCPE
        "No matter how secure, there is always the human factor."

        "Enjoy life today, tomorrow may never come."
        "If you're going through hell, keep going. ~Winston Churchill"

        Comment


        • #5
          Re: Need help with SQL Server authentication

          Well, I would imagine that you could copy the reg key into a file and then modify it for each box. Powershell would be perfect for something like that. Then once you've got all the files you want store them in a central location and have your logon script run it locally on each box. That would do what you needed.
          Sean McCown, SQL Server MVP

          See my FREE SQL Server training videos at:
          http://www.MidnightDBA.com

          Blog Author of:
          Database Underground -- http://infoworld.com/blogs/sean-mccown
          DBA Rant http://dbarant.blogspot.com

          Comment

          Working...
          X