Integraged to Sharepoint mode, credential problems

I think I have Sharepoint and Reporting services correctly installed to use
windows trusted accounts, (using domain Active Directory logins, but not
Kerberos).
While writing my report, I designed the data set to use windows
authentication (instead of a SQL Server authentication).
From the Report Designer,(report runs fine) the deploy repeatedly asks for
Reporting Services login and won't accept any account credentials at all.
I can upload the report using Sharepoint but when I run the report I get
this error message: "An error has occurred during report processing. This
data source is configured to use Windows integrated securi6ty. Windows
integrated security is either disabled for this report server or your report
server is using Trusted account mode."
Thanks for any assistance,
ShirleyIf using the MOSS 2007 (Microsoft Office Sharepoint Server) , check that the
settings in the Reporting Services Managemnet section for security is set to
Windows Integrated and not Trusted.
"ShirleyH" wrote:
> I think I have Sharepoint and Reporting services correctly installed to use
> windows trusted accounts, (using domain Active Directory logins, but not
> Kerberos).
> While writing my report, I designed the data set to use windows
> authentication (instead of a SQL Server authentication).
> From the Report Designer,(report runs fine) the deploy repeatedly asks for
> Reporting Services login and won't accept any account credentials at all.
> I can upload the report using Sharepoint but when I run the report I get
> this error message: "An error has occurred during report processing. This
> data source is configured to use Windows integrated securi6ty. Windows
> integrated security is either disabled for this report server or your report
> server is using Trusted account mode."
> Thanks for any assistance,
> Shirley
>

Installing SQL 2k Ent in AD environment

While installing SQL Server 2k Ent Ed on a Win2k Server in an Active
Directory environemnt, I have noticed two things different from
installing in a non-AD environment.
1. Using the MS SELECT CD, I am prompted to enter CD-KEY. Normally,
SELECT CDs do not prompt for cd-key. I entered all 1s and was able to
continue.
2. After the install is completed, I can not connect to the server
using Windows authentication. When I try to register the server in
Ent Mgr using my windows login information, I get the following error:
Cannot Generate SSPI Conext Error
I do not get this if I register the server using the sa account.
Do I have to do something different in the Active Directory before
installing SQL Server 2k?
Thanks
JonI don't know about the 1st question, but for the 2nd use the "HOW TO:
Troubleshoot the "Cannot Generate SSPI Context" Error Message" KB article at
http://support.microsoft.com/default.aspx?scid=kb;en-us;811889.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"jtw" <jwright@.mailboxspot.com> wrote in message
news:l3qo00dcrgja0l7ih0blnucgs2nural6s1@.4ax.com...
>
> While installing SQL Server 2k Ent Ed on a Win2k Server in an Active
> Directory environemnt, I have noticed two things different from
> installing in a non-AD environment.
> 1. Using the MS SELECT CD, I am prompted to enter CD-KEY. Normally,
> SELECT CDs do not prompt for cd-key. I entered all 1s and was able to
> continue.
> 2. After the install is completed, I can not connect to the server
> using Windows authentication. When I try to register the server in
> Ent Mgr using my windows login information, I get the following error:
> Cannot Generate SSPI Conext Error
> I do not get this if I register the server using the sa account.
>
> Do I have to do something different in the Active Directory before
> installing SQL Server 2k?
>
> Thanks
> Jon
>