SQL Database / Permissions / Auto Upgrade
I have a database 'RemoteDesktopMgr' to which I have full rights using Windows Auth (Server 2k8 SP2, SQL 2008 Standard).
After selecting the server and database I get the following:
A database upgrade is required. Connect to the data source with a user with administration right to launch the auto upgrade.
Cannot find the object "Connections" because it does not exist or you do not have permissions.
As far as I can tell, I have administrative rights to the database I created. Ideas? Can I simply execute a script to create the database/schema RDM needs?
Thanks in advance.
-Tim
edited by twebb72 on 5/14/2010
All Comments (1)
Managed to work around the issue.
I deleted the database stub that I created, made sure I had at least dbcreator rights (actually I believe I have sysadmin rights to the db server).
Used the 'Create Database' button, which executes the script I was looking for.
Works. The error was a bit misleading, I had rights to the database, but I believe it was failing because the database was already created. Not sure.