BitShop LLC
Ashburn, VA
(703) 728-6831
Fax:
(703) 563-3826

EMail Us
 

 
Our Blogs
 
Loading BitShop News...
   
 
Morals
 

BitShop abides by: the Rotary International Four Way Test - Find out what that means..

   
 
NEXT STEP
 

To navigate our site click the menu at the top.

   
 
Non-BitShop Ads (Hold Control when you click)
 
Mar15

Written by:Steve Radich - Founder BitShop, Inc.
3/15/2012 11:38 AM 

If you get an error when accessing a database Property page:
TITLE: Microsoft SQL Server Management Studio
ADDITIONAL INFORMATION:
Cannot show requested dialog. (SqlMgmt)
Property Owner is not available for Database '[DBNAME]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights.  (Microsoft.SqlServer.Smo)

 

This means the database owner is not recognized by SQL Server - Most likely you attached a db which doesn't have the owner in the current system (for example you changed domain names of the sql server so the owner is no longer there, or the owners account was deleted from the domain).

To fix just set the database owner:

sp_changedbowner 'sa'

sp_changedbowner 'domain\user'

 

Tags:

Your name:
Your email:
(Optional) Email used only to show Gravatar.
Your website:
Title:
Comment:
Security Code
CAPTCHA image
Enter the code shown above in the box below
Add Comment  Cancel 
 
Please Share Your Comments With Us
 



Submit Comment
Excellent Info0.00%0
Great Info0.00%0
Useful Info0.00%0
Not so useful0.00%0
Confusing / Useless0.00%0

Number of Comments0,Average of Ratings
No comment.
 
Network Status
 

ALL Servers
Operational


   
 
Learn More!
 

Find more about our founder

Steve Radich:

LinkedIn Profile

Contact Us