Link to home
Start Free TrialLog in
Avatar of dev775
dev775

asked on

SQL Server Connection String Utility

Need help to create a utility program that can simplify the configuration of the connection string for a client workstation to connect to a named instance of an SQL Server.  This utility must provide an extremely basic interface so as to be intuitive to even the most illiterate computer user - there would be a drop-down box listing all servers on the network.  Once the user selects the server with the "MYAPP" instance, the utility would read the selected data and add it to the app.config setting.  The DB password will be hard-coded into the app.  Need help with the design and coding of this tool.  Not sure how to "look" for available servers.
ASKER CERTIFIED SOLUTION
Avatar of Gautham Janardhan
Gautham Janardhan

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Gautham Janardhan
Gautham Janardhan

add refernce -> Com - > SQL DMO Object
Microsoft SQLDMO Object Library
Avatar of dev775

ASKER

Ok, thanks.  I will give this a try.  May need a little more help after getting into it.