SQL Server Performance Forum – Threads Archive

user dbo login name missing

I have just moved a database from an old server using detach / attach functions. the reattached database works fine but all the database maintenace jobs fail. The database backup fails with :
The job failed. The owner () of job DB Backup Job for DB Maintenance Plan ‘TrackIT Database Maintenance Plan’ does not have server access. I think this down to the login name being missing from db user dbo in the database users (normally it would be sa). Does anyone have any ideas how to add a login name to dbo. Regards SHarwood

Hi,
you can grant access and change db owner for your ‘trackit database’ to sa look in bol for
sp_grantaccessdb and sp_changedbowner Regards Hemantgiri S. Goswami
[email protected]
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri Goswami

If it is a SQL login then run SP_CHANGE_USERS_LOGIN Report to see whether it is an orphaned connection, if so use UPDATE option to fix the problem. Refer to books online for more information. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>