SQL Server 2005 Error Message - when Right Clicking a DB > Properties

[former_member282786]

Hi

We are running SQL Server 2005 SP03, we have x15 databases (excluding SBO-COMMON, RSP, Coresuite), all x15 databases have Maintenance Plans setup, tasks ticked:

- Shrink Database

- Clean Up History

- Back up Database (Full)

- Maintenance Clean-up task

These Maintenance Plans have been running for over 5 months now, we have recently changed our VMware Virtual Server over to a Hosted VMware Virtual Server, now when I right click on a certain database and select "Properties" I get the following error message with SQL Server:

Property Owner is not available for Database '[Turquoise_Moon_Live]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo)

Could the Maintenance Plan be preventing me to run the Properties against a relevant DB (I have tested this by restoring a DB that doe not have a Maintenance Plan and the Properties works, tested this on SBO-COMMON and it works as well)

Can anyone agree with me or let me know what else might be the issue as I have checked the Server Roles & the Users Credentials for SQL and all seems well.

Regards

Kurt Walters

[Former Member · Accepted solution]

Hi Kurt Walters,

Have you reset those plans after moving the database to new VM?

Thanks,

Gordon

[former_member282786 · Accepted solution]

Hi Gordon

No, I have not reset them as it is the same server just hosted now so the credentials are still the same in some aspects. I am needing to change the Maintenance Plans from 2 months to 1 month.

Do you think a deletion and a re-doing of the Maintenance Plans will be a good thing? or is there another way to change the months and reset the Plans?

Regards

Kurt Walters

[Former Member · Accepted solution]

I will if I were you. Do not assume everything is the same unless it is exactly the same.

[former_member282786 · Accepted solution]

Hi Gordon

So to reset I will need to Delete the current Maintenance Plans and re-do them? then this should solve my Propertiesw issue.

Regards

Kurt Walters

[Former Member · Accepted solution]

That is correct. However, it may not guarantee the problem would be solved. You should try one first.

[former_member282786 · Accepted solution]

Ok Brilliant, I will try this first and see how we go.

Thanks for the help.

Regards

Kurt Walters

[former_member282786 · Accepted solution]

Hi Gordon

This solution did not work, but I needed to delete the Maintenance Plans anyway to set it for 1 month instead of 2 Months. I am thinking as we have changed Domains, were the last one was IS Domain and the new one is Hosted Domain, the security issues are probably coming from this (as I am able to access the Properties of the IS Domain SQL Server even with the Maintenance Plans running).

Any thoughts on correcting this as we have changed Domains? (I have created a user as HOSTED\example, the old one was IS\example)

Regards

Kurt Walters

[Former Member · Accepted solution]

This kind of issue is very complicated. I am not able to comment if no hands-on to the domain. Go through all security policy to dig it out.

[former_member282786 · Accepted solution]

Hi Gordon

Thanks very much for the help, I basically did a Detach and Re-attach and the properties option becomes available for the relevant database on SQL Server 2005 now.

So as you said it basically carried across the data / security settings from the old server to the new therefore prompting me to detach and re-attach.

Regards

Kurt Walters