On secuity tab of server properties set "Allow cross database ownership chaining' then your queries will work

IF YOUR SERVER GOT 'BUILTIN\ADMINISTRATORS' server admin people can grant the sa rights

This is the script I am running.

/* CREATE Power Faids Logins in DBs */

DECLARE @username  nvarchar(128)

DECLARE @return_status integer

DECLARE @sql_stmt  varchar(256)

DECLARE @u_password varchar(256)

DECLARE @testdb1_access char(1)

DECLARE @testdb2_access char(1)

SET @username = 'TESTLOGN'

SET @u_password...

Thanks for the quick reply and I am getting the following error.

Server: Msg 15247, Level 16, State 1, Procedure sp_adduser, Line 35

User does not have permission to perform this action.

Server:...