Smart Rename giving error "Failed to register database"

MKFerret

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

MKFerret

... I _suppose_ I should cancel the question ... shutting down SQL Management Studio (and Visual Studio) and restarting just SQL Management Studio works upon retrying. I don't know what got locked to prevent the creation of a script, but I'm back up and running now.

All the best,

Mike

Germo

I also get this error, but I can't resolve it by restarting SSMS.
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?

Chris Auckland

If you are unable to have dbo or sysadmin privileges on the server, you should be able to read the necessary metadata to register the database if you:

GRANT VIEW DEFINITION TO [{username}]

I hope this helps.

Germo

This does not solve the problem:
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?

Chris Auckland

Sorry Germo, my mistake.

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.

Germo

yes, this works!
Thank you