[WiX-users] ExecuteSqlStrings fails with the Error 0x80004005: failed to connect to database: 'master'

2011-10-07 Thread Yan Sklyarenko
Hello WiX Community, I have the following problem. I have a number of SqlString elements which run CREATE DATABASE ... FOR ATTACH kind of queries. It fails to run on SQL 2008 (I tested on R2, but it seems that pure 2008 is also affected), DEFAULT INSTANCE ONLY. I mean, if I specify any named

Re: [WiX-users] ExecuteSqlStrings fails with the Error 0x80004005: failed to connect to database: 'master'

2011-10-07 Thread Michael Osmond
Hi Looks like an Access Denied to me. Try the following to work out what is going on; This is from an MS Blog If the server encounters an error that prevents a login from succeeding, the client will display the following error mesage. Msg 18456, Level 14, State 1, Server server name, Line

Re: [WiX-users] ExecuteSqlStrings fails with the Error 0x80004005: failed to connect to database: 'master'

2011-10-07 Thread Yan Sklyarenko
Thanks for the suggestion, Michael! To determine the true reason for the failure, the administrator can look in the server's error log where a corresponding entry will be written. Could you please point out where I can find this server's error log referenced here? -- Yan On Fri, Oct 7, 2011

Re: [WiX-users] Incremental vs. cumulative patches (.msp)

2011-10-07 Thread Peter Shirtcliffe
My preference is for cumulative patches. There's trade off between size and complexity. Cumulative patches - are less confusing for the user. There is only ever 1 patch to apply - the latest. Support is also easier for this reason. - are quicker and easier to apply once there are more than a few

Re: [WiX-users] ExecuteSqlStrings fails with the Error 0x80004005: failed to connect to database: 'master'

2011-10-07 Thread David Watson
I use SQL Profiler to diagnose things like this. Get a trace going and run your MSI against it and you can see the exact sql that is sent to the server and the servers responses. -Original Message- From: Yan Sklyarenko [mailto:yansklyarenko+...@gmail.com] Sent: 07 October 2011 09:00

Re: [WiX-users] Fwd: iis website creation fails for windows server 2008R2 with SP1

2011-10-07 Thread John Cooper
The main installer I support creates a web site with several web services and is specifically targeted at IIS7.5 and Windows Server 2008R2 including SP1. While Wix doesn't support all the configurations I need to do to IIS7.5, the ones it does support work fine. -Original Message-

Re: [WiX-users] Fwd: iis website creation fails for windows server 2008R2 with SP1

2011-10-07 Thread Bhaumik Barot
I checked the verbose log for wix doesnt give me any details .Actually installation finishes without any error.But when I go to IIS I don't see application pool or website. On Thu, Oct 6, 2011 at 5:23 PM, Castro, Edwin G. (Hillsboro) edwin.cas...@fiserv.com wrote: David suggested that you

Re: [WiX-users] Fwd: iis website creation fails for windows server 2008R2 with SP1

2011-10-07 Thread John Cooper
Do you have Orca? What's in the IIsWebAddress table? Not much works right on configuration if this table doesn't have some reasonable values in it. What is in your IIsAppPool table? Again, it needs to be populated with some minimal values before AppPool configuration is going to happen. --

Re: [WiX-users] Fwd: iis website creation fails for windows server 2008R2 with SP1

2011-10-07 Thread Castro, Edwin G. (Hillsboro)
The services I deploy also get deployed correctly on IIS 7.5 on Windows Server 2008 R2 SP1. Perhaps the components for IIS configuration are not getting selected? The verbose log would show whether this is the case or not. Edwin G. Castro Software Developer - Staff Digital Channels Fiserv

Re: [WiX-users] VS 11 macros

2011-10-07 Thread Rob Mensching
To be clear, Beta of VS not Beta of WiX toolset. On Tue, Oct 4, 2011 at 7:20 PM, Bob Arnson b...@joyofsetup.com wrote: On 04-Oct-11 02:00, Paul A. Steckler wrote: Does anyone know if macros like VS11_ROOT_FOLDER, etc., will be available in a coming version of the WiX toolset? Soon, maybe?

Re: [WiX-users] Fwd: iis website creation fails for windows server 2008R2 with SP1

2011-10-07 Thread Bhaumik Barot
I figured the issue that was in my custom action . I had disabled the exception before. Thanks all for you help. On Fri, Oct 7, 2011 at 11:52 AM, Castro, Edwin G. (Hillsboro) edwin.cas...@fiserv.com wrote: The services I deploy also get deployed correctly on IIS 7.5 on Windows Server 2008 R2

Re: [WiX-users] ExecuteSqlStrings fails with the Error 0x80004005: failed to connect to database: 'master'

2011-10-07 Thread Michael Osmond
Yan, You will find the Server Log in Management Studio - Under Management - SQL Server Logs. Sorry on the delay, I went home before I got your reply. Michael -Original Message- From: Yan Sklyarenko [mailto:yansklyarenko+...@gmail.com] Sent: Friday, 7 October 2011 6:00 PM To: