No I want the values in the second column to be separated into two columns based on 0 or 1 in column one correspond to the values in column two and column...

You removing anonymous user does not remove the need for Asp.net runtime having permissions in SQL Server and the database, try the thread below for details. 

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=150&messageid=196449

If you are not using Asp.net then reporting services account maybe local systems account which means it is not a domain account. Removing anonymous user does not remove the need for...

If you are using integrated security that error means Asp.net runtime is not a user in your SQL Server and database.  Hope this helps.

Hi Loner,

I am in Michigan it still gets cold here compared to Houston Texas.  I blame the cold weather.

(Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON')

The above means one connection to reporting services login info is dropped, that was the last thing I explained, check all your connection properties...

(I have to admit that the option at looking for a therapist never occurred to me.  I was raised by the generation that said that if things got tough or...

I will not say I have fixed my problems but I will not make the decision to see a therapist because it is suggested by one person in a very...

You need to use the surface area configuration tool to enable browser service and choose local and remote connection.  And you also need to go to Management Studio and change...

(Of course - as I've said before - physical training to the point of exhaustion tends to take one's mind off the pressures of work )

I know when I ran...

There are two ways I would do it either download and install the trial 2005 or buy the developer edition and spend time with the first link below and fill...

Go to add remove program and click on add Windows component and add Administrative tool it includes IIS install it then rerun setup and choose repair and now SSRS will...

If you want to use it to practice Express is not good enough because you will not be exposed to the subsystem specific issues, so make sure you have IIS...

LINQ let you write queries in C#/VB.NET like SQL, I think it will reduce software development time because it will be easier to pass data from one SET to another...

There are two properties in this but both are not equipped to perform the task. Here is what you need, right click on the base surface that gives you the layout...