SQL Server Performance Forum – Threads Archive
user dbo login name missingI 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
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
"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
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.