Login failed for user '(null)'

I have several reports using the same database with the same credentials
(using a specific Username and Password). All display fine, except for one
that gives me the following Reporting Services Error:
An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
Cannot create a connection to data source 'BCSpotBonus'.
(rsErrorOpeningConnection) Get Online Help
Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.
I've configured the data in the same way as the other reports and I've tried
using the "Shared database option" and not using the "Shared database
option." Nothing works. How can this be happening?That shouldnt be happening , but even i had the same
problem.
In the Report Designer try to delete the datasource and
then add it again and re deploy the report. Then try to
view the report.
Hope this helps!
>--Original Message--
>I have several reports using the same database with the
same credentials
>(using a specific Username and Password). All display
fine, except for one
>that gives me the following Reporting Services Error:
>An error has occurred during report processing.
(rsProcessingAborted) Get
>Online Help
>Cannot create a connection to data source 'BCSpotBonus'.
>(rsErrorOpeningConnection) Get Online Help
>Login failed for user '(null)'. Reason: Not associated
with a trusted SQL
>Server connection.
>I've configured the data in the same way as the other
reports and I've tried
>using the "Shared database option" and not using
the "Shared database
>option." Nothing works. How can this be happening?
>.
>

login failed db-library network

I am getting this error when loggin in to our application connecting only to
a specific server.
We were experiencing some "db connection or not enabled errors" previously
and to solve the problem I installed the SQL Client Network Ulitities and
setup the TCP/IP protocol with the remote SQL server alias. Now the
application won't connec at all and get's "login failed db-library network".
I've uninstalled the Clinet Network Utilities, but it still won't connect.
Any ideas?
Thanks.
Jim in Alabama
Without the exact error message, it's hard to say. You will
need to provide more specifics - version of SQL Server,
exact error messages, how the application connects (DSN,
connection string, etc).
-Sue
On Mon, 9 Jan 2006 09:42:06 -0800, "KAI Network Admin"
<KAINetworkAdmin@.discussions.microsoft.com> wrote:

>I am getting this error when loggin in to our application connecting only to
>a specific server.
>We were experiencing some "db connection or not enabled errors" previously
>and to solve the problem I installed the SQL Client Network Ulitities and
>setup the TCP/IP protocol with the remote SQL server alias. Now the
>application won't connec at all and get's "login failed db-library network".
>I've uninstalled the Clinet Network Utilities, but it still won't connect.
>Any ideas?
>Thanks.
>Jim in Alabama

Logical equivalent IN operator in a Conditional Split Transformation

I am using a Conditional Split Transformation to find incorrect city listings in a specific list of zipcodes. I have the following condition:

LTRIM([PatientCity]) != 'Wichita Falls' && [PatientZip] IN '76301','76302','76305','76306','76307','76308','76309','76310')

I found the && which is the logical equivalent to AND. I now need a logical operator for IN.

Any ideas or approaches on how I may do this?

No such thing.

You could try:

LTRIM([PatientCity]) != 'Wichita Falls' && ([PatientZip] == '76301' || [PatientZip] == '76302' || [PatientZip] == '76305' || ...etc...)|||

Thanks Phil, that appears to work.

|||

Phil Brammer wrote:

No such thing.

Really? I guess not exactly but FINDSTRING() might work?

|||

Jamie Thomson wrote:

Phil Brammer wrote:

No such thing.

Really? What about FINDSTRING()?

Something like the following?

FINDSTRING("12345,12346,12347",[PatientZip],1)|||

Phil Brammer wrote:

Jamie Thomson wrote:

Phil Brammer wrote:

No such thing.

Really? What about FINDSTRING()?

Something like the following?

FINDSTRING("12345,12346,12347",[PatientZip],1)

Yeah, that's what I had in mind.

|||I guess it should work...... Obviously, I never thought about that...|||

Phil Brammer wrote:

No such thing.

You could try:

LTRIM([PatientCity]) != 'Wichita Falls' && ([PatientZip] == '76301' || [PatientZip] == '76302' || [PatientZip] == '76305' || ...etc...)

Phil - I ran into some issues using the above as some of the PatientZip and PatientCity fields were NULL which Boolean did not like very much. I have tried the following but don't quite have it right, can you suggest a better method to ensure NULL values do not fail the conditional split transformation task?

LTRIM(ISNULL([PatientCity])) != 'Wichita Falls' && (ISNULL([PatientZip]) == '76301' || [PatientZip] == '76302' || [PatientZip] == '76305')

|||I'd use two derived columns. The first to test PatientZip for NULL and if so, replace it with a space, or something.

The second to do the above example, either using my first method, or the FINDSTRING method that Jamie and I talked about.