Jump to content

Search the Community

Showing results for tags 'sql auhentication'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • General
    • Announcements and Site News
    • Administration
  • AutoIt v3
    • AutoIt Help and Support
    • AutoIt Technical Discussion
    • AutoIt Example Scripts
  • Scripting and Development
    • Developer General Discussion
    • Language Specific Discussion
  • IT Administration
    • Operating System Deployment
    • Windows Client
    • Windows Server
    • Office

Categories

  • AutoIt Team
    • Beta
    • MVP
  • AutoIt
    • Automation
    • Databases and web connections
    • Data compression
    • Encryption and hash
    • Games
    • GUI Additions
    • Hardware
    • Information gathering
    • Internet protocol suite
    • Maths
    • Media
    • PDF
    • Security
    • Social Media and other Website API
    • Windows
  • Scripting and Development
  • IT Administration
    • Operating System Deployment
    • Windows Client
    • Windows Server
    • Office

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


Member Title


Location


WWW


Interests

Found 1 result

  1. I need to change/edit the password on a system dsn that uses sql authentication. I need to modify this on 400 workstations. I wrote the following to change the password: run("rundll32.exe shell32.dll,Control_RunDLL odbccp32.cpl",@SystemDir,@SW_HIDE) winwait("ODBC Data Source Administrator") ControlCommand ( "ODBC Data Source Administrator", "", "SysTabControl321" , "tabright") Send("!c") winwait("Microsoft SQL Server DSN Configuration") WinWaitActive("Microsoft SQL Server DSN Configuration", "This wizard") Send("!n") WinWaitActive("Microsoft SQL Server DSN Configuration", "How should") Send("!P") sleep(100) send("newpassword") sleep(100) Send("!n") WinWaitActive("Microsoft SQL Server DSN Configuration", "") Send("!n") WinWaitActive("Microsoft SQL Server DSN Configuration", "&Change the language of SQL Server system messages to") Send("!c") Send("{ENTER}") winwait("ODBC Microsoft SQL Server Setup") send("!t") WinWaitActive("SQL Server ODBC Data Source Test", "Test Results") Send("{ENTER}") winwait("ODBC Microsoft SQL Server Setup") send("{TAB}") sleep(100) Send("{ENTER}") winwait("ODBC Data Source Administrator") Send("{ENTER}") My dilemma is that I have more than one system dsn. I cannot get to the right system dsn to edit (click the configure button). The editor does not show this list or text. How can I move to the right dsn to modify. This is for 3rd party software; I have to use sql authentication. Thanks to anyone that can help.
×
×
  • Create New...