Re: [WiX-users] Is it possible to change default database port?
Yes that should work (sorry I missed the comma in my original reply). Neil -Original Message- From: George Fleming [mailto:gef...@microsoft.com] Sent: 14 May 2013 00:40 To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Is it possible to change default database port? Wix already has a separate instance attribute. So for Server attribute, specify server,port? -Original Message- From: John Cooper [mailto:jocoo...@jackhenry.com] Sent: Monday, May 13, 2013 1:33 PM To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Is it possible to change default database port? Yes, server,port/instance or server,port would be correct. Got it out of sequence in my last post. -- John Merryweather Cooper Build Install Engineer - ESA Jack Henry Associates, Inc.® Shawnee Mission, KS 66227 Office: 913-341-3434 x791011 jocoo...@jackhenry.com www.jackhenry.com -Original Message- From: Edwin Castro [mailto:egca...@gmail.com] Sent: Monday, May 13, 2013 1:43 PM To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Is is possible to change default database port? On Mon, May 13, 2013 at 11:20 AM, John Cooper jocoo...@jackhenry.comwrote: You can pass the server/instance pair to the Server attribute. I've never tried this with SqlDatabase, but can you pass the server/instance,port? I would expect server,port to work as well. -- Edwin G. Castro -- AlienVault Unified Security Management (USM) platform delivers complete security visibility with the essential security capabilities. Easily and efficiently configure, manage, and operate all of your security controls from a single console and one unified framework. Download a free trial. http://p.sf.net/sfu/alienvault_d2d ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users NOTICE: This electronic mail message and any files transmitted with it are intended exclusively for the individual or entity to which it is addressed. The message, together with any attachment, may contain confidential and/or privileged information. Any unauthorized review, use, printing, saving, copying, disclosure or distribution is strictly prohibited. If you have received this message in error, please immediately advise the sender by reply email and delete all copies. -- AlienVault Unified Security Management (USM) platform delivers complete security visibility with the essential security capabilities. Easily and efficiently configure, manage, and operate all of your security controls from a single console and one unified framework. Download a free trial. http://p.sf.net/sfu/alienvault_d2d ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users -- AlienVault Unified Security Management (USM) platform delivers complete security visibility with the essential security capabilities. Easily and efficiently configure, manage, and operate all of your security controls from a single console and one unified framework. Download a free trial. http://p.sf.net/sfu/alienvault_d2d ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users -- AlienVault Unified Security Management (USM) platform delivers complete security visibility with the essential security capabilities. Easily and efficiently configure, manage, and operate all of your security controls from a single console and one unified framework. Download a free trial. http://p.sf.net/sfu/alienvault_d2d ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
Re: [WiX-users] Is it possible to change default database port?
That is true, but for UI-related reasons it is easier for my products to handle it as server,port\instance. Splitting would require some extra work. That being said, I only have one product that uses SqlDatabase, SqlScript, and SqlString to deploy its database. The rest use VsdbCmd or SqlPackage. -- John Merryweather Cooper Build Install Engineer - ESA Jack Henry Associates, Inc.® Shawnee Mission, KS 66227 Office: 913-341-3434 x791011 jocoo...@jackhenry.com www.jackhenry.com -Original Message- From: George Fleming [mailto:gef...@microsoft.com] Sent: Monday, May 13, 2013 6:40 PM To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Is it possible to change default database port? Wix already has a separate instance attribute. So for Server attribute, specify server,port? -Original Message- From: John Cooper [mailto:jocoo...@jackhenry.com] Sent: Monday, May 13, 2013 1:33 PM To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Is it possible to change default database port? Yes, server,port/instance or server,port would be correct. Got it out of sequence in my last post. -- John Merryweather Cooper Build Install Engineer - ESA Jack Henry Associates, Inc.® Shawnee Mission, KS 66227 Office: 913-341-3434 x791011 jocoo...@jackhenry.com www.jackhenry.com -Original Message- From: Edwin Castro [mailto:egca...@gmail.com] Sent: Monday, May 13, 2013 1:43 PM To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Is is possible to change default database port? On Mon, May 13, 2013 at 11:20 AM, John Cooper jocoo...@jackhenry.comwrote: You can pass the server/instance pair to the Server attribute. I've never tried this with SqlDatabase, but can you pass the server/instance,port? I would expect server,port to work as well. -- Edwin G. Castro -- AlienVault Unified Security Management (USM) platform delivers complete security visibility with the essential security capabilities. Easily and efficiently configure, manage, and operate all of your security controls from a single console and one unified framework. Download a free trial. http://p.sf.net/sfu/alienvault_d2d ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users NOTICE: This electronic mail message and any files transmitted with it are intended exclusively for the individual or entity to which it is addressed. The message, together with any attachment, may contain confidential and/or privileged information. Any unauthorized review, use, printing, saving, copying, disclosure or distribution is strictly prohibited. If you have received this message in error, please immediately advise the sender by reply email and delete all copies. -- AlienVault Unified Security Management (USM) platform delivers complete security visibility with the essential security capabilities. Easily and efficiently configure, manage, and operate all of your security controls from a single console and one unified framework. Download a free trial. http://p.sf.net/sfu/alienvault_d2d ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users -- AlienVault Unified Security Management (USM) platform delivers complete security visibility with the essential security capabilities. Easily and efficiently configure, manage, and operate all of your security controls from a single console and one unified framework. Download a free trial. http://p.sf.net/sfu/alienvault_d2d ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users NOTICE: This electronic mail message and any files transmitted with it are intended exclusively for the individual or entity to which it is addressed. The message, together with any attachment, may contain confidential and/or privileged information. Any unauthorized review, use, printing, saving, copying, disclosure or distribution is strictly prohibited. If you have received this message in error, please immediately advise the sender by reply email and delete all copies. -- AlienVault Unified Security Management (USM) platform delivers complete security visibility with the essential security capabilities. Easily and efficiently configure, manage, and operate all of your security controls from a single console and one unified framework. Download a free trial. http://p.sf.net/sfu/alienvault_d2d
[WiX-users] Is is possible to change default database port?
Default SQL Database IP port is 1443. Is it possible to change this value? I don't see any port attribute in the SqlDatabase element of Wix. George -- Learn Graph Databases - Download FREE O'Reilly Book Graph Databases is the definitive new guide to graph databases and their applications. This 200-page book is written by three acclaimed leaders in the field. The early access version is available now. Download your free book today! http://p.sf.net/sfu/neotech_d2d_may ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
Re: [WiX-users] Is is possible to change default database port?
You can pass the server/instance pair to the Server attribute. I've never tried this with SqlDatabase, but can you pass the server/instance,port? -- John Merryweather Cooper Build Install Engineer - ESA Jack Henry Associates, Inc.® Shawnee Mission, KS 66227 Office: 913-341-3434 x791011 jocoo...@jackhenry.com www.jackhenry.com -Original Message- From: George Fleming [mailto:gef...@microsoft.com] Sent: Monday, May 13, 2013 12:16 PM To: WiX-users@lists.sourceforge.net Subject: [WiX-users] Is is possible to change default database port? Default SQL Database IP port is 1443. Is it possible to change this value? I don't see any port attribute in the SqlDatabase element of Wix. George -- Learn Graph Databases - Download FREE O'Reilly Book Graph Databases is the definitive new guide to graph databases and their applications. This 200-page book is written by three acclaimed leaders in the field. The early access version is available now. Download your free book today! http://p.sf.net/sfu/neotech_d2d_may ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users NOTICE: This electronic mail message and any files transmitted with it are intended exclusively for the individual or entity to which it is addressed. The message, together with any attachment, may contain confidential and/or privileged information. Any unauthorized review, use, printing, saving, copying, disclosure or distribution is strictly prohibited. If you have received this message in error, please immediately advise the sender by reply email and delete all copies. -- AlienVault Unified Security Management (USM) platform delivers complete security visibility with the essential security capabilities. Easily and efficiently configure, manage, and operate all of your security controls from a single console and one unified framework. Download a free trial. http://p.sf.net/sfu/alienvault_d2d ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
Re: [WiX-users] Is is possible to change default database port?
On Mon, May 13, 2013 at 11:20 AM, John Cooper jocoo...@jackhenry.comwrote: You can pass the server/instance pair to the Server attribute. I've never tried this with SqlDatabase, but can you pass the server/instance,port? I would expect server,port to work as well. -- Edwin G. Castro -- AlienVault Unified Security Management (USM) platform delivers complete security visibility with the essential security capabilities. Easily and efficiently configure, manage, and operate all of your security controls from a single console and one unified framework. Download a free trial. http://p.sf.net/sfu/alienvault_d2d ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
Re: [WiX-users] Is it possible to change default database port?
Yes, server,port/instance or server,port would be correct. Got it out of sequence in my last post. -- John Merryweather Cooper Build Install Engineer - ESA Jack Henry Associates, Inc.® Shawnee Mission, KS 66227 Office: 913-341-3434 x791011 jocoo...@jackhenry.com www.jackhenry.com -Original Message- From: Edwin Castro [mailto:egca...@gmail.com] Sent: Monday, May 13, 2013 1:43 PM To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Is is possible to change default database port? On Mon, May 13, 2013 at 11:20 AM, John Cooper jocoo...@jackhenry.comwrote: You can pass the server/instance pair to the Server attribute. I've never tried this with SqlDatabase, but can you pass the server/instance,port? I would expect server,port to work as well. -- Edwin G. Castro -- AlienVault Unified Security Management (USM) platform delivers complete security visibility with the essential security capabilities. Easily and efficiently configure, manage, and operate all of your security controls from a single console and one unified framework. Download a free trial. http://p.sf.net/sfu/alienvault_d2d ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users NOTICE: This electronic mail message and any files transmitted with it are intended exclusively for the individual or entity to which it is addressed. The message, together with any attachment, may contain confidential and/or privileged information. Any unauthorized review, use, printing, saving, copying, disclosure or distribution is strictly prohibited. If you have received this message in error, please immediately advise the sender by reply email and delete all copies. -- AlienVault Unified Security Management (USM) platform delivers complete security visibility with the essential security capabilities. Easily and efficiently configure, manage, and operate all of your security controls from a single console and one unified framework. Download a free trial. http://p.sf.net/sfu/alienvault_d2d ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
Re: [WiX-users] Is is possible to change default database port?
1443 is not the instance database port it is the SQL browser port, I believe this is always the same. You can specify the instance port as part of the connection string (e.g. Data Source=(local)\INSTNAME12345 where 12345 is the port) but it is rarely required. Neil -Original Message- From: George Fleming [mailto:gef...@microsoft.com] Sent: 13 May 2013 18:16 To: WiX-users@lists.sourceforge.net Subject: [WiX-users] Is is possible to change default database port? Default SQL Database IP port is 1443. Is it possible to change this value? I don't see any port attribute in the SqlDatabase element of Wix. George -- Learn Graph Databases - Download FREE O'Reilly Book Graph Databases is the definitive new guide to graph databases and their applications. This 200-page book is written by three acclaimed leaders in the field. The early access version is available now. Download your free book today! http://p.sf.net/sfu/neotech_d2d_may ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users -- AlienVault Unified Security Management (USM) platform delivers complete security visibility with the essential security capabilities. Easily and efficiently configure, manage, and operate all of your security controls from a single console and one unified framework. Download a free trial. http://p.sf.net/sfu/alienvault_d2d ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
Re: [WiX-users] Is is possible to change default database port?
It is the standard practice for deployment to our farms. The Browse port is firewalled off and the service disabled. We deploy to FQDN server name, a non-standard port name, and one of two instance names. In operations, deployment where we can browse the instance or use the default port is the exception. -- John Merryweather Cooper Build Install Engineer - ESA Jack Henry Associates, Inc.® Shawnee Mission, KS 66227 Office: 913-341-3434 x791011 jocoo...@jackhenry.com www.jackhenry.com -Original Message- From: Neil Sleightholm [mailto:n...@x2systems.com] Sent: Monday, May 13, 2013 3:36 PM To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Is is possible to change default database port? 1443 is not the instance database port it is the SQL browser port, I believe this is always the same. You can specify the instance port as part of the connection string (e.g. Data Source=(local)\INSTNAME12345 where 12345 is the port) but it is rarely required. Neil -Original Message- From: George Fleming [mailto:gef...@microsoft.com] Sent: 13 May 2013 18:16 To: WiX-users@lists.sourceforge.net Subject: [WiX-users] Is is possible to change default database port? Default SQL Database IP port is 1443. Is it possible to change this value? I don't see any port attribute in the SqlDatabase element of Wix. George -- Learn Graph Databases - Download FREE O'Reilly Book Graph Databases is the definitive new guide to graph databases and their applications. This 200-page book is written by three acclaimed leaders in the field. The early access version is available now. Download your free book today! http://p.sf.net/sfu/neotech_d2d_may ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users -- AlienVault Unified Security Management (USM) platform delivers complete security visibility with the essential security capabilities. Easily and efficiently configure, manage, and operate all of your security controls from a single console and one unified framework. Download a free trial. http://p.sf.net/sfu/alienvault_d2d ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users NOTICE: This electronic mail message and any files transmitted with it are intended exclusively for the individual or entity to which it is addressed. The message, together with any attachment, may contain confidential and/or privileged information. Any unauthorized review, use, printing, saving, copying, disclosure or distribution is strictly prohibited. If you have received this message in error, please immediately advise the sender by reply email and delete all copies. -- AlienVault Unified Security Management (USM) platform delivers complete security visibility with the essential security capabilities. Easily and efficiently configure, manage, and operate all of your security controls from a single console and one unified framework. Download a free trial. http://p.sf.net/sfu/alienvault_d2d ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
Re: [WiX-users] Is it possible to change default database port?
Wix already has a separate instance attribute. So for Server attribute, specify server,port? -Original Message- From: John Cooper [mailto:jocoo...@jackhenry.com] Sent: Monday, May 13, 2013 1:33 PM To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Is it possible to change default database port? Yes, server,port/instance or server,port would be correct. Got it out of sequence in my last post. -- John Merryweather Cooper Build Install Engineer - ESA Jack Henry Associates, Inc.® Shawnee Mission, KS 66227 Office: 913-341-3434 x791011 jocoo...@jackhenry.com www.jackhenry.com -Original Message- From: Edwin Castro [mailto:egca...@gmail.com] Sent: Monday, May 13, 2013 1:43 PM To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Is is possible to change default database port? On Mon, May 13, 2013 at 11:20 AM, John Cooper jocoo...@jackhenry.comwrote: You can pass the server/instance pair to the Server attribute. I've never tried this with SqlDatabase, but can you pass the server/instance,port? I would expect server,port to work as well. -- Edwin G. Castro -- AlienVault Unified Security Management (USM) platform delivers complete security visibility with the essential security capabilities. Easily and efficiently configure, manage, and operate all of your security controls from a single console and one unified framework. Download a free trial. http://p.sf.net/sfu/alienvault_d2d ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users NOTICE: This electronic mail message and any files transmitted with it are intended exclusively for the individual or entity to which it is addressed. The message, together with any attachment, may contain confidential and/or privileged information. Any unauthorized review, use, printing, saving, copying, disclosure or distribution is strictly prohibited. If you have received this message in error, please immediately advise the sender by reply email and delete all copies. -- AlienVault Unified Security Management (USM) platform delivers complete security visibility with the essential security capabilities. Easily and efficiently configure, manage, and operate all of your security controls from a single console and one unified framework. Download a free trial. http://p.sf.net/sfu/alienvault_d2d ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users -- AlienVault Unified Security Management (USM) platform delivers complete security visibility with the essential security capabilities. Easily and efficiently configure, manage, and operate all of your security controls from a single console and one unified framework. Download a free trial. http://p.sf.net/sfu/alienvault_d2d ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users