Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

Hi,
I'm new here guys.
I'm developing a web application that's using a separate component to access data from SQL Server 2000. This component uses DAAB of EL June 2005. This data access component resides on a different server from the database server. I would just like to ask if what's the cause of this error. I wonder why it doesn't get the actual user I'm passing?

"Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection."
Our database admin had the database server in mixed mode authentication already.
I don't know if this will help but I'll share the contents of my config files.
web.config contains:
<enterpriselibrary.configurationSettings xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" applicationName="Application" xmlns="http://www.microsoft.com/practices/enterpriselibrary/08-31-2004/configuration">
<configurationSections>
<configurationSection xsi:type="ReadOnlyConfigurationSectionData" name="dataConfiguration" encrypt="false">
<storageProvider xsi:type="XmlFileStorageProviderData" name="XML File Storage Provider" path="dataConfiguration.config" />
<dataTransformer xsi:type="XmlSerializerTransformerData" name="Xml Serializer Transformer">
<includeTypes />
</dataTransformer>
</configurationSection>
</configurationSections>
<keyAlgorithmStorageProvider xsi:nil="true" />
<includeTypes />
</enterpriselibrary.configurationSettings>

dataconfiguration.config contains
<?xml version="1.0" encoding="utf-8"?>
<dataConfiguration>
<xmlSerializerSection type="Microsoft.Practices.EnterpriseLibrary.Data.Configuration.DatabaseSettings, Microsoft.Practices.EnterpriseLibrary.Data, Version=1.1.0.0, Culture=neutral, PublicKeyToken=null">
<enterpriseLibrary.databaseSettings xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" defaultInstance="something" xmlns="http://www.microsoft.com/practices/enterpriselibrary/08-31-2004/data">
<databaseTypes>
<databaseType name="Sql Server" type="Microsoft.Practices.EnterpriseLibrary.Data.Sql.SqlDatabase, Microsoft.Practices.EnterpriseLibrary.Data, Version=1.1.0.0, Culture=neutral, PublicKeyToken=null" />
</databaseTypes>
<instances>
<instance name="something" type="Sql Server" connectionString="something" />
</instances>
<connectionStrings>
<connectionString name="something">
<parameters>
<parameter name="data source" value="dbserver" isSensitive="false" />
<parameter name="initial catalog" value="dbname" isSensitive="false" />
<parameter name="Integrated Security" value="SSPI" isSensitive="false" />
<parameter name="password" value="password" isSensitive="true" />
<parameter name="user id" value="userid" isSensitive="false" />
</parameters>
</connectionString>
</connectionStrings>
</enterpriseLibrary.databaseSettings>
</xmlSerializerSection>
</dataConfiguration>

Also, do I need to create an app.config and another dataconfiguration.config files in my data access component?

Hoping for your replies guys. Thanks in advance!

This KB can help you.

http://support.microsoft.com/default.aspx/kb/307002.

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

Logical Drives

Any advantages/disadvantages in having two separate logical drives when
adding array discs in SQL server. This space will be mainly used for backups
and t-log backups.
ThanksNiles wrote:
> Any advantages/disadvantages in having two separate logical drives
> when adding array discs in SQL server. This space will be mainly
> used for backups and t-log backups.
> Thanks
Are you saying you want to partition you hard drives in the array? If
you're like most customers, you are probably using a RAID 5 array for
the data (the cheapest redundant solution). If so, RAID 5 has terrible
write performance. You would be better off using a mirrored set for the
OS and another mirrored set for the log files. Log files should never
really be on a RAID 5 array since they are written to sequentially. Same
with a backup file.
Let us know how you plan to configure the arrays for the server.
David Gugick
Imceda Software
www.imceda.com|||I'll assume you have your RAID configuration correctly set up. So, having
multiple devices? SQL Server will spawn multiple threads if you have
multiple devices. However, if you use sqlmaint, it will not create multiple
devices, so there would be no performance advantage except if you had
multiple maintenance schedules.
Sincerely,
Anthony Thomas
"Niles" wrote:
> Any advantages/disadvantages in having two separate logical drives when
> adding array discs in SQL server. This space will be mainly used for backups
> and t-log backups.
> Thanks

Logical Drives

Any advantages/disadvantages in having two separate logical drives when
adding array discs in SQL server. This space will be mainly used for backups
and t-log backups.
Thanks
Niles wrote:
> Any advantages/disadvantages in having two separate logical drives
> when adding array discs in SQL server. This space will be mainly
> used for backups and t-log backups.
> Thanks
Are you saying you want to partition you hard drives in the array? If
you're like most customers, you are probably using a RAID 5 array for
the data (the cheapest redundant solution). If so, RAID 5 has terrible
write performance. You would be better off using a mirrored set for the
OS and another mirrored set for the log files. Log files should never
really be on a RAID 5 array since they are written to sequentially. Same
with a backup file.
Let us know how you plan to configure the arrays for the server.
David Gugick
Imceda Software
www.imceda.com
|||I'll assume you have your RAID configuration correctly set up. So, having
multiple devices? SQL Server will spawn multiple threads if you have
multiple devices. However, if you use sqlmaint, it will not create multiple
devices, so there would be no performance advantage except if you had
multiple maintenance schedules.
Sincerely,
Anthony Thomas
"Niles" wrote:

> Any advantages/disadvantages in having two separate logical drives when
> adding array discs in SQL server. This space will be mainly used for backups
> and t-log backups.
> Thanks

Logical Drives

Any advantages/disadvantages in having two separate logical drives when
adding array discs in SQL server. This space will be mainly used for backup
s
and t-log backups.
ThanksNiles wrote:
> Any advantages/disadvantages in having two separate logical drives
> when adding array discs in SQL server. This space will be mainly
> used for backups and t-log backups.
> Thanks
Are you saying you want to partition you hard drives in the array? If
you're like most customers, you are probably using a RAID 5 array for
the data (the cheapest redundant solution). If so, RAID 5 has terrible
write performance. You would be better off using a mirrored set for the
OS and another mirrored set for the log files. Log files should never
really be on a RAID 5 array since they are written to sequentially. Same
with a backup file.
Let us know how you plan to configure the arrays for the server.
David Gugick
Imceda Software
www.imceda.com|||I'll assume you have your RAID configuration correctly set up. So, having
multiple devices? SQL Server will spawn multiple threads if you have
multiple devices. However, if you use sqlmaint, it will not create multiple
devices, so there would be no performance advantage except if you had
multiple maintenance schedules.
Sincerely,
Anthony Thomas
"Niles" wrote:

> Any advantages/disadvantages in having two separate logical drives when
> adding array discs in SQL server. This space will be mainly used for back
ups
> and t-log backups.
> Thanks