Smart Rename giving error "Failed to register database"
MKFerret
Posts: 4
Perhaps I'm missing something simple, but the Smart Rename feature is giving me the error "Failed to register database" after I select a New name and click Next. Has anyone seen (or more importantly, fixed) this problem?
Best Regards,
Mike
Best Regards,
Mike
Comments
All the best,
Mike
If I am connected to one server (I am sysadmin on this server) I have no problems, if I am connected to another server, I get the error: "Failed to register database". I am db_owner on the database, but only dbcreator and public on this server.
the second server:
Microsoft SQL Server Enterprise Edition (64-bit)
Version 10.0.2723.0
What rights I need on the server?
GRANT VIEW DEFINITION TO [{username}]
I hope this helps.
use [master]
GO
GRANT VIEW ANY DEFINITION TO [{username}]
GO
I am the db_owner on the database, so I think I have all rights I need on the database. But it seams I need some more rights on the server or in a system database for using Smart Rename. Which?
I just noticed you are using SQL 2008. You will also need:
GRANT VIEW SERVER STATE TO [{username}]
I've tested this myself this time, and it resolved the 'failed to register database' issue for me.
Thank you