Unanswered: Restored SQL Server Database, but am not the owner.
I had to format my computer and I backed up my SQL Server 2005 database to my external hard disk. I re-installed Windows Vista and SQL Server 2005, Visual Studio 2008 as well.
When I came to restore the database which I backed up, SQL Server says Im not the owner. So I cannot access it properly. To access it (in vs2008 also) I have to run as Administrator, but I still dont have full priveledges. If I right-click the database and choose properties/files I canot add an owner either.
Exactly as I have said in my two posts, I have restored my database in SQL SERVER 2005 Studio Express, but It says I am not the owner. So I cannot even connect to it in VS2008 (for the front end I am building) unless I run VS2008 as administrator. If I run SQL Server as administrator it will allow me to create a db diagram, but if I run as a user I cannot, it says - "A member of the db_owner role must use the database diagramming functionality in order to setup the required database diagramming objects on the SQL Server".
So there is clearly an ownership issue with the database.
One more thing if you are able to restore the DB then only you can access it from the front end.
First of all try to restore the DB as administrator and give the relevant permissions to the required user and then try connecting thru the front end.