Select Permission Denied on owner "dbo" on SQL Server 2000

[Bluegirl]

Hi

(Select Permission Denied on owner "dbo" on SQL Server 2000)

Running SQL Server 2000. I copied a database to be test/dev db. Configured the users on the db to be the same as the live db however the following error occurs whenever a login attempt is made.

Error: System.Data.SqlClient.SqlError: SELECT permission denied on object 'SysUsr', database 'BSSDEV', owner 'dbo'.

I have checked the account config on that user (dbo) and it shares the same settings as its counterpart in the live DB. can you help please?

Thanks

Blue Girl

 

[osjohnm]

What might of happened is that the dbo user on the server and the dbo user on the database might be seen as two "users" by sql server.

Try executing the follwoing stored procedure with the syntax below:

EXEC sp_change_users_login 'Update_One', 'dbo', 'dbo'

This will map the existing dbo user in the dataabase to the dbo user on the actual server.

John