Re: [WiX-users] Re mote SQL Authentication

2008-09-09 Thread David Reed (SQL)
If the identity running the installation doesn't have sysadmin privileges, you're not going to be able to grant anything to yourself... Maybe I'm not understanding the workflow that you're trying to achieve. We can take it offline if you like. -Original Message- From: [EMAIL PROTECTE

Re: [WiX-users] Attach a database

2008-08-15 Thread David Reed (SQL)
ding to my ideas. I'm newbie in Wix, so I'm only discovering magics of this beautiful technology ;) David Reed (SQL) wrote: > > I'm a little confused on the desired outcome. You're detaching the > database on uninstall, instead of dropping it (which would delete the >

Re: [WiX-users] SqlScript Connection Question

2008-08-15 Thread David Reed (SQL)
I haven't peeked at the code, but based on your description, I'll bet that it's closing and reopening connections for each SQL string instead of using connection pooling, etc. Fire up SQL Profiler and cap a trace of connection events during the installation and that will tell you for sure what

Re: [WiX-users] Attach a database

2008-08-14 Thread David Reed (SQL)
I'm a little confused on the desired outcome. You're detaching the database on uninstall, instead of dropping it (which would delete the files)... You're also trying to drop the database elsewhere while the connection context is mapped to the database you're trying to drop, which won't work (you

Re: [WiX-users] Dynamically naming a database during its installation - WiX VERSION 3.0.4318.0

2008-08-07 Thread David Reed (SQL)
Nic, what I've been doing is using the sql:sqldatabase as an anchor outside a component with "master" as the target database (since it's guaranteed to be there and any authenticated user is guaranteed to be able to connect to it), then I use the sql:sqlstring to restore the database from a compr

Re: [WiX-users] Sql Server: Reporting Services

2008-06-17 Thread David Reed (SQL)
Murray, I was asked about this by customers and MVPs @ TechEd, so it's on the radar (mine, at least). If you'd like to feed your requirements into my team and/or SSRS', I'd be happy to hear them offline. Ditto for Integration Services. If my team builds "it" (whatever it is) for SSRS deployment,

[WiX-users] Disabling feature options on parent feature?

2008-06-16 Thread David Reed (SQL)
I've got a set of features that I moved under a new parent feature, and the new parent feature has a pair of options that A) don't make sense and B) I don't want... but I don't see how to disable them in the v3 schema. They only appear for the parent feature when it has children; other features

Re: [WiX-users] What does this WiX3 build error mean?

2008-06-12 Thread David Reed (SQL)
in solution explorer and in the resulting dialog add > WixSqlExtensions.dll. > > Neil > > -Original Message- > From: [EMAIL PROTECTED] [mailto:wix-users- > [EMAIL PROTECTED] On Behalf Of David Reed (SQL) > Sent: Thursday, June 12, 2008 3:27 PM > To: wix-users@lists

[WiX-users] What does this WiX3 build error mean?

2008-06-12 Thread David Reed (SQL)
Howdy, folks. I've been trying to keep up with the evolution of 3 in the weeklies, and so far none of the breaks have been too painful, but I don't understand what to do to remediate this one from Visual Studio 2008: The Product element contains an unhandled extension element 'sql:SqlDatabase'.