No "From" field on the subscriptions page

We are starting to use data-driven subscriptions for multiple applications
and would like to change the From address for each subscription. There isn't
a "From" field on the "Delivery extension settings for Report Server Email"
page in the Data-driven subscriptions section of Reporting Manager. Let me
know if you've found a solution.
I don't get why the "From" field wasn't included in the interface;
especially, if it is walking across smtp.
--
Any and all contributions are greatly appreciated ...
Regards TJHello,
"Delivery extension settings" does not include "From" settings. This email
address is configured under
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\RSReportServer
You can find search "administrator@." to find the From settings under Report
Server Email settings.
Hope this helps.
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
--
| From: "TJ" <nospam@.nowhere.com>
| Subject: No "From" field on the subscriptions page
| Date: Thu, 14 Oct 2004 17:02:09 -0400
| Lines: 14
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
| Message-ID: <eZCBTEjsEHA.3412@.TK2MSFTNGP14.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: 38.116.25.196
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP14|||Thanks and yes I see the From setting, but that doesn't tell me how each
report can have its own From setting. Please advise.
We would like to configure the system to have .
Billing Reports should come from "BillingServer"
HR Reports should come from "HR"
Thanks again
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:xTtTmsosEHA.3644@.cpmsftngxa10.phx.gbl...
> Hello,
> "Delivery extension settings" does not include "From" settings. This email
> address is configured under
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportServer\RSReportServer
> You can find search "administrator@." to find the From settings under
Report
> Server Email settings.
> Hope this helps.
> Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> Get Secure! - www.microsoft.com/security
> --
> | From: "TJ" <nospam@.nowhere.com>
> | Subject: No "From" field on the subscriptions page
> | Date: Thu, 14 Oct 2004 17:02:09 -0400
> | Lines: 14
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
> | Message-ID: <eZCBTEjsEHA.3412@.TK2MSFTNGP14.phx.gbl>
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: 38.116.25.196
> | Path:
>
cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP14
> phx.gbl
> | Xref: cpmsftngxa10.phx.gbl
microsoft.public.sqlserver.reportingsvcs:32194
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | We are starting to use data-driven subscriptions for multiple
applications
> | and would like to change the From address for each subscription. There
> isn't
> | a "From" field on the "Delivery extension settings for Report Server
> Email"
> | page in the Data-driven subscriptions section of Reporting Manager. Let
me
> | know if you've found a solution.
> |
> | I don't get why the "From" field wasn't included in the interface;
> | especially, if it is walking across smtp.
> |
> | --
> | Any and all contributions are greatly appreciated ...
> | Regards TJ
> |
> |
> |
>|||Hello,
Thank you for your reply. Based on my research, Report server e-mail
delivery extension built in Reporting service does not support this feature
for now. You may need to develop customized e-mail delivery extension. I
have incuded the following articles for your reference:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/
rsp_prog_extend_deliver_66xy.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/
rsp_ref_soapapi_service_ak_1xfd.asp
http://msdn.microsoft.com/msdnmag/issues/04/08/SQLServerReportingServices/de
fault.aspx
Also, In addition, you are welcome to send suggestions for product
enhancements that you would like to see in
future versions of Microsoft products to us by submitting MS Wish at
MSWISH@.microsoft.com
Best Regards,
Peter Yang
MCSE2000, MCSA, MCDBA
Microsoft Partner Online Support
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.
| From: "TJ" <nospam@.nowhere.com>
| References: <eZCBTEjsEHA.3412@.TK2MSFTNGP14.phx.gbl>
<xTtTmsosEHA.3644@.cpmsftngxa10.phx.gbl>
| Subject: Re: No "From" field on the subscriptions page
| Date: Fri, 15 Oct 2004 10:54:31 -0400
| Lines: 75
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
| Message-ID: <uz7jebssEHA.2316@.TK2MSFTNGP12.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: 38.116.25.196
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12
phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:32262
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Thanks and yes I see the From setting, but that doesn't tell me how each
| report can have its own From setting. Please advise.
|
| We would like to configure the system to have .
| Billing Reports should come from "BillingServer"
| HR Reports should come from "HR"
|
| Thanks again
|
| "Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
| news:xTtTmsosEHA.3644@.cpmsftngxa10.phx.gbl...
| > Hello,
| >
| > "Delivery extension settings" does not include "From" settings. This
email
| > address is configured under
| >
| > C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
| > Services\ReportServer\RSReportServer
| >
| > You can find search "administrator@." to find the From settings under
| Report
| > Server Email settings.
| >
| > Hope this helps.
| >
| > Regards,
| >
| > Peter Yang
| > MCSE2000/2003, MCSA, MCDBA
| > Microsoft Online Partner Support
| >
| > Get Secure! - www.microsoft.com/security
| >
| > --
| > | From: "TJ" <nospam@.nowhere.com>
| > | Subject: No "From" field on the subscriptions page
| > | Date: Thu, 14 Oct 2004 17:02:09 -0400
| > | Lines: 14
| > | X-Priority: 3
| > | X-MSMail-Priority: Normal
| > | X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
| > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
| > | Message-ID: <eZCBTEjsEHA.3412@.TK2MSFTNGP14.phx.gbl>
| > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
| > | NNTP-Posting-Host: 38.116.25.196
| > | Path:
| >
|
cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP14
| > phx.gbl
| > | Xref: cpmsftngxa10.phx.gbl
| microsoft.public.sqlserver.reportingsvcs:32194
| > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
| > |
| > | We are starting to use data-driven subscriptions for multiple
| applications
| > | and would like to change the From address for each subscription. There
| > isn't
| > | a "From" field on the "Delivery extension settings for Report Server
| > Email"
| > | page in the Data-driven subscriptions section of Reporting Manager.
Let
| me
| > | know if you've found a solution.
| > |
| > | I don't get why the "From" field wasn't included in the interface;
| > | especially, if it is walking across smtp.
| > |
| > | --
| > | Any and all contributions are greatly appreciated ...
| > | Regards TJ
| > |
| > |
| > |
| >
|
|
||||Thanks for your help.
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:G7IjqsOtEHA.836@.cpmsftngxa06.phx.gbl...
> Hello,
> Thank you for your reply. Based on my research, Report server e-mail
> delivery extension built in Reporting service does not support this
feature
> for now. You may need to develop customized e-mail delivery extension. I
> have incuded the following articles for your reference:
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/
> rsp_prog_extend_deliver_66xy.asp
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/
> rsp_ref_soapapi_service_ak_1xfd.asp
>
http://msdn.microsoft.com/msdnmag/issues/04/08/SQLServerReportingServices/de
> fault.aspx
> Also, In addition, you are welcome to send suggestions for product
> enhancements that you would like to see in
> future versions of Microsoft products to us by submitting MS Wish at
> MSWISH@.microsoft.com
> Best Regards,
> Peter Yang
> MCSE2000, MCSA, MCDBA
> Microsoft Partner Online Support
> Get Secure! - www.microsoft.com/security
> =====================================================> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> --
> | From: "TJ" <nospam@.nowhere.com>
> | References: <eZCBTEjsEHA.3412@.TK2MSFTNGP14.phx.gbl>
> <xTtTmsosEHA.3644@.cpmsftngxa10.phx.gbl>
> | Subject: Re: No "From" field on the subscriptions page
> | Date: Fri, 15 Oct 2004 10:54:31 -0400
> | Lines: 75
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
> | Message-ID: <uz7jebssEHA.2316@.TK2MSFTNGP12.phx.gbl>
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: 38.116.25.196
> | Path:
>
cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12
> phx.gbl
> | Xref: cpmsftngxa10.phx.gbl
microsoft.public.sqlserver.reportingsvcs:32262
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | Thanks and yes I see the From setting, but that doesn't tell me how each
> | report can have its own From setting. Please advise.
> |
> | We would like to configure the system to have .
> | Billing Reports should come from "BillingServer"
> | HR Reports should come from "HR"
> |
> | Thanks again
> |
> | "Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
> | news:xTtTmsosEHA.3644@.cpmsftngxa10.phx.gbl...
> | > Hello,
> | >
> | > "Delivery extension settings" does not include "From" settings. This
> email
> | > address is configured under
> | >
> | > C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> | > Services\ReportServer\RSReportServer
> | >
> | > You can find search "administrator@." to find the From settings under
> | Report
> | > Server Email settings.
> | >
> | > Hope this helps.
> | >
> | > Regards,
> | >
> | > Peter Yang
> | > MCSE2000/2003, MCSA, MCDBA
> | > Microsoft Online Partner Support
> | >
> | > Get Secure! - www.microsoft.com/security
> | >
> | > --
> | > | From: "TJ" <nospam@.nowhere.com>
> | > | Subject: No "From" field on the subscriptions page
> | > | Date: Thu, 14 Oct 2004 17:02:09 -0400
> | > | Lines: 14
> | > | X-Priority: 3
> | > | X-MSMail-Priority: Normal
> | > | X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
> | > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
> | > | Message-ID: <eZCBTEjsEHA.3412@.TK2MSFTNGP14.phx.gbl>
> | > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | > | NNTP-Posting-Host: 38.116.25.196
> | > | Path:
> | >
> |
>
cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP14
> | > phx.gbl
> | > | Xref: cpmsftngxa10.phx.gbl
> | microsoft.public.sqlserver.reportingsvcs:32194
> | > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> | > |
> | > | We are starting to use data-driven subscriptions for multiple
> | applications
> | > | and would like to change the From address for each subscription.
There
> | > isn't
> | > | a "From" field on the "Delivery extension settings for Report Server
> | > Email"
> | > | page in the Data-driven subscriptions section of Reporting Manager.
> Let
> | me
> | > | know if you've found a solution.
> | > |
> | > | I don't get why the "From" field wasn't included in the interface;
> | > | especially, if it is walking across smtp.
> | > |
> | > | --
> | > | Any and all contributions are greatly appreciated ...
> | > | Regards TJ
> | > |
> | > |
> | > |
> | >
> |
> |
> |
>|||Welcome!
Best Regards,
Peter Yang
MCSE2000, MCSA, MCDBA
Microsoft Partner Online Support
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.
| From: "TJ" <nospam@.nowhere.com>
| References: <eZCBTEjsEHA.3412@.TK2MSFTNGP14.phx.gbl>
<xTtTmsosEHA.3644@.cpmsftngxa10.phx.gbl>
<uz7jebssEHA.2316@.TK2MSFTNGP12.phx.gbl>
<G7IjqsOtEHA.836@.cpmsftngxa06.phx.gbl>
| Subject: Re: No "From" field on the subscriptions page
| Date: Tue, 19 Oct 2004 17:44:41 -0400
| Lines: 153
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
| Message-ID: <OtQMYTitEHA.3604@.TK2MSFTNGP10.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: 38.116.25.196
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTFEED01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10
phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:32558
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Thanks for your help.
|
| "Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
| news:G7IjqsOtEHA.836@.cpmsftngxa06.phx.gbl...
| > Hello,
| >
| > Thank you for your reply. Based on my research, Report server e-mail
| > delivery extension built in Reporting service does not support this
| feature
| > for now. You may need to develop customized e-mail delivery extension.
I
| > have incuded the following articles for your reference:
| >
| >
|
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/
| > rsp_prog_extend_deliver_66xy.asp
| >
| >
|
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/
| > rsp_ref_soapapi_service_ak_1xfd.asp
| >
| >
|
http://msdn.microsoft.com/msdnmag/issues/04/08/SQLServerReportingServices/de
| > fault.aspx
| >
| > Also, In addition, you are welcome to send suggestions for product
| > enhancements that you would like to see in
| >
| > future versions of Microsoft products to us by submitting MS Wish at
| > MSWISH@.microsoft.com
| >
| > Best Regards,
| >
| > Peter Yang
| > MCSE2000, MCSA, MCDBA
| > Microsoft Partner Online Support
| >
| > Get Secure! - www.microsoft.com/security
| >
| > =====================================================| > When responding to posts, please "Reply to Group" via
| > your newsreader so that others may learn and benefit
| > from your issue.
| > =====================================================| > This posting is provided "AS IS" with no warranties, and confers no
| rights.
| >
| >
| > --
| > | From: "TJ" <nospam@.nowhere.com>
| > | References: <eZCBTEjsEHA.3412@.TK2MSFTNGP14.phx.gbl>
| > <xTtTmsosEHA.3644@.cpmsftngxa10.phx.gbl>
| > | Subject: Re: No "From" field on the subscriptions page
| > | Date: Fri, 15 Oct 2004 10:54:31 -0400
| > | Lines: 75
| > | X-Priority: 3
| > | X-MSMail-Priority: Normal
| > | X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
| > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
| > | Message-ID: <uz7jebssEHA.2316@.TK2MSFTNGP12.phx.gbl>
| > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
| > | NNTP-Posting-Host: 38.116.25.196
| > | Path:
| >
|
cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12
| > phx.gbl
| > | Xref: cpmsftngxa10.phx.gbl
| microsoft.public.sqlserver.reportingsvcs:32262
| > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
| > |
| > | Thanks and yes I see the From setting, but that doesn't tell me how
each
| > | report can have its own From setting. Please advise.
| > |
| > | We would like to configure the system to have .
| > | Billing Reports should come from "BillingServer"
| > | HR Reports should come from "HR"
| > |
| > | Thanks again
| > |
| > | "Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
| > | news:xTtTmsosEHA.3644@.cpmsftngxa10.phx.gbl...
| > | > Hello,
| > | >
| > | > "Delivery extension settings" does not include "From" settings. This
| > email
| > | > address is configured under
| > | >
| > | > C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
| > | > Services\ReportServer\RSReportServer
| > | >
| > | > You can find search "administrator@." to find the From settings under
| > | Report
| > | > Server Email settings.
| > | >
| > | > Hope this helps.
| > | >
| > | > Regards,
| > | >
| > | > Peter Yang
| > | > MCSE2000/2003, MCSA, MCDBA
| > | > Microsoft Online Partner Support
| > | >
| > | > Get Secure! - www.microsoft.com/security
| > | >
| > | > --
| > | > | From: "TJ" <nospam@.nowhere.com>
| > | > | Subject: No "From" field on the subscriptions page
| > | > | Date: Thu, 14 Oct 2004 17:02:09 -0400
| > | > | Lines: 14
| > | > | X-Priority: 3
| > | > | X-MSMail-Priority: Normal
| > | > | X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
| > | > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
| > | > | Message-ID: <eZCBTEjsEHA.3412@.TK2MSFTNGP14.phx.gbl>
| > | > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
| > | > | NNTP-Posting-Host: 38.116.25.196
| > | > | Path:
| > | >
| > |
| >
|
cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP14
| > | > phx.gbl
| > | > | Xref: cpmsftngxa10.phx.gbl
| > | microsoft.public.sqlserver.reportingsvcs:32194
| > | > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
| > | > |
| > | > | We are starting to use data-driven subscriptions for multiple
| > | applications
| > | > | and would like to change the From address for each subscription.
| There
| > | > isn't
| > | > | a "From" field on the "Delivery extension settings for Report
Server
| > | > Email"
| > | > | page in the Data-driven subscriptions section of Reporting
Manager.
| > Let
| > | me
| > | > | know if you've found a solution.
| > | > |
| > | > | I don't get why the "From" field wasn't included in the interface;
| > | > | especially, if it is walking across smtp.
| > | > |
| > | > | --
| > | > | Any and all contributions are greatly appreciated ...
| > | > | Regards TJ
| > | > |
| > | > |
| > | > |
| > | >
| > |
| > |
| > |
| >
|
|
|

NIC questions

Hi,
I have installed 2 NICs on a Server. One of them is
connected to company's network (IP Address is assigned by
company's DHCP Server). The other one is connected to a
private testing network and I plan to use that server as
AD in the testing LAN.
I would like to know
1) Is it necessary to consider the sequnce of binding of
the NICs ? Company LAN - Local Area Connection and
Private LAN - Local Area Connection 2. Does the sequence
significant ?
2) From my understanding, when we run ipconfig/all, the
first NIC shown is the primary NIC. How can we change the
sequence ?
Thanks
For SQL Server, the order is irrelevant. SQL binds to all valid addresses
that exist at service startup.
Change the binding order for your NICs to change the order they appear in
the IPCONFIG output.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:02f001c5ba90$ffdd7e50$a601280a@.phx.gbl...
> Hi,
> I have installed 2 NICs on a Server. One of them is
> connected to company's network (IP Address is assigned by
> company's DHCP Server). The other one is connected to a
> private testing network and I plan to use that server as
> AD in the testing LAN.
> I would like to know
> 1) Is it necessary to consider the sequnce of binding of
> the NICs ? Company LAN - Local Area Connection and
> Private LAN - Local Area Connection 2. Does the sequence
> significant ?
> 2) From my understanding, when we run ipconfig/all, the
> first NIC shown is the primary NIC. How can we change the
> sequence ?
> Thanks
>
|||Dear Geoff,
Thank you for your reply. I should have posted it to Windows Server
newsgroup.
However, how do I change the binding order for the NICs ?
Thanks
Peter
"Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
news:e4ZR9NquFHA.3316@.TK2MSFTNGP10.phx.gbl...
> For SQL Server, the order is irrelevant. SQL binds to all valid addresses
> that exist at service startup.
> Change the binding order for your NICs to change the order they appear in
> the IPCONFIG output.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
> "Peter" <anonymous@.discussions.microsoft.com> wrote in message
> news:02f001c5ba90$ffdd7e50$a601280a@.phx.gbl...
>
|||This may vary slightly by OS version.
On the Network Connections page, Select ADVANCED | Advanced Settings on the
menu. First page should be Adapters and Bindings. Change the order as you
need to.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Peter" <Peter@.discussions.microsoft.com> wrote in message
news:uhbAlqquFHA.3792@.TK2MSFTNGP10.phx.gbl...
> Dear Geoff,
> Thank you for your reply. I should have posted it to Windows Server
> newsgroup.
> However, how do I change the binding order for the NICs ?
> Thanks
> Peter
> "Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
> news:e4ZR9NquFHA.3316@.TK2MSFTNGP10.phx.gbl...
>

NIC questions

Hi,
I have installed 2 NICs on a Server. One of them is
connected to company's network (IP Address is assigned by
company's DHCP Server). The other one is connected to a
private testing network and I plan to use that server as
AD in the testing LAN.
I would like to know
1) Is it necessary to consider the sequnce of binding of
the NICs ? Company LAN - Local Area Connection and
Private LAN - Local Area Connection 2. Does the sequence
significant ?
2) From my understanding, when we run ipconfig/all, the
first NIC shown is the primary NIC. How can we change the
sequence ?
ThanksFor SQL Server, the order is irrelevant. SQL binds to all valid addresses
that exist at service startup.
Change the binding order for your NICs to change the order they appear in
the IPCONFIG output.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:02f001c5ba90$ffdd7e50$a601280a@.phx.gbl...
> Hi,
> I have installed 2 NICs on a Server. One of them is
> connected to company's network (IP Address is assigned by
> company's DHCP Server). The other one is connected to a
> private testing network and I plan to use that server as
> AD in the testing LAN.
> I would like to know
> 1) Is it necessary to consider the sequnce of binding of
> the NICs ? Company LAN - Local Area Connection and
> Private LAN - Local Area Connection 2. Does the sequence
> significant ?
> 2) From my understanding, when we run ipconfig/all, the
> first NIC shown is the primary NIC. How can we change the
> sequence ?
> Thanks
>|||Dear Geoff,
Thank you for your reply. I should have posted it to Windows Server
newsgroup.
However, how do I change the binding order for the NICs ?
Thanks
Peter
"Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
news:e4ZR9NquFHA.3316@.TK2MSFTNGP10.phx.gbl...
> For SQL Server, the order is irrelevant. SQL binds to all valid addresses
> that exist at service startup.
> Change the binding order for your NICs to change the order they appear in
> the IPCONFIG output.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
> "Peter" <anonymous@.discussions.microsoft.com> wrote in message
> news:02f001c5ba90$ffdd7e50$a601280a@.phx.gbl...
>|||This may vary slightly by OS version.
On the Network Connections page, Select ADVANCED | Advanced Settings on the
menu. First page should be Adapters and Bindings. Change the order as you
need to.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Peter" <Peter@.discussions.microsoft.com> wrote in message
news:uhbAlqquFHA.3792@.TK2MSFTNGP10.phx.gbl...
> Dear Geoff,
> Thank you for your reply. I should have posted it to Windows Server
> newsgroup.
> However, how do I change the binding order for the NICs ?
> Thanks
> Peter
> "Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
> news:e4ZR9NquFHA.3316@.TK2MSFTNGP10.phx.gbl...
>

NIC questions

Hi,
I have installed 2 NICs on a Server. One of them is
connected to company's network (IP Address is assigned by
company's DHCP Server). The other one is connected to a
private testing network and I plan to use that server as
AD in the testing LAN.
I would like to know
1) Is it necessary to consider the sequnce of binding of
the NICs ? Company LAN - Local Area Connection and
Private LAN - Local Area Connection 2. Does the sequence
significant ?
2) From my understanding, when we run ipconfig/all, the
first NIC shown is the primary NIC. How can we change the
sequence ?
ThanksFor SQL Server, the order is irrelevant. SQL binds to all valid addresses
that exist at service startup.
Change the binding order for your NICs to change the order they appear in
the IPCONFIG output.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:02f001c5ba90$ffdd7e50$a601280a@.phx.gbl...
> Hi,
> I have installed 2 NICs on a Server. One of them is
> connected to company's network (IP Address is assigned by
> company's DHCP Server). The other one is connected to a
> private testing network and I plan to use that server as
> AD in the testing LAN.
> I would like to know
> 1) Is it necessary to consider the sequnce of binding of
> the NICs ? Company LAN - Local Area Connection and
> Private LAN - Local Area Connection 2. Does the sequence
> significant ?
> 2) From my understanding, when we run ipconfig/all, the
> first NIC shown is the primary NIC. How can we change the
> sequence ?
> Thanks
>|||Dear Geoff,
Thank you for your reply. I should have posted it to Windows Server
newsgroup.
However, how do I change the binding order for the NICs ?
Thanks
Peter
"Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
news:e4ZR9NquFHA.3316@.TK2MSFTNGP10.phx.gbl...
> For SQL Server, the order is irrelevant. SQL binds to all valid addresses
> that exist at service startup.
> Change the binding order for your NICs to change the order they appear in
> the IPCONFIG output.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
> "Peter" <anonymous@.discussions.microsoft.com> wrote in message
> news:02f001c5ba90$ffdd7e50$a601280a@.phx.gbl...
>> Hi,
>> I have installed 2 NICs on a Server. One of them is
>> connected to company's network (IP Address is assigned by
>> company's DHCP Server). The other one is connected to a
>> private testing network and I plan to use that server as
>> AD in the testing LAN.
>> I would like to know
>> 1) Is it necessary to consider the sequnce of binding of
>> the NICs ? Company LAN - Local Area Connection and
>> Private LAN - Local Area Connection 2. Does the sequence
>> significant ?
>> 2) From my understanding, when we run ipconfig/all, the
>> first NIC shown is the primary NIC. How can we change the
>> sequence ?
>> Thanks
>|||This may vary slightly by OS version.
On the Network Connections page, Select ADVANCED | Advanced Settings on the
menu. First page should be Adapters and Bindings. Change the order as you
need to.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Peter" <Peter@.discussions.microsoft.com> wrote in message
news:uhbAlqquFHA.3792@.TK2MSFTNGP10.phx.gbl...
> Dear Geoff,
> Thank you for your reply. I should have posted it to Windows Server
> newsgroup.
> However, how do I change the binding order for the NICs ?
> Thanks
> Peter
> "Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
> news:e4ZR9NquFHA.3316@.TK2MSFTNGP10.phx.gbl...
>> For SQL Server, the order is irrelevant. SQL binds to all valid
>> addresses that exist at service startup.
>> Change the binding order for your NICs to change the order they appear in
>> the IPCONFIG output.
>> --
>> Geoff N. Hiten
>> Senior Database Administrator
>> Microsoft SQL Server MVP
>> "Peter" <anonymous@.discussions.microsoft.com> wrote in message
>> news:02f001c5ba90$ffdd7e50$a601280a@.phx.gbl...
>> Hi,
>> I have installed 2 NICs on a Server. One of them is
>> connected to company's network (IP Address is assigned by
>> company's DHCP Server). The other one is connected to a
>> private testing network and I plan to use that server as
>> AD in the testing LAN.
>> I would like to know
>> 1) Is it necessary to consider the sequnce of binding of
>> the NICs ? Company LAN - Local Area Connection and
>> Private LAN - Local Area Connection 2. Does the sequence
>> significant ?
>> 2) From my understanding, when we run ipconfig/all, the
>> first NIC shown is the primary NIC. How can we change the
>> sequence ?
>> Thanks
>>
>

Next IsNull help required

Hi,

I have written a simple formula to identify the last address in a sequence, in a multiple address report which is sorted in alphabetical order:

If next ({address}) <> {address} then 1 else 0

This works fine, however, the very last record in the report 'should' have a value of 1 but doesn't because obviously there is no Next record.

I have therefore tried adding the following line (and variations on the same theme!) but cannot achieve what I want.

If Next ({address}) <> {address} then 1 else
If Next IsNull ({address}) then 1 else 0

I presume this is not possible as there is no Next record. Can anyone suggest a way around this?

Thanks.OnLastRecord|||Thanks. My report now works. Apologies for being a numbskull!

Newspaper Columns

Does anyone know how to create Newspaper Columns in Reporting Services? I am
trying to create a company address and phone number directory.
Thanks for any help you can offer.In the Body section of the report, open your properties window. There is a
property under layout called columns. Set the number of columns here.
Then, if you want 2 3" columns w/ 1/2" between them, you would set your
report width to 6.5 and your body width to 3".
msflinx
"GR Pilot" wrote:
> Does anyone know how to create Newspaper Columns in Reporting Services? I am
> trying to create a company address and phone number directory.
> Thanks for any help you can offer.