once published, I Cannot display Reports

(sorry, previous posting went too fast - in the middle of editing)
on sql05, from vStudio05, I created a report, it shows fine in preview. and
was deployed successfully.
on //localhost/Reports it is listed as New,
and on //localhost/ReportServer a new <dir> is added to the list, and
inside is the report.
However, I cannot display the report from either page. the error is:
Logon failed. (rsLogonFailed)
Logon failure: unknown user name or bad password. (Exception from
HRESULT: 0x8007052E)
I am not sure if this failure is due to some wrong settings fo the Virtual
directories for (Reports and ReportManager) on the IIS server or for some
other reasons.
Thank you for your help.Check the credentials for the data source.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"newToSql" <noneone@.hotmail.com> wrote in message
news:ud4Gb4hgHHA.4552@.TK2MSFTNGP04.phx.gbl...
> (sorry, previous posting went too fast - in the middle of editing)
> on sql05, from vStudio05, I created a report, it shows fine in preview.
> and was deployed successfully.
> on //localhost/Reports it is listed as New,
> and on //localhost/ReportServer a new <dir> is added to the list, and
> inside is the report.
> However, I cannot display the report from either page. the error is:
> Logon failed. (rsLogonFailed)
> Logon failure: unknown user name or bad password. (Exception from
> HRESULT: 0x8007052E)
> I am not sure if this failure is due to some wrong settings fo the Virtual
> directories for (Reports and ReportManager) on the IIS server or for some
> other reasons.
> Thank you for your help.
>|||data source credential show Windows authentication, I tested the connection,
it works fine, and I am admin on the box (this is a simple case from the
tutorial pages and uses AdventureWorks)
?
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:OcSStOigHHA.4064@.TK2MSFTNGP03.phx.gbl...
> Check the credentials for the data source.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "newToSql" <noneone@.hotmail.com> wrote in message
> news:ud4Gb4hgHHA.4552@.TK2MSFTNGP04.phx.gbl...
>> (sorry, previous posting went too fast - in the middle of editing)
>> on sql05, from vStudio05, I created a report, it shows fine in preview.
>> and was deployed successfully.
>> on //localhost/Reports it is listed as New,
>> and on //localhost/ReportServer a new <dir> is added to the list, and
>> inside is the report.
>> However, I cannot display the report from either page. the error is:
>> Logon failed. (rsLogonFailed)
>> Logon failure: unknown user name or bad password. (Exception from
>> HRESULT: 0x8007052E)
>> I am not sure if this failure is due to some wrong settings fo the
>> Virtual directories for (Reports and ReportManager) on the IIS server or
>> for some other reasons.
>> Thank you for your help.
>>
>|||What OS are you on?
Also, make sure you do not have anonymous website via IIS.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"newToSql" <noneone@.hotmail.com> wrote in message
news:%23xqODligHHA.284@.TK2MSFTNGP05.phx.gbl...
> data source credential show Windows authentication, I tested the
> connection, it works fine, and I am admin on the box (this is a simple
> case from the tutorial pages and uses AdventureWorks)
> ?
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:OcSStOigHHA.4064@.TK2MSFTNGP03.phx.gbl...
>> Check the credentials for the data source.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "newToSql" <noneone@.hotmail.com> wrote in message
>> news:ud4Gb4hgHHA.4552@.TK2MSFTNGP04.phx.gbl...
>> (sorry, previous posting went too fast - in the middle of editing)
>> on sql05, from vStudio05, I created a report, it shows fine in preview.
>> and was deployed successfully.
>> on //localhost/Reports it is listed as New,
>> and on //localhost/ReportServer a new <dir> is added to the list, and
>> inside is the report.
>> However, I cannot display the report from either page. the error is:
>> Logon failed. (rsLogonFailed)
>> Logon failure: unknown user name or bad password. (Exception from
>> HRESULT: 0x8007052E)
>> I am not sure if this failure is due to some wrong settings fo the
>> Virtual directories for (Reports and ReportManager) on the IIS server or
>> for some other reasons.
>> Thank you for your help.
>>
>>
>|||Yes, Integrated Windows Authentication is selecteed on the web site
Directory security/Authentication Methods.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:uU3hJtigHHA.3852@.TK2MSFTNGP04.phx.gbl...
> What OS are you on?
> Also, make sure you do not have anonymous website via IIS.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "newToSql" <noneone@.hotmail.com> wrote in message
> news:%23xqODligHHA.284@.TK2MSFTNGP05.phx.gbl...
>> data source credential show Windows authentication, I tested the
>> connection, it works fine, and I am admin on the box (this is a simple
>> case from the tutorial pages and uses AdventureWorks)
>> ?
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:OcSStOigHHA.4064@.TK2MSFTNGP03.phx.gbl...
>> Check the credentials for the data source.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "newToSql" <noneone@.hotmail.com> wrote in message
>> news:ud4Gb4hgHHA.4552@.TK2MSFTNGP04.phx.gbl...
>> (sorry, previous posting went too fast - in the middle of editing)
>> on sql05, from vStudio05, I created a report, it shows fine in
>> preview. and was deployed successfully.
>> on //localhost/Reports it is listed as New,
>> and on //localhost/ReportServer a new <dir> is added to the list, and
>> inside is the report.
>> However, I cannot display the report from either page. the error is:
>> Logon failed. (rsLogonFailed)
>> Logon failure: unknown user name or bad password. (Exception from
>> HRESULT: 0x8007052E)
>> I am not sure if this failure is due to some wrong settings fo the
>> Virtual directories for (Reports and ReportManager) on the IIS server
>> or for some other reasons.
>> Thank you for your help.
>>
>>
>>
>|||What OS?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"newToSql" <noneone@.hotmail.com> wrote in message
news:eDtWYZqgHHA.4892@.TK2MSFTNGP03.phx.gbl...
> Yes, Integrated Windows Authentication is selecteed on the web site
> Directory security/Authentication Methods.
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:uU3hJtigHHA.3852@.TK2MSFTNGP04.phx.gbl...
>> What OS are you on?
>> Also, make sure you do not have anonymous website via IIS.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "newToSql" <noneone@.hotmail.com> wrote in message
>> news:%23xqODligHHA.284@.TK2MSFTNGP05.phx.gbl...
>> data source credential show Windows authentication, I tested the
>> connection, it works fine, and I am admin on the box (this is a simple
>> case from the tutorial pages and uses AdventureWorks)
>> ?
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:OcSStOigHHA.4064@.TK2MSFTNGP03.phx.gbl...
>> Check the credentials for the data source.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "newToSql" <noneone@.hotmail.com> wrote in message
>> news:ud4Gb4hgHHA.4552@.TK2MSFTNGP04.phx.gbl...
>> (sorry, previous posting went too fast - in the middle of editing)
>> on sql05, from vStudio05, I created a report, it shows fine in
>> preview. and was deployed successfully.
>> on //localhost/Reports it is listed as New,
>> and on //localhost/ReportServer a new <dir> is added to the list, and
>> inside is the report.
>> However, I cannot display the report from either page. the error is:
>> Logon failed. (rsLogonFailed)
>> Logon failure: unknown user name or bad password. (Exception
>> from HRESULT: 0x8007052E)
>> I am not sure if this failure is due to some wrong settings fo the
>> Virtual directories for (Reports and ReportManager) on the IIS server
>> or for some other reasons.
>> Thank you for your help.
>>
>>
>>
>>
>|||windows 2003 server with sp1.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:ul5qkpqgHHA.4892@.TK2MSFTNGP03.phx.gbl...
> What OS?
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "newToSql" <noneone@.hotmail.com> wrote in message
> news:eDtWYZqgHHA.4892@.TK2MSFTNGP03.phx.gbl...
>> Yes, Integrated Windows Authentication is selecteed on the web site
>> Directory security/Authentication Methods.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:uU3hJtigHHA.3852@.TK2MSFTNGP04.phx.gbl...
>> What OS are you on?
>> Also, make sure you do not have anonymous website via IIS.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "newToSql" <noneone@.hotmail.com> wrote in message
>> news:%23xqODligHHA.284@.TK2MSFTNGP05.phx.gbl...
>> data source credential show Windows authentication, I tested the
>> connection, it works fine, and I am admin on the box (this is a simple
>> case from the tutorial pages and uses AdventureWorks)
>> ?
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:OcSStOigHHA.4064@.TK2MSFTNGP03.phx.gbl...
>> Check the credentials for the data source.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "newToSql" <noneone@.hotmail.com> wrote in message
>> news:ud4Gb4hgHHA.4552@.TK2MSFTNGP04.phx.gbl...
>> (sorry, previous posting went too fast - in the middle of editing)
>> on sql05, from vStudio05, I created a report, it shows fine in
>> preview. and was deployed successfully.
>> on //localhost/Reports it is listed as New,
>> and on //localhost/ReportServer a new <dir> is added to the list,
>> and inside is the report.
>> However, I cannot display the report from either page. the error is:
>> Logon failed. (rsLogonFailed)
>> Logon failure: unknown user name or bad password. (Exception
>> from HRESULT: 0x8007052E)
>> I am not sure if this failure is due to some wrong settings fo the
>> Virtual directories for (Reports and ReportManager) on the IIS server
>> or for some other reasons.
>> Thank you for your help.
>>
>>
>>
>>
>>
>|||If you are trying to view this from the sever itself, Windows 2003 server
SP1 has enhanced security for IE. You have to add your own computer to the
safe sites list for IE.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"newToSql" <noneone@.hotmail.com> wrote in message
news:ucLEu%23qgHHA.1240@.TK2MSFTNGP04.phx.gbl...
> windows 2003 server with sp1.
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:ul5qkpqgHHA.4892@.TK2MSFTNGP03.phx.gbl...
>> What OS?
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "newToSql" <noneone@.hotmail.com> wrote in message
>> news:eDtWYZqgHHA.4892@.TK2MSFTNGP03.phx.gbl...
>> Yes, Integrated Windows Authentication is selecteed on the web site
>> Directory security/Authentication Methods.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:uU3hJtigHHA.3852@.TK2MSFTNGP04.phx.gbl...
>> What OS are you on?
>> Also, make sure you do not have anonymous website via IIS.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "newToSql" <noneone@.hotmail.com> wrote in message
>> news:%23xqODligHHA.284@.TK2MSFTNGP05.phx.gbl...
>> data source credential show Windows authentication, I tested the
>> connection, it works fine, and I am admin on the box (this is a simple
>> case from the tutorial pages and uses AdventureWorks)
>> ?
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:OcSStOigHHA.4064@.TK2MSFTNGP03.phx.gbl...
>> Check the credentials for the data source.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "newToSql" <noneone@.hotmail.com> wrote in message
>> news:ud4Gb4hgHHA.4552@.TK2MSFTNGP04.phx.gbl...
>>> (sorry, previous posting went too fast - in the middle of editing)
>>>
>>> on sql05, from vStudio05, I created a report, it shows fine in
>>> preview. and was deployed successfully.
>>> on //localhost/Reports it is listed as New,
>>> and on //localhost/ReportServer a new <dir> is added to the list,
>>> and inside is the report.
>>> However, I cannot display the report from either page. the error is:
>>> Logon failed. (rsLogonFailed)
>>> Logon failure: unknown user name or bad password. (Exception
>>> from HRESULT: 0x8007052E)
>>> I am not sure if this failure is due to some wrong settings fo the
>>> Virtual directories for (Reports and ReportManager) on the IIS
>>> server or for some other reasons.
>>> Thank you for your help.
>>>
>>>
>>
>>
>>
>>
>>
>|||just to be clear:
1 - after previewing the new report, I save it then deploy it: the report is
deployed and shows on the reort manager as a new report. the last step of
the deploy process Report Builder tries to open the new report in a new IE.
so in the new IE, the hourglass: generating the report shows and then I get
the error I mentioned:
a.. Logon failed.
a.. Logon failure: unknown user name or bad password. (Exception from
HRESULT: 0x8007052E)
2 - the same error happens if I try to open the report from the Report
Manager (on the IIS, right click on Reports then Browse, the report manager
opens, I try to open the report from there...
3 - I am not sure what you meant by adding my computer to the safe sites:
//Localhost is part of the Trusted Sites. do you mean something else?
thanks
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:OO2grHrgHHA.4952@.TK2MSFTNGP02.phx.gbl...
> If you are trying to view this from the sever itself, Windows 2003 server
> SP1 has enhanced security for IE. You have to add your own computer to the
> safe sites list for IE.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "newToSql" <noneone@.hotmail.com> wrote in message
> news:ucLEu%23qgHHA.1240@.TK2MSFTNGP04.phx.gbl...
>> windows 2003 server with sp1.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:ul5qkpqgHHA.4892@.TK2MSFTNGP03.phx.gbl...
>> What OS?
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "newToSql" <noneone@.hotmail.com> wrote in message
>> news:eDtWYZqgHHA.4892@.TK2MSFTNGP03.phx.gbl...
>> Yes, Integrated Windows Authentication is selecteed on the web site
>> Directory security/Authentication Methods.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:uU3hJtigHHA.3852@.TK2MSFTNGP04.phx.gbl...
>> What OS are you on?
>> Also, make sure you do not have anonymous website via IIS.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "newToSql" <noneone@.hotmail.com> wrote in message
>> news:%23xqODligHHA.284@.TK2MSFTNGP05.phx.gbl...
>> data source credential show Windows authentication, I tested the
>> connection, it works fine, and I am admin on the box (this is a
>> simple case from the tutorial pages and uses AdventureWorks)
>> ?
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:OcSStOigHHA.4064@.TK2MSFTNGP03.phx.gbl...
>>> Check the credentials for the data source.
>>>
>>>
>>> --
>>> Bruce Loehle-Conger
>>> MVP SQL Server Reporting Services
>>>
>>> "newToSql" <noneone@.hotmail.com> wrote in message
>>> news:ud4Gb4hgHHA.4552@.TK2MSFTNGP04.phx.gbl...
>>> (sorry, previous posting went too fast - in the middle of editing)
>>>
>>> on sql05, from vStudio05, I created a report, it shows fine in
>>> preview. and was deployed successfully.
>>> on //localhost/Reports it is listed as New,
>>> and on //localhost/ReportServer a new <dir> is added to the list,
>>> and inside is the report.
>>> However, I cannot display the report from either page. the error
>>> is:
>>> Logon failed. (rsLogonFailed)
>>> Logon failure: unknown user name or bad password. (Exception
>>> from HRESULT: 0x8007052E)
>>> I am not sure if this failure is due to some wrong settings fo the
>>> Virtual directories for (Reports and ReportManager) on the IIS
>>> server or for some other reasons.
>>> Thank you for your help.
>>>
>>>
>>>
>>>
>>
>>
>>
>>
>>
>|||Yeah, you need to add the computer name to trusted sites. Give it a try.
I do not use Report Builder but I do know that with Report Manager there are
times where the name of the server is put in. I don't think you can count on
localhost always being a part of the path, the computer name might be in
there instead, which means that you could get caught up in the enhanced
security.
Anyway, it is worth a try.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"newToSql" <noneone@.hotmail.com> wrote in message
news:Oys0ZrrgHHA.3472@.TK2MSFTNGP04.phx.gbl...
> just to be clear:
> 1 - after previewing the new report, I save it then deploy it: the report
> is deployed and shows on the reort manager as a new report. the last step
> of the deploy process Report Builder tries to open the new report in a new
> IE. so in the new IE, the hourglass: generating the report shows and then
> I get the error I mentioned:
> a.. Logon failed.
> a.. Logon failure: unknown user name or bad password. (Exception from
> HRESULT: 0x8007052E)
> 2 - the same error happens if I try to open the report from the Report
> Manager (on the IIS, right click on Reports then Browse, the report
> manager opens, I try to open the report from there...
> 3 - I am not sure what you meant by adding my computer to the safe sites:
> //Localhost is part of the Trusted Sites. do you mean something else?
> thanks
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:OO2grHrgHHA.4952@.TK2MSFTNGP02.phx.gbl...
>> If you are trying to view this from the sever itself, Windows 2003 server
>> SP1 has enhanced security for IE. You have to add your own computer to
>> the safe sites list for IE.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "newToSql" <noneone@.hotmail.com> wrote in message
>> news:ucLEu%23qgHHA.1240@.TK2MSFTNGP04.phx.gbl...
>> windows 2003 server with sp1.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:ul5qkpqgHHA.4892@.TK2MSFTNGP03.phx.gbl...
>> What OS?
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "newToSql" <noneone@.hotmail.com> wrote in message
>> news:eDtWYZqgHHA.4892@.TK2MSFTNGP03.phx.gbl...
>> Yes, Integrated Windows Authentication is selecteed on the web site
>> Directory security/Authentication Methods.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:uU3hJtigHHA.3852@.TK2MSFTNGP04.phx.gbl...
>> What OS are you on?
>> Also, make sure you do not have anonymous website via IIS.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "newToSql" <noneone@.hotmail.com> wrote in message
>> news:%23xqODligHHA.284@.TK2MSFTNGP05.phx.gbl...
>>> data source credential show Windows authentication, I tested the
>>> connection, it works fine, and I am admin on the box (this is a
>>> simple case from the tutorial pages and uses AdventureWorks)
>>> ?
>>>
>>>
>>>
>>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>>> news:OcSStOigHHA.4064@.TK2MSFTNGP03.phx.gbl...
>>> Check the credentials for the data source.
>>>
>>>
>>> --
>>> Bruce Loehle-Conger
>>> MVP SQL Server Reporting Services
>>>
>>> "newToSql" <noneone@.hotmail.com> wrote in message
>>> news:ud4Gb4hgHHA.4552@.TK2MSFTNGP04.phx.gbl...
>>> (sorry, previous posting went too fast - in the middle of editing)
>>>
>>> on sql05, from vStudio05, I created a report, it shows fine in
>>> preview. and was deployed successfully.
>>> on //localhost/Reports it is listed as New,
>>> and on //localhost/ReportServer a new <dir> is added to the list,
>>> and inside is the report.
>>> However, I cannot display the report from either page. the error
>>> is:
>>> Logon failed. (rsLogonFailed)
>>> Logon failure: unknown user name or bad password. (Exception
>>> from HRESULT: 0x8007052E)
>>> I am not sure if this failure is due to some wrong settings fo the
>>> Virtual directories for (Reports and ReportManager) on the IIS
>>> server or for some other reasons.
>>> Thank you for your help.
>>>
>>>
>>>
>>>
>>>
>>>
>>
>>
>>
>>
>>
>|||I added http://computerName to the trusted sites.
still, it tries to generate the report and fails with the same error.
strange!
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:eR40H9rgHHA.3412@.TK2MSFTNGP02.phx.gbl...
> Yeah, you need to add the computer name to trusted sites. Give it a try.
> I do not use Report Builder but I do know that with Report Manager there
> are times where the name of the server is put in. I don't think you can
> count on localhost always being a part of the path, the computer name
> might be in there instead, which means that you could get caught up in the
> enhanced security.
> Anyway, it is worth a try.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "newToSql" <noneone@.hotmail.com> wrote in message
> news:Oys0ZrrgHHA.3472@.TK2MSFTNGP04.phx.gbl...
>> just to be clear:
>> 1 - after previewing the new report, I save it then deploy it: the report
>> is deployed and shows on the reort manager as a new report. the last step
>> of the deploy process Report Builder tries to open the new report in a
>> new IE. so in the new IE, the hourglass: generating the report shows and
>> then I get the error I mentioned:
>> a.. Logon failed.
>> a.. Logon failure: unknown user name or bad password. (Exception from
>> HRESULT: 0x8007052E)
>> 2 - the same error happens if I try to open the report from the Report
>> Manager (on the IIS, right click on Reports then Browse, the report
>> manager opens, I try to open the report from there...
>> 3 - I am not sure what you meant by adding my computer to the safe sites:
>> //Localhost is part of the Trusted Sites. do you mean something else?
>> thanks
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:OO2grHrgHHA.4952@.TK2MSFTNGP02.phx.gbl...
>> If you are trying to view this from the sever itself, Windows 2003
>> server SP1 has enhanced security for IE. You have to add your own
>> computer to the safe sites list for IE.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "newToSql" <noneone@.hotmail.com> wrote in message
>> news:ucLEu%23qgHHA.1240@.TK2MSFTNGP04.phx.gbl...
>> windows 2003 server with sp1.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:ul5qkpqgHHA.4892@.TK2MSFTNGP03.phx.gbl...
>> What OS?
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "newToSql" <noneone@.hotmail.com> wrote in message
>> news:eDtWYZqgHHA.4892@.TK2MSFTNGP03.phx.gbl...
>> Yes, Integrated Windows Authentication is selecteed on the web site
>> Directory security/Authentication Methods.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:uU3hJtigHHA.3852@.TK2MSFTNGP04.phx.gbl...
>>> What OS are you on?
>>>
>>> Also, make sure you do not have anonymous website via IIS.
>>>
>>>
>>> --
>>> Bruce Loehle-Conger
>>> MVP SQL Server Reporting Services
>>>
>>>
>>> "newToSql" <noneone@.hotmail.com> wrote in message
>>> news:%23xqODligHHA.284@.TK2MSFTNGP05.phx.gbl...
>>> data source credential show Windows authentication, I tested the
>>> connection, it works fine, and I am admin on the box (this is a
>>> simple case from the tutorial pages and uses AdventureWorks)
>>> ?
>>>
>>>
>>>
>>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>>> news:OcSStOigHHA.4064@.TK2MSFTNGP03.phx.gbl...
>>> Check the credentials for the data source.
>>>
>>>
>>> --
>>> Bruce Loehle-Conger
>>> MVP SQL Server Reporting Services
>>>
>>> "newToSql" <noneone@.hotmail.com> wrote in message
>>> news:ud4Gb4hgHHA.4552@.TK2MSFTNGP04.phx.gbl...
>>>> (sorry, previous posting went too fast - in the middle of
>>>> editing)
>>>>
>>>> on sql05, from vStudio05, I created a report, it shows fine in
>>>> preview. and was deployed successfully.
>>>> on //localhost/Reports it is listed as New,
>>>> and on //localhost/ReportServer a new <dir> is added to the
>>>> list, and inside is the report.
>>>> However, I cannot display the report from either page. the error
>>>> is:
>>>> Logon failed. (rsLogonFailed)
>>>> Logon failure: unknown user name or bad password.
>>>> (Exception from HRESULT: 0x8007052E)
>>>> I am not sure if this failure is due to some wrong settings fo
>>>> the Virtual directories for (Reports and ReportManager) on the
>>>> IIS server or for some other reasons.
>>>> Thank you for your help.
>>>>
>>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>
>>
>>
>>
>>
>|||Do you have another computer you can try this from, i.e. connect across the
network to it?
Also, is your IP address fixed or dynamic? I had a problem once because I
did not have a fixed IP address.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"newToSql" <noneone@.hotmail.com> wrote in message
news:%236qMXmvgHHA.2368@.TK2MSFTNGP04.phx.gbl...
>I added http://computerName to the trusted sites.
> still, it tries to generate the report and fails with the same error.
> strange!
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:eR40H9rgHHA.3412@.TK2MSFTNGP02.phx.gbl...
>> Yeah, you need to add the computer name to trusted sites. Give it a try.
>> I do not use Report Builder but I do know that with Report Manager there
>> are times where the name of the server is put in. I don't think you can
>> count on localhost always being a part of the path, the computer name
>> might be in there instead, which means that you could get caught up in
>> the enhanced security.
>> Anyway, it is worth a try.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "newToSql" <noneone@.hotmail.com> wrote in message
>> news:Oys0ZrrgHHA.3472@.TK2MSFTNGP04.phx.gbl...
>> just to be clear:
>> 1 - after previewing the new report, I save it then deploy it: the
>> report is deployed and shows on the reort manager as a new report. the
>> last step of the deploy process Report Builder tries to open the new
>> report in a new IE. so in the new IE, the hourglass: generating the
>> report shows and then I get the error I mentioned:
>> a.. Logon failed.
>> a.. Logon failure: unknown user name or bad password. (Exception from
>> HRESULT: 0x8007052E)
>> 2 - the same error happens if I try to open the report from the Report
>> Manager (on the IIS, right click on Reports then Browse, the report
>> manager opens, I try to open the report from there...
>> 3 - I am not sure what you meant by adding my computer to the safe
>> sites: //Localhost is part of the Trusted Sites. do you mean something
>> else?
>> thanks
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:OO2grHrgHHA.4952@.TK2MSFTNGP02.phx.gbl...
>> If you are trying to view this from the sever itself, Windows 2003
>> server SP1 has enhanced security for IE. You have to add your own
>> computer to the safe sites list for IE.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "newToSql" <noneone@.hotmail.com> wrote in message
>> news:ucLEu%23qgHHA.1240@.TK2MSFTNGP04.phx.gbl...
>> windows 2003 server with sp1.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:ul5qkpqgHHA.4892@.TK2MSFTNGP03.phx.gbl...
>> What OS?
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "newToSql" <noneone@.hotmail.com> wrote in message
>> news:eDtWYZqgHHA.4892@.TK2MSFTNGP03.phx.gbl...
>>> Yes, Integrated Windows Authentication is selecteed on the web site
>>> Directory security/Authentication Methods.
>>>
>>>
>>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>>> news:uU3hJtigHHA.3852@.TK2MSFTNGP04.phx.gbl...
>>> What OS are you on?
>>>
>>> Also, make sure you do not have anonymous website via IIS.
>>>
>>>
>>> --
>>> Bruce Loehle-Conger
>>> MVP SQL Server Reporting Services
>>>
>>>
>>> "newToSql" <noneone@.hotmail.com> wrote in message
>>> news:%23xqODligHHA.284@.TK2MSFTNGP05.phx.gbl...
>>> data source credential show Windows authentication, I tested the
>>> connection, it works fine, and I am admin on the box (this is a
>>> simple case from the tutorial pages and uses AdventureWorks)
>>> ?
>>>
>>>
>>>
>>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>>> news:OcSStOigHHA.4064@.TK2MSFTNGP03.phx.gbl...
>>>> Check the credentials for the data source.
>>>>
>>>>
>>>> --
>>>> Bruce Loehle-Conger
>>>> MVP SQL Server Reporting Services
>>>>
>>>> "newToSql" <noneone@.hotmail.com> wrote in message
>>>> news:ud4Gb4hgHHA.4552@.TK2MSFTNGP04.phx.gbl...
>>>> (sorry, previous posting went too fast - in the middle of
>>>> editing)
>>>>
>>>> on sql05, from vStudio05, I created a report, it shows fine in
>>>> preview. and was deployed successfully.
>>>> on //localhost/Reports it is listed as New,
>>>> and on //localhost/ReportServer a new <dir> is added to the
>>>> list, and inside is the report.
>>>> However, I cannot display the report from either page. the error
>>>> is:
>>>> Logon failed. (rsLogonFailed)
>>>> Logon failure: unknown user name or bad password.
>>>> (Exception from HRESULT: 0x8007052E)
>>>> I am not sure if this failure is due to some wrong settings fo
>>>> the Virtual directories for (Reports and ReportManager) on the
>>>> IIS server or for some other reasons.
>>>> Thank you for your help.
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>
>>
>>
>>
>>
>

Old data from mdf deleting problem again!

Hello Guys!

Thanks for your previous posts to me, but I'm still in trouble.
I have card.mdf file and I need to delete data older than 3
months from the table called Events.
I tried the following:

use card.mdf
delete from Events where datediff(m,Field Time,getdate()) >= 3

"Field date" is the name of the colums where dates are logged.
But in query analyser it says that there is an error near "Time"
What am I doing wrong.

Please help me,
JessicaI suspect that your problem is caused because of the space in the "Field Time" column name. I think you will need to put quotes around this column and try again.|||Originally posted by dbabren
I suspect that your problem is caused because of the space in the "Field Time" column name. I think you will need to put quotes around this column and try again.

Sorry, I meant square brackets (doh!)

ie
delete from Events where datediff(m,[Field Time],getdate()) >= 3|||Thanks a lot dbabren, It now worked.
But do you know How I could run this
from dos command line?

Jessica|||Jessica

I assume that you mean it works via osql. I don't know is the short answer! I can only assume that the Syntax checker is not as strict in osql as it is in Query Analyser.|||Try this

use card.mdf
delete from Events where datediff(m,[Field Time],getdate()) >= 3

add [ ] around your column name.