• quote:


    Is there a command line version of this cliconfg utility (SQL Server 2000)?


    I've never seen it, but I've had the same need before. What I've done is export the registry keys to a .reg file then executed/merged into a client pc's registry.

    The usual warnings and precautions about messing with the reg apply..

    1. On a machine (similar OS to client )create the alias and all its settings

    2. Open Regedit, export the key under HKLM\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo\youraliasnamehere

    3. Double click the .reg on the client. You will have to confirm that you want to "merge" the file (click OK).

    Since you're specifying it in the alias you don't have to worry about protocol order. if the protocol lib isn't enabled in Cliconfg, you can do this with the other settings in cliconfg too. Just look up one level in the tree.

    Anyways. Hope this helps!


    -Ken