August 27, 2003 at 8:29 am
Is there a command line version of this cliconfg utility (SQL Server 2000)?
September 2, 2003 at 8:00 am
This was removed by the editor as SPAM
September 2, 2003 at 8:10 am
Not that I am aware of. Anything you need to configure can be done with sp_configure if you don't want to use EM.
Wes
September 3, 2003 at 9:55 am
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply