Friday, April 17, 2015

Error when you select properties of database in SQL Server 2008 (Property Size is not available for Database)

When I am trying to setup mirroring for this database I got the below error message:

TITLE: Microsoft SQL Server Management Studio
------------------------------
Cannot show requested dialog.
------------------------------
ADDITIONAL INFORMATION:
Cannot show requested dialog. (SqlMgmt)
------------------------------
Property Size is not available for Database '[DatabaseName]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights.  (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.6000.34+((KJ_SP3).140819-1214+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.PropertyCannotBeRetrievedExceptionText&EvtID=Size&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
I am sysadmin on that server, so the issue is not related to permission.
I checked the database using sp_help and owner is set and the login is exists on the server.

Resolution : Change the database owner to "SA" or some other login in your system and change back to original owner then it works.

 

Wednesday, April 15, 2015

WMI provider error Invalid parameter [0X80041008] Error trying to change service account on SQL Server service


You may face the below error while changing back the SQL Server service accounts to virtual service accounts like NT Service\MSSQLServer then you may encounter the below error:

---------------------------
WMI Provider Error
---------------------------
Invalid parameter [0x80041008]
---------------------------
OK  
---------------------------
Resolution:

1. Verify whether NT Service\MSSQLServer, NT Service\SQLServerAgent accounts are find in the SQLServerSQLAgentUser$ComputerName, SQLServerMSSQLUser$ComputerName groups on computer management.

2. If there is no such virtual account add the account to those groups

3. Try use services.msc to change the service account to virtual service account (not use SQL configuration manager)