Login failed for user '(null)'

My development environment consists of 2 separate servers (sql 2000 server
and iis6 server).
SQL 2000 Server has everything installed on it per the Microsoft
documentation.
IIS6 Web Server has everything installed on it per the Micorosoft
documentation.
My workstation has VS 2003 with reporting services install in it.
I followed an example in the Wrox SQL Server Reporting Services book.
Everything was easy to follow and managed to deploy the report to the web
server.
I tried to access the report:
http://192.168.1.4/reportserver?%2fMy+First+Report+Project%2fEmployee_List&rs:Command=Render
Got the following in return:
Reporting Services Error
----
An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
Cannot create a connection to data source 'AdventureWorks2000'.
(rsErrorOpeningConnection) Get Online Help
Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.
----
Microsoft Reporting Services
I clicked on the links provided for help and got:
Currently there are no Microsoft Knowledge Base articles available for this
specific error or event message.
I viewed my datasourcedefinition:
--
- <DataSourceDefinition>
<Extension>SQL</Extension>
<ConnectString>data source=DEV-SRV03;initial
catalog=AdventureWorks2000</ConnectString>
<CredentialRetrieval>Integrated</CredentialRetrieval>
<Enabled>True</Enabled>
</DataSourceDefinition>
--
What do I need to do? Can someone please help me resolve this problem?
Thanks,
WillsWell here is what I did to resolve the problem.
1. Deleted the 1st attempt.
2. Create a SQL account and gave it access to the 3 dbs: AdventureWorks2000,
ReportServer and ReportServerTempDB (role: sys admin; db access with dbowner).
3. Redid the tutorial and instead of Integrated security, I went with the
sql login account.
4. Next, I had to set OverwriteDataSources to True so that it would
overwrite my existing version.
5.
http://192.168.1.4/reportserver?%2fMy+First+Report+Project%2fEmployee_List&rs:Command=Render
Gave me the report I was looking for.
Now my question is on the sql login account. What permissions and security
does my login in account need at a min to do what I just did? I'm sure that I
gave it more than what was needed, but wanted to make sure that it worked.
Thanks,
Wills
"wills" wrote:
> My development environment consists of 2 separate servers (sql 2000 server
> and iis6 server).
> SQL 2000 Server has everything installed on it per the Microsoft
> documentation.
> IIS6 Web Server has everything installed on it per the Micorosoft
> documentation.
> My workstation has VS 2003 with reporting services install in it.
> I followed an example in the Wrox SQL Server Reporting Services book.
> Everything was easy to follow and managed to deploy the report to the web
> server.
> I tried to access the report:
> http://192.168.1.4/reportserver?%2fMy+First+Report+Project%2fEmployee_List&rs:Command=Render
> Got the following in return:
> Reporting Services Error
> ----
> An error has occurred during report processing. (rsProcessingAborted) Get
> Online Help
> Cannot create a connection to data source 'AdventureWorks2000'.
> (rsErrorOpeningConnection) Get Online Help
> Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection.
> ----
> Microsoft Reporting Services
> I clicked on the links provided for help and got:
> Currently there are no Microsoft Knowledge Base articles available for this
> specific error or event message.
> I viewed my datasourcedefinition:
> --
> - <DataSourceDefinition>
> <Extension>SQL</Extension>
> <ConnectString>data source=DEV-SRV03;initial
> catalog=AdventureWorks2000</ConnectString>
> <CredentialRetrieval>Integrated</CredentialRetrieval>
> <Enabled>True</Enabled>
> </DataSourceDefinition>
> --
> What do I need to do? Can someone please help me resolve this problem?
> Thanks,
> Wills