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.
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>
>>
>>
>>
>>
>

once published, I Cannot display Reports

Hi,
on sql05, from vStudio05, I created a report, it shows fine in prevew. I
deployed successfully.
on //localhost/Reports it is listed as New,
and //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:
a.. Logon failed. (rsLogonFailed)
a.. Logon failure: unknown user name or bad password. (Exception from
HRESULT: 0x8007052E)
: from , it is listed as New on ReportManager. it is also listed on
Reportsbut when I try to view it from ReportThe authentication is used at two places.
1. To access the report
2. To access the source database.
So Just check the username and password, properly, as per the error it seems
the username/password is wrong.
Amarnath
"newToSql" wrote:
> Hi,
> on sql05, from vStudio05, I created a report, it shows fine in prevew. I
> deployed successfully.
> on //localhost/Reports it is listed as New,
> and //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:
> a.. Logon failed. (rsLogonFailed)
> a.. Logon failure: unknown user name or bad password. (Exception from
> HRESULT: 0x8007052E)
> : from , it is listed as New on ReportManager. it is also listed on
> Reportsbut when I try to view it from Report
>
>|||Hi Amarnath,
I am admin on the box (windows 2003 server, dynamicly assigned Ip, sys admin
on the sql server 2005...
I added my domain alias as well as my computer alias as sys admin on sql.
I can deploy reports successfully. on the Reporting Server
http://localhost/Reports$Sql2005InstanceA/ I can admin the reports, I gave
builtin\admin, my domain alias, and my localcomputer alias all permissions:
Browser, Content Manager, etc... on Home (these permissions show also at the
level of hte reports themselves)
still whe I click to view the report, I get the hour glass "Report is being
generated" then the error message
a.. Logon failed.
a.. Logon failure: unknown user name or bad password. (Exception from
HRESULT: 0x8007052E) b.. c..
"Amarnath" <Amarnath@.discussions.microsoft.com> wrote in message
news:CBE97795-DF0D-4E62-BDA6-EEEFEA01F19B@.microsoft.com...
> The authentication is used at two places.
> 1. To access the report
> 2. To access the source database.
> So Just check the username and password, properly, as per the error it
> seems
> the username/password is wrong.
> Amarnath
> "newToSql" wrote:
>> Hi,
>> on sql05, from vStudio05, I created a report, it shows fine in prevew. I
>> deployed successfully.
>> on //localhost/Reports it is listed as New,
>> and //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:
>> a.. Logon failed. (rsLogonFailed)
>> a.. Logon failure: unknown user name or bad password. (Exception from
>> HRESULT: 0x8007052E)
>> : from , it is listed as New on ReportManager. it is also listed on
>> Reportsbut when I try to view it from Report
>>|||I found the culprit - first me ! then:
when using the configuration tool to configure the report server: the
Execution Account name was misspelled:
to set the execution account, you have to provide a login name, a passord
and verify the password. This would suggest that the configuration tool
immediately checks the validity of this account, but the configuration tool
does does not check.
Again, thank you and Bruce L for your help.
"newToSql" <noneone@.hotmail.com> wrote in message
news:emQTDOshHHA.4680@.TK2MSFTNGP06.phx.gbl...
> Hi Amarnath,
> I am admin on the box (windows 2003 server, dynamicly assigned Ip, sys
> admin on the sql server 2005...
> I added my domain alias as well as my computer alias as sys admin on sql.
> I can deploy reports successfully. on the Reporting Server
> http://localhost/Reports$Sql2005InstanceA/ I can admin the reports, I gave
> builtin\admin, my domain alias, and my localcomputer alias all
> permissions: Browser, Content Manager, etc... on Home (these permissions
> show also at the level of hte reports themselves)
> still whe I click to view the report, I get the hour glass "Report is
> being generated" then the error message
> a.. Logon failed.
> a.. Logon failure: unknown user name or bad password. (Exception from
> HRESULT: 0x8007052E) b.. c..
> "Amarnath" <Amarnath@.discussions.microsoft.com> wrote in message
> news:CBE97795-DF0D-4E62-BDA6-EEEFEA01F19B@.microsoft.com...
>> The authentication is used at two places.
>> 1. To access the report
>> 2. To access the source database.
>> So Just check the username and password, properly, as per the error it
>> seems
>> the username/password is wrong.
>> Amarnath
>> "newToSql" wrote:
>> Hi,
>> on sql05, from vStudio05, I created a report, it shows fine in prevew.
>> I
>> deployed successfully.
>> on //localhost/Reports it is listed as New,
>> and //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:
>> a.. Logon failed. (rsLogonFailed)
>> a.. Logon failure: unknown user name or bad password. (Exception
>> from
>> HRESULT: 0x8007052E)
>> : from , it is listed as New on ReportManager. it is also listed on
>> Reportsbut when I try to view it from Report
>>
>|||I have had a problem when my server had a dynamically assigned IP. Can you
give it a static address?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"newToSql" <noneone@.hotmail.com> wrote in message
news:emQTDOshHHA.4680@.TK2MSFTNGP06.phx.gbl...
> Hi Amarnath,
> I am admin on the box (windows 2003 server, dynamicly assigned Ip, sys
> admin on the sql server 2005...
> I added my domain alias as well as my computer alias as sys admin on sql.
> I can deploy reports successfully. on the Reporting Server
> http://localhost/Reports$Sql2005InstanceA/ I can admin the reports, I gave
> builtin\admin, my domain alias, and my localcomputer alias all
> permissions: Browser, Content Manager, etc... on Home (these permissions
> show also at the level of hte reports themselves)
> still whe I click to view the report, I get the hour glass "Report is
> being generated" then the error message
> a.. Logon failed.
> a.. Logon failure: unknown user name or bad password. (Exception from
> HRESULT: 0x8007052E) b.. c..
> "Amarnath" <Amarnath@.discussions.microsoft.com> wrote in message
> news:CBE97795-DF0D-4E62-BDA6-EEEFEA01F19B@.microsoft.com...
>> The authentication is used at two places.
>> 1. To access the report
>> 2. To access the source database.
>> So Just check the username and password, properly, as per the error it
>> seems
>> the username/password is wrong.
>> Amarnath
>> "newToSql" wrote:
>> Hi,
>> on sql05, from vStudio05, I created a report, it shows fine in prevew.
>> I
>> deployed successfully.
>> on //localhost/Reports it is listed as New,
>> and //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:
>> a.. Logon failed. (rsLogonFailed)
>> a.. Logon failure: unknown user name or bad password. (Exception
>> from
>> HRESULT: 0x8007052E)
>> : from , it is listed as New on ReportManager. it is also listed on
>> Reportsbut when I try to view it from Report
>>
>

On Failure WorkFlow not getting Exectuted

i created a DTS package in SQL 2000 using the enterprise manager.

I have defined a SQL task to drop some temporary tables on failure of another SQL task. Also the same temporary tables need to be dropped on success of another task. the on success workflow is working fine. but when i add the on failure workflow to the temporary table dropping task, the temp table droppin is not getting excuted at all either for success nor for the failure. please help me out.

So multiple conditions are pointed to the same failure "workflow"?

If so, change the Multiple constraints option on one of the precedence constraints from the default of "Logical AND" (all constraints must evaluluate to true) to "Logical OR" (only one constraint must evaluate to true).|||Logical OR is great feature in SSIS, but I think the question is about DTS 2000, which did not have this option. In DTS 2000 you need to duplicate error-handling tasks. Or move to SSIS :)|||It worked when i duplicated the error-handling tasks..

OLEDB versus ODBC

HI,

I'm using a reporting tool for retrieving information from a sqlsrv 2005 env. using OLE DB for my connection.
When i've created a metric and whilst refreshing it i get the message 'object was open'. Changing the connection into ODBC everything went well.

By looking at the log file it's trying to write the metric record in the DB but it simply cannot (OLEDB) but using ODBC is all went fine...

Is something not properly installed on the server side?

anyone?

E10

Are you using a 3rd-party reporting tools? It looks like they do not use OleDb in a proper way. Better check with the reporting tools' vendor.

OLEDB provider error.

Hi:

I have created a cube and deployed in sql server. I am trying to connect to analysis services to access cube with linked server. I am getting this error...how do i fix this.?

OLE DB provider "MSOLAP" for linked server "(null)" returned message "Errors in the OLE DB provider. The Extended Properties property is set to a value that is not supported.".

Msg 7373, Level 16, State 2, Line 1

Cannot set the initialization properties for OLE DB provider "MSOLAP" for linked server "(null)".

Thanks,

Pramod

What's your Extended Properties? Please check whether there is any typo.|||

Xinwei:

Extended properties for my database is null...

Thanks,

Pramod

|||

Just leave it blank like this: Extended Properties="".
What's your whole connection string?
Thanks.

|||

Xinwei:

This is the query i am using...

SELECT a.* FROM OPENROWSET( 'MSOLAP','DATASOURCE=PKUMAR\PKUMAR;

Initial Catalog=Analysis Services Project1;', 'SELECT Measures.members ON ROWS,

[Product Category].members ON COLUMNS FROM [Adventure Works Internet Sales]') as a

go

Thanks,

|||The problem is on the Extended Properities as the error msg stated. If you have nothing to specify, please try delete it.|||Yep...it didnt help|||I am moving this to the SQL Server Analysis Services Forum.

OleDB open connection fails for user DSN

Platform: VC 7.0, Windows 2000
Database: SQL Server 2000
Hi,
I created an API, in-proc server, which uses OLEDB to open connection for a
given DSN.
When I create system dsn and execute API from SQL Server Store procedure it
success.
When I create user dsn and execute API from SQL Server Store procedure it
fails and returns error "Data source name not fond and no default driver
specified".
May I know reason for failing API for user DSN? Is there any solution.
Thanks in advance.
Regards
VijayA user DSN is specific to the user logged in... For this to work you must
create a user DSN for the same user that SQL is using ( since you are doing
this in a sp)... Most people would create a System DSN and not even worry
about it though.
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"vijay" <vijaysingh@.abo.abosoftware.com> wrote in message
news:u9puL320DHA.4064@.tk2msftngp13.phx.gbl...
> Platform: VC 7.0, Windows 2000
> Database: SQL Server 2000
>
> Hi,
> I created an API, in-proc server, which uses OLEDB to open connection for
a
> given DSN.
>
> When I create system dsn and execute API from SQL Server Store procedure
it
> success.
>
> When I create user dsn and execute API from SQL Server Store procedure it
> fails and returns error "Data source name not fond and no default driver
> specified".
>
> May I know reason for failing API for user DSN? Is there any solution.
>
> Thanks in advance.
>
> Regards
> Vijay
>
>|||How could I decide which DSN should be crated i.e. either system dsn or user
dsn.
Vijay
Sr. Software Engineer
ABO Software
New Delhi
"Wayne Snyder" <wsnyder@.computeredservices.com> wrote in message
news:eS7jFH40DHA.2396@.TK2MSFTNGP09.phx.gbl...
> A user DSN is specific to the user logged in... For this to work you must
> create a user DSN for the same user that SQL is using ( since you are
doing
> this in a sp)... Most people would create a System DSN and not even worry
> about it though.
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Computer Education Services Corporation (CESC), Charlotte, NC
> www.computeredservices.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
>
> "vijay" <vijaysingh@.abo.abosoftware.com> wrote in message
> news:u9puL320DHA.4064@.tk2msftngp13.phx.gbl...
> > Platform: VC 7.0, Windows 2000
> >
> > Database: SQL Server 2000
> >
> >
> >
> > Hi,
> >
> > I created an API, in-proc server, which uses OLEDB to open connection
for
> a
> > given DSN.
> >
> >
> >
> > When I create system dsn and execute API from SQL Server Store procedure
> it
> > success.
> >
> >
> >
> > When I create user dsn and execute API from SQL Server Store procedure
it
> > fails and returns error "Data source name not fond and no default driver
> > specified".
> >
> >
> >
> > May I know reason for failing API for user DSN? Is there any solution.
> >
> >
> >
> > Thanks in advance.
> >
> >
> >
> > Regards
> >
> > Vijay
> >
> >
> >
> >
>

OLEDB Error when using Visual FoxPro Driver

Hi all,

I created a package that extracts records from a .DBF file into an SQL Server database. I installed a Visual FoxPro plugin (vfpoledb). When I run the package from my PC, it runs smoothly. But, when I try to run the same package in another PC, it displays a DTS_E_OLEDBERROR "Class not registered" error. Anyone has an idea about what this means? thanks in advance.
Is the OLE DB driver correctly installed in the other PC? If the package runs fine in one PC, then I doubt is a SSIS issue.|||Yes, the OLEDB is installed properly in the other PC. The driver is also installed in the Database Server. Still the problem occurs. I also tried placing and running the SSIS package in the database server but the same problem is encountered. I'm running out of ideas as to what might have caused the problem. What might be the cause(s) of the problem?

Thanks.
|||

Could you try using this provider with some other client?

Thanks,

Bob

OLEDB Error when using Visual FoxPro Driver

Hi all,

I created a package that extracts records from a .DBF file into an SQL Server database. I installed a Visual FoxPro plugin (vfpoledb). When I run the package from my PC, it runs smoothly. But, when I try to run the same package in another PC, it displays a DTS_E_OLEDBERROR "Class not registered" error. Anyone has an idea about what this means? thanks in advance.
Is the OLE DB driver correctly installed in the other PC? If the package runs fine in one PC, then I doubt is a SSIS issue.|||Yes, the OLEDB is installed properly in the other PC. The driver is also installed in the Database Server. Still the problem occurs. I also tried placing and running the SSIS package in the database server but the same problem is encountered. I'm running out of ideas as to what might have caused the problem. What might be the cause(s) of the problem?

Thanks.
|||

Could you try using this provider with some other client?

Thanks,

Bob

OLEDB error exceeds maximum length of 128

I created a stored proc which is working perfectly even in SQL query analyser even if my query exceeds 128, but when i run it through asp I'm getting the error code 80040E14 which is mentioned in this subject, how can i work around on this?you can start here: http://support.microsoft.com/kb/306518

OLE Db Source and Variables

I created a OLE DB Source, and created a sql command text.

The issue is with parameters, I have to use the '?' to identify.

What if I have multiple variables of the same type scatter around, how can I define that?

Somthing like this would be good...

Declare @.month
set @.month = ?

select blah,@.month where month=@.month

or

How could I use the ADO Syntax and just put @.month?

Thanks,

Mardo

Hi Mardo,

OLE DB only supports '?' style parameters. You can use ADO style named parameters if you define an ADO.NET connection manager. Ensure you set the ConnectionType property of the Exec SQL Task to ADO.NET in order to reference the new connection manager.

Cheers,

Nick

http://nickbarclay.blogspot.com

|||another solution would be to use variables and expressions to dynamically create the sql statement.|||Execuse my ignorance but I only see a OLE DB Data Flow Source. I understand that ADO.NET can used name paramters but I can only seem to use that in Data Flow Destinations.

Marty|||

Guys, my apologies for being a bit misleading.

The .NET connection manager can be used in conjunction with the Execute SQL task (in the control flow) - when using this type of connection manager you are able to use named parameters. The OLE DB source adapter (in the data flow) is specifically OLE DB i.e. it must use an OLE DB connection manager to access the DB. As Duane posted earlier you can also "use variables and expressions to dynamically create the SQL statement", other than that you will have to use "?" as parameter placeholders.

Cheers,

Nick

http://nickbarclay.blogspot.com

OLE DB Provider for ODBC and Oracle

Hi,

I created a linked server for MS SQL Server 2005 Express to an Oracle
database using the OLE DB Provider for ODBC. My ODBC Source uses the
Microsoft ODBC for Oracle driver.
I'm using the OLE DB Provider for ODBC instead of the Oracle OLE DB
providers because those don't handle Oracle's Numeric Data Type well.
When I set this up yesterday it worked fine. However I log in today and
attempt to run sp_tables_exec against my linked server and get the
following

OLE DB provider "MSDASQL" for linked server "WHATEVER" returned message
"[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed".
OLE DB provider "MSDASQL" for linked server "WHATEVER" returned message
"[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed".
OLE DB provider "MSDASQL" for linked server "WHATEVER" returned message
"[Microsoft][ODBC driver for Oracle][Oracle]".
Msg 7303, Level 16, State 1, Procedure sp_tables_ex, Line 41
Cannot initialize the data source object of OLE DB provider "MSDASQL"
for linked server "WHATEVER".

I can tnsping the server, and I have no trouble connecting with the
Oracle OLE DB provider

I try to set up ODBC logging but the log file is blank -- same with
attempting to set up logging for Oracle's network client. I've been
dealing with crap like this the last 4 days, something works one day,
then the next nothing (I've done nothing to change the configuration
between these outages).

Can anyone help me?

Thanks
FrustratedReplied to duplicate post of 22/12 !

"Crazy Cat" <danbredy@.hotmail.com> wrote in message
news:1135178623.892320.137120@.o13g2000cwo.googlegr oups.com...
> Hi,
> I created a linked server for MS SQL Server 2005 Express to an Oracle
> database using the OLE DB Provider for ODBC. My ODBC Source uses the
> Microsoft ODBC for Oracle driver.
> I'm using the OLE DB Provider for ODBC instead of the Oracle OLE DB
> providers because those don't handle Oracle's Numeric Data Type well.
> When I set this up yesterday it worked fine. However I log in today and
> attempt to run sp_tables_exec against my linked server and get the
> following
> OLE DB provider "MSDASQL" for linked server "WHATEVER" returned message
> "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed".
> OLE DB provider "MSDASQL" for linked server "WHATEVER" returned message
> "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed".
> OLE DB provider "MSDASQL" for linked server "WHATEVER" returned message
> "[Microsoft][ODBC driver for Oracle][Oracle]".
> Msg 7303, Level 16, State 1, Procedure sp_tables_ex, Line 41
> Cannot initialize the data source object of OLE DB provider "MSDASQL"
> for linked server "WHATEVER".
> I can tnsping the server, and I have no trouble connecting with the
> Oracle OLE DB provider
> I try to set up ODBC logging but the log file is blank -- same with
> attempting to set up logging for Oracle's network client. I've been
> dealing with crap like this the last 4 days, something works one day,
> then the next nothing (I've done nothing to change the configuration
> between these outages).
> Can anyone help me?
> Thanks
> Frustrated

OLE DB Provider - Saving SQL UserName and Password error

I have created an SSIS package, which uses an IBM OLE DB Provider for DB2 to access some data. In this case it is not possible to use

Windows NT Integrated Security, so therefore I stored the username and password in the connection.

It works fine for the current user, but if I log on to Windows with another user and try to change the OLE DB connection I recive the following error:

Error 1 Error loading BaliAdslUge.dtsx: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "The key is not valid" (in danish "N?glen er ikke gyldig for anvendelse i den angivne tilstand.").

You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available. c:\_data\projects\baliadsl\integrationservices\BaliAdslUge.dtsx 1 1

Error 2 Validation error. BaliAdsl: OLE DB Source [3075]: The AcquireConnection method call to the connection manager "Pmarco.f00337" failed with error code 0xC0202009. BaliAdslUge.dtsx 0 0

Best regards,

Ejnar Jakobsgaard

TDC

Ejnar,

By default we encrypt sensitive information with the user key. You need to change this to encrypt with password if you want multiple users to be able to decrypt it.

Thanks,|||Hi Matt,

Could you provide some further information on this issue?
How do I encrypted with password, so that several users can use this connection?

What is your advice, if I cannot use Thrusted connection and the user developing the package and running them - Is not the same user?

Best regards,

Ejnar|||Hi Matt,

Thanks :-)

In found some info. in online help at

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/extran9/html/d4b073c4-4238-41fc-a258-4e114216e185.htm

Regards,

Jakobsgaard

OLE DB Destination = temp table

Is it possible to write a dtsx so that the destination of an "OLE DB
Destination" Data Flow Destination is a temp table that is created earlier
in the dtsx ?On Mar 13, 7:05 pm, "John Grandy" <johnagrandy-at-gmail-dot-com>
wrote:
> Is it possible to write a dtsx so that the destination of an "OLE DB
> Destination" Data Flow Destination is a temp table that is created earlier
> in the dtsx ?
You may want to repost on the DTS/SSIS message groups. They are:
microsoft.public.sqlserver.dts and
microsoft.public.sqlserver.integrationsvcs. Sorry I could not be of
greater assistance.
Regards,
Enrique Martinez
Sr. SQL Server Developer

OLE DB Destination - table name variable

Hello,

In my Data Flow I have a OLE DB Destination that needs to get the table name to write the data to dynamicaly from a variable I created.

So I select "table name or view name variable" from the Data access mode and select my variable below. So far so good, but when I click "ok" I get the following error message :

Error at Data Flow Task [OLE DB Destination [45]]: A destination table name has not been provided.
Exception from HRESULT: 0xC0202042 (Microsoft.SqlServer.DTSPipelineWrap)

Am I doing something wrong or is there another way to set a variable table name for the OLE DB Destination ?

Using a variable in this way works fine for me on RTM.

I can get that error if I do not supply a valid table table in my variable before trying to use it in the OLE-DB Destination, which in itself makes sense too.|||Thanks ... I forgot to give the variable a valid default value, now it works.

OLE DB Connection Manager will not save password

I'm stuck with a very annoying problem - any help would be greatly appreciated.

I created a package using Business Intelligence Project. The package reads from a Flat File source and saves to a SQL Server table.

The package has a Data Source for the database connection. In this I have opted to save the password.

When I run the package in VS on my machine it works fine.

I then deployed the package to our SQL 2005 database server using the Deployment Utility. It then appeared in the MSDB section.

I then tested the package ran from my machine using Management Studio and all was fine.

However, if I try to run the package from the database server itself I run into problems. Specifically, the log gives me the following error:
"The AcquireConnection method call to the connection manager "<My Database>" failed with error code 0xC0202009"
....and further down I get:
"Error: an OLE DB error has occurred. Error code: 0x80040E4D. An OLE DB record is available. Source "Microsoft SQL Native Client" Hresult 0x80040E4D Description: "Login failed for user 'sa'.".

What seems to be happening is the password is not being saved in the connection string. Sure enough, if I look at the Connection Managers section of the Execute Package Utility in Management Studio, then my database connection manager has only a User ID specified and no "pwd=". If I add "pwd=<my password>" to this connection string here then the package works.

How do I get this password to be remembered by the Package?

Incidentally, I have also tried writing a VB.NET program to call the package programmatically. Using this, I have tried to set the connection string of my Data Source in the code to try to get round the problem above. However, even after this I still find the only machine the package runs on is mine, and everywhere else it fails to connect.

Please help! Thanks in advance.

Richard FPlease search the forums. SSIS does not save sensitive information in the packages. You'll need to look at using the /SET command line option to pass in a password.|||Thanks for the swift reply.

Apologies for not checking the forums sufficiently before posting. Anyway I have the answer now.

For anybody else struggling with a similar problem, here is your solution. It involves using XML Package Configurations:
http://vyaskn.tripod.com/sql_server_2005_making_ssis_packages_portable.htm

It has to be said in my defence that the MSDN help on SSIS makes no mention of potential deployment problems with regard to connection strings and passwords.
Nowhere is it made clear that using Package Configurations is the answer AND

the password needs to be manually added to the XML after creating the

config file.

It seems intuitive that the "Save Password" box you tick in when creating the Connection Manager in Visual Studio should do just that, but this is a red herring.
This, along with the fact that DTS didn't have such problems, has clearly led to quite a few people getting caught out.

Thanks anyway.

RichardF|||

fagster wrote:

Thanks for the swift reply.

Apologies for not checking the forums sufficiently before posting. Anyway I have the answer now.

For anybody else struggling with a similar problem, here is your solution. It involves using XML Package Configurations:
http://vyaskn.tripod.com/sql_server_2005_making_ssis_packages_portable.htm

It has to be said in my defence that the MSDN help on SSIS makes no mention of potential deployment problems with regard to connection strings and passwords.
Nowhere is it made clear that using Package Configurations is the answer AND

the password needs to be manually added to the XML after creating the

config file.

It seems intuitive that the "Save Password" box you tick in when creating the Connection Manager in Visual Studio should do just that, but this is a red herring.
This, along with the fact that DTS didn't have such problems, has clearly led to quite a few people getting caught out.

Thanks anyway.

RichardF

Microsoft DOES NOT WANT to be in the business of saving sensitive information. Hence the reason they designed it the way they did.

As soon as SSIS touches that config file, you'll find that the password will get removed -- even if you manually entered it. The work around is to set that file to read only, I guess.

Saving passwords is generally a bad idea anyway, given other, better means such as single sign-on, pass-through authentication, etc...|||

Well they did save such information in DTS, this is my point. Then didn't tell us how to do what was elementary in DTS using SSIS. So anyone who uses SQL Authentication and who wants to deploy a simple package to import say some flat file data to their server is going to run into these problems it seems to me.

So could you possibly point me in the direction of these other better methods that don't involve having a connection string with a password? We don't want to move away form SQL Authentication for our database server though if that's what is required with these methods.

Thanks again for your assistance Phil.

RichardF

|||

fagster wrote:

Well they did save such information in DTS, this is my point. Then didn't tell us how to do what was elementary in DTS using SSIS. So anyone who uses SQL Authentication and who wants to deploy a simple package to import say some flat file data to their server is going to run into these problems it seems to me.

So could you possibly point me in the direction of these other better methods that don't involve having a connection string with a password? We don't want to move away form SQL Authentication for our database server though if that's what is required with these methods.

Thanks again for your assistance Phil.

RichardF

Active Directory would be much better than using isolated user names in SQL Server.