hell there,

i am having problem viewing reporting service reports i created.i get this error.how do i create a user with a trusted SQL Server connection.

the error i get is.but in my studio i see that user 'ReportExecution'.

An error has occurred during report processing.
Cannot create a connection to data source 'rs2005sbsDW'.
Login failed for user 'ReportExecution'. The user is not associated with a trusted SQL Server connection.



when i run this sql script

DECLARE @PermissionString nvarchar(255)
DECLARE @AWSalesDirector nvarchar(200)
DECLARE @SalesAnalyst nvarchar(200)

SET @AWSalesDirector = @@SERVERNAME + '\AWSalesDirector'
SET @SalesAnalyst = @@SERVERNAME + '\SalesAnalyst'

--drop the users from the database
use rs2005sbsDW
if exists(select * from sysusers where name='ReportExecution')
      exec sp_dropuser @name_in_db='ReportExecution'
if exists(select * from sysusers where name=@AWSalesDirector)
      exec sp_revokedbaccess @name_in_db=@AWSalesDirector      
if exists(select * from sysusers where name=@SalesAnalyst)
      exec sp_revokedbaccess @name_in_db=@SalesAnalyst

use rs2005sbs
if exists(select * from sysusers where name='ReportExecution')
      exec sp_dropuser @name_in_db='ReportExecution'
if exists(select * from sysusers where name=@AWSalesDirector)
      exec sp_revokedbaccess @name_in_db=@AWSalesDirector      
if exists(select * from sysusers where name=@SalesAnalyst)
      exec sp_revokedbaccess @name_in_db=@SalesAnalyst

use msdb
if exists(select * from sysusers where name='ReportExecution')
      exec sp_dropuser @name_in_db='ReportExecution'
if exists(select * from sysusers where name=@AWSalesDirector)
      exec sp_revokedbaccess @name_in_db=@AWSalesDirector      
if exists(select * from sysusers where name=@SalesAnalyst)
      exec sp_revokedbaccess @name_in_db=@SalesAnalyst

use ReportServer
if exists(select * from sysusers where name='ReportExecution')
      exec sp_dropuser @name_in_db='ReportExecution'
if exists(select * from sysusers where name=@AWSalesDirector)
      exec sp_revokedbaccess @name_in_db=@AWSalesDirector      
if exists(select * from sysusers where name=@SalesAnalyst)
      exec sp_revokedbaccess @name_in_db=@SalesAnalyst

--create the logins
use master
exec sp_droplogin @loginame='ReportExecution'
exec sp_addlogin @loginame='ReportExecution', @passwd='ReportExecutions'

exec sp_revokelogin @loginame=@AWSalesDirector
exec sp_grantlogin @loginame=@AWSalesDirector

exec sp_revokelogin @loginame=@SalesAnalyst
exec sp_grantlogin @loginame=@SalesAnalyst

use rs2005sbsdw
--add the users to the databases and give them permissions
exec sp_adduser @loginame='ReportExecution', @grpname='db_datareader'
exec sp_grantdbaccess @AWSalesDirector, @AWSalesDirector
exec sp_addrolemember 'db_datareader', @AWSalesDirector
exec sp_grantdbaccess @SalesAnalyst, @SalesAnalyst
exec sp_addrolemember 'db_datareader', @SalesAnalyst
GRANT EXECUTE ON sp_ActualVsQuota TO ReportExecution
SELECT @PermissionString = 'GRANT EXECUTE ON sp_ActualVsQuota TO [' COLLATE Latin1_General_CI_AS + @AWSalesDirector + ']' COLLATE Latin1_General_CI_AS
EXEC (@PermissionString)

use rs2005sbs
--add the users to the databases and give them permissions
exec sp_adduser @loginame='ReportExecution', @grpname='db_datareader'
exec sp_grantdbaccess @AWSalesDirector, @AWSalesDirector
exec sp_addrolemember 'db_datareader', @AWSalesDirector
exec sp_grantdbaccess @SalesAnalyst, @SalesAnalyst
exec sp_addrolemember 'db_datareader', @SalesAnalyst

use msdb
--add the users to the databases and give them permissions
exec sp_adduser @loginame='ReportExecution', @grpname='db_datareader'
exec sp_grantdbaccess @AWSalesDirector, @AWSalesDirector
exec sp_addrolemember 'db_datareader', @AWSalesDirector
exec sp_grantdbaccess @SalesAnalyst, @SalesAnalyst
exec sp_addrolemember 'db_datareader', @SalesAnalyst

use ReportServer
--add the users to the databases and give them permissions
exec sp_adduser @loginame='ReportExecution', @grpname='db_datareader'
exec sp_grantdbaccess @AWSalesDirector, @AWSalesDirector
exec sp_addrolemember 'db_datareader', @AWSalesDirector
exec sp_grantdbaccess @SalesAnalyst, @SalesAnalyst
exec sp_addrolemember 'db_datareader', @SalesAnalyst



i get this error-------

Changed database context to 'rs2005sbsDW'.
Changed database context to 'rs2005sbs'.
Changed database context to 'msdb'.
Changed database context to 'ReportServer'.
Changed database context to 'master'.
Msg 15007, Level 16, State 1, Server ZJAFFERI, Procedure sp_droplogin, Line 26
'ReportExecution' is not a valid login or you do not have permission.
Msg 15151, Level 16, State 1, Server ZJAFFERI, Line 1
Cannot drop the login 'ZJAFFERI\AWSalesDirector', because it does not exist or you do not have permission.
Msg 15151, Level 16, State 1, Server ZJAFFERI, Line 1
Cannot drop the login 'ZJAFFERI\SalesAnalyst', because it does not exist or you do not have permission.
Changed database context to 'rs2005sbsDW'.
Changed database context to 'rs2005sbs'.
Changed database context to 'msdb'.
Changed database context to 'ReportServer'.