OK, I've discovered that my problem , with the sp_AddRoleMember stored procedure, was using both [] and ''. What I've done is this:

EXEC sp_addrolemember N'db_datareader', N'DomainUsersAccess'

GO

EXEC sp_addrolemember N'db_datawriter', N'DomainUsersAccess'

GO

OK, without a doubt I have determined that the lines causing me problems are:

EXEC sp_addrolemember N'db_datareader', N'[DomainUsersAccess]'

EXEC sp_addrolemember N'db_datawriter', N'[DomainUsersAccess]'

Those 2 lines generate the error messages:

Msg 15410, Level 11, State...

Some more info. I ran the SQL script attached to SQL Express using my Windows account. My account has the SysAdmin role assigned to it, so I would think it...

Hi Lowell,

Well, as it turns out other priorities demanded my time, so I'm only now getting back to this. Here's the SQL Script that I came up with, based upon...

I work in a small shop (just 2 of us), and so having direct access to tables & views is SOP. Sorry.

I agree with you, JJ, that education people should have an exposure to programming, but not necessarily a high level of proficiency at it. It's somewhat analogous to elective courses...

I agree with this article. It seems obvious to me (I am a developer first, DBA second), but the linked to article pointed out things I didn't think of. For...

OK, I've added our Domain Users group to the logins for SQL 2008 R2 Express on my PC. It's server role is public. Domain User's default database is the database...

Hi Lowell,

Thank you for your reply. So are you suggesting I go with option 2, use a SQL user instead of integrated security?

I thought that performing a refresh would cause the dataset to update, so that's what I tried. It seemed to include the GenderDesc column, but it left the old Gender...

I've performed the left join to the Gender table in the stored procedure. It works fine. But for some reason the SSRS report refuses to see the change in the...

Yes, geoff5, I agree with you. Since we're currently at SQL 2005, I'm going to have to change the stored procedure.

Well, I've done that, but for some reason the RDLC...

I'm beginning to think that my problem is that the backend database is still at SQL 2005, regardless of the report writer (SSRS). Initially I wrote in the expression what...

geoff5,

This report started it's like as a SSRS 2005 report. I believe I started it with VS 2008 or earlier (can't remember now). I've migrated it to VS 2010, using...

OK, here's another image, with more details, including the menu items from Visual Studio, where I do the development. Hopefully this will show you the tablix you speak of.

[/url]

WPF RFS...