Login failed for user '(null)'.

I did a bunch of windows updates this weekend on my SQL Server 2000 and My
Reporting Server. One of them was a SharePoint 2.0 Service pack. Reporting
Services and SharePoint reside on the same server and were both fuctioning
properly before the I did the updates. I am running SharePoint and Reporting
services on SSL. And I have a valid third party certificate. When I try to
run a report in Reporting Services that requires Windows NT Integrated
Security. I get this error:
Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.
Please HelpOn Dec 17, 1:23 pm, vbchewie <vbche...@.discussions.microsoft.com>
wrote:
> I did a bunch of windows updates this weekend on my SQL Server 2000 and My
> Reporting Server. One of them was a SharePoint 2.0 Service pack. Reporting
> Services and SharePoint reside on the same server and were both fuctioning
> properly before the I did the updates. I am running SharePoint and Reporting
> services on SSL. And I have a valid third party certificate. When I try to
> run a report in Reporting Services that requires Windows NT Integrated
> Security. I get this error:
> Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection.
> Please Help
This article might be helpful.
http://geekswithblogs.net/ranganh/archive/2005/05/25/40489.aspx
Regards,
Enrique Martinez
Sr. Software Consultant|||That article has more to do with ASP then Reporting Server. The funny thing
is it was not working on Monday. I left it alone for a day went back in
today and all seams to be working properly again. Could it have something to
do with replication on my domain? I recently moved all of the FSMO's to a
different server and shut down my Win2000 PDC. In a attempt to see if any
problems will be arise when DCPROM it and pull it off of the domain.
Thanks
"EMartinez" wrote:
> On Dec 17, 1:23 pm, vbchewie <vbche...@.discussions.microsoft.com>
> wrote:
> > I did a bunch of windows updates this weekend on my SQL Server 2000 and My
> > Reporting Server. One of them was a SharePoint 2.0 Service pack. Reporting
> > Services and SharePoint reside on the same server and were both fuctioning
> > properly before the I did the updates. I am running SharePoint and Reporting
> > services on SSL. And I have a valid third party certificate. When I try to
> > run a report in Reporting Services that requires Windows NT Integrated
> > Security. I get this error:
> >
> > Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> > Server connection.
> >
> > Please Help
>
> This article might be helpful.
> http://geekswithblogs.net/ranganh/archive/2005/05/25/40489.aspx
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>sql