This is not a demand for support; it's simply that WiX.chm says to put
suggested UI enhancements to this mailing list. Of course if you've already
done this I'd be delighted to hear from you...

Browse SQL Servers dialog
A lot of solutions involve deploying a database. It's all very well to be
able to throw SQL at a server but first it would be helpful to select which
server. There may be several even on the local machine (SQL Server
supporting multiple instances, particularly common with SQLEXPRESS).

Some applications require the SQL Server be configured to support Standard
Security (ie not domain based trusted connections) and you need to probe for
this and indicate SQL Servers that are visible but unsuitable so as to clue
in the network administrators to go reconfigure them. So a mechanism is
required to express to the UI whether to require Mixed Mode security. 

Browse Database 
Having chosen a SQL Server you then need to pick a database. Parallel to the
problem of folders that may or may not pre-exist, you have to allow for
specifying a non-existent database so that the setup kit user can cause it
to be created. Before you can browse the server's database catalogue you
need valid credentials on the SQL Server. Because setup kit users may be
running with domain administration privileges yet may lack local
administration privilege I am uncertain of the behaviour of this:

<Condition Message="You must be an admin.">
  Privileged
</Condition>

--------------------
Now, I'm pretty wobbly with WiX and I can't code C for nuts but I do know
how to do things like probe a network for SQL Servers and how to pull the
chain of a SQL Server if you want to find out whether you're talking to
MSDE, SQLEXPRESS or the real McCoy. So if one of you WiX gurus would like to
collaborate we could probably make short work of the above.

In particular SQL-DMO is slow as a wet week; I can show you much faster ways
to find all the SQL Servers on a network including the ones configured not
to advertise their services (boy did some skeletons dance out of closets in
one "locked down" workplace heheheh).

-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 268.18.16/729 - Release Date: 21/03/2007
7:52 AM
 


-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users

Reply via email to