Forum Replies Created

Viewing 15 posts - 76 through 90 (of 541 total)

  • RE: Maintenance Plans Failing

    Manual backups also fail. A crash dump is created. I stumbled across this thread http://www.sqlservercentral.com/Forums/Topic1588898-3411-2.aspx. My issue appears similar. I am running 2014 RTM (no CU). I have reviewed the...

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    February 9, 2015 at 9:20 am

    #1776405

  • RE: Trying to get started.

    You can download BIDS free:

    http://www.microsoft.com/en-us/download/details.aspx?id=42313

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    February 9, 2015 at 8:18 am

    #1776381

  • RE: The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.

    This is bugging me now! The certificate name matches the server name so why will only <Add Key="SecureConnectionLevel" Value="0"/> function?

    Report Server Web Service Site Identification: SSL Certificate = SQL-SERVER-NAME.

    IE displays...

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    January 14, 2015 at 5:06 am

    #1770067

  • RE: The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.

    I amended RSReportServer.config file.

    I have changed line:

    <Add Key="SecureConnectionLevel" Value="2"/>

    to

    <Add Key="SecureConnectionLevel" Value="0"/>

    I am now able to connect. I am not sure why SSL connection was failing as the cert referenced...

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    January 14, 2015 at 4:51 am

    #1770066

  • RE: Disk Alignment

    Thanks for the replies. It is a clean install.

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    January 14, 2015 at 12:59 am

    #1770025

  • RE: IF statement in WHERE

    Thanks Ed.

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    January 11, 2015 at 9:14 am

    #1769302

  • RE: IF statement in WHERE

    Hi Gail. I guess I am on the naughty step regards bad coding and a distinct lack of understanding:)

    University put me off of programming and aged me by 10 years,...

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    January 9, 2015 at 2:43 am

    #1768998

  • RE: IF statement in WHERE

    Hi Dwain, thanks for the link. I may need a lobotomy to implement 🙂

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    January 9, 2015 at 12:59 am

    #1768969

  • RE: IF statement in WHERE

    Hi Phil. The report does not pose much of a performance hit although I agree it is not the best way to write code (limited by ability in this instance...

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    January 8, 2015 at 6:13 am

    #1768755

  • RE: IF statement in WHERE

    It would appear I cannot have multiple selections for @status due to the expected Boolean expression.

    CASE WHEN @status = 'C' AND ecn.FinishingEffectivityDate >=@StartDate AND ecn.FinishingEffectivityDate<=@EndDate THEN 1

    WHEN @status != 'C'...

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    January 8, 2015 at 5:16 am

    #1768743

  • RE: IF statement in WHERE

    Hi. The IN was used as the parameter in the report accepts multiple values. Although not ideal regards performance it was a quick and dirty way to deliver the multi...

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    January 8, 2015 at 4:58 am

    #1768740

  • RE: IF statement in WHERE

    Thanks for your quick response.

    WHERE

    ecnt.EngineeringChangeNoteTypeId IN (@ECNType)

    AND ecn.SystemType IN (@Status)

    CASE WHEN @status = 'C' AND ecn.FinishingEffectivityDate >=@StartDate AND ecn.FinishingEffectivityDate<=@EndDate THEN 1

    WHEN @status != 'C' AND ecn.CreatedDate >=@StartDate...

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    January 8, 2015 at 3:36 am

    #1768724

  • RE: IIS Default Web Site - Reports + ReportServer missing

    I am CONFUSED! I am unclear how Web Service URL and Report Manger URL interact and how SSRS uses certificates.

    I managed to get past error "The underlying connection was closed:...

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    September 11, 2014 at 3:34 am

    #1744670

  • RE: IIS Default Web Site - Reports + ReportServer missing

    Thanks for the heads up on IIS, that explains that! As far as I am aware I am not using SSL or a certificate for SSRS? Reporting Services Configuration Manager...

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    September 10, 2014 at 4:47 am

    #1744382

  • RE: IIS Default Web Site - Reports + ReportServer missing

    Hi. Has anyone else come across error "The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel." when browsing the reporting manager URL?

    Thanks,

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    September 9, 2014 at 2:22 am

    #1744038

Viewing 15 posts - 76 through 90 (of 541 total)