I am trying to delete a just created site collection but it keep giving me this error,
PS C:\Users\svc_spadmin> Remove-SPSite -Identity "http://intranet.sharepoint2010 .com/portalll/DeleteMe" -GradualDelete Confirm Are you sure you want to perform this action? Performing operation "Remove-SPSite" on Target "http://intranet.sharepoint2010.com/portalll/DeleteMe". [Y] Yes [A] Yes to All [N] No [L] No to All [S] Suspend [?] Help (default is "Y"):y
Remove-SPSite : Cannot open database "WSS_Content_SharePoint2010" requested by the login. The login failed. Login failed for user 'SP\Svc_SPAdmin'. At line:1 char:14 + Remove-SPSite <<<< -Identity "http://intranet.sharepoint2010.com/portalll/De leteMe" -GradualDelete + CategoryInfo : InvalidData: (Microsoft.Share...mdletRemoveSite: SPCmdletRemoveSite) [Remove-SPSite], SqlException + FullyQualifiedErrorId : Microsoft.SharePoint.PowerShell.SPCmdletRemoveSi te
Now if I logon to Central Admin and delete this site collection I don't have any kind of permission problem then why using powershell script ?
When I try to add myself to db owner I get this error and don;t see DB in User Mapping table.
I logged in as Administrator which I used to install SQL Server but I can't find any permissions on Content DB even tho I am able to browse sites in browser.