Hi All, I had a low space issue on my SharePoint database server on C drive, since some of my share point databases resided on the same drive. we have the web front end and the databases on different servers. I moved all the databases from C to D, but after moving when I go back to my SharePoint web front end server and try to add the central admin database to its corresponding web application using command line it says access denied. Currently I dont have my central admin site working. I tried adding the account onto the database sever as a local admin and gave the Security Administrator role and Database Creator role but still it says access denied error message. Thus anybody know how to fix this problem. Any help would be greatly appreciated. Thanks.

Are you logged in as the account that has appropriate access to SQL Server and then tried the operation? Blog: Alpesh Nakar's Blog | Twitter: Follow Alpesh on Twitter |SharePoint Resources: Just SharePoint Resource Center | Follow Just SharePoint updates on Twitter

Alpesh is correct, you need to logon as an account that has "dbo" access to the SharePoint_Config database to add a content database. ChrisChris Givens CEO, Architecting Connected Systems Blog Twitter

Thanks for the reply guys, I have just seen the permissions on both the web front end and on the database server and on both the servers its a local admin account. but for the SharePoint_Config database the dbo is under other name who already left the company. Please help.

So that means you need to add a current account in SQL Security and give the permissions (make dbo) and see how you go.Blog: Alpesh Nakar's Blog | Twitter: Follow Alpesh on Twitter |SharePoint Resources: Just SharePoint Resource Center | Follow Just SharePoint updates on Twitter

Hi Alpesh, I'm new to databases, do you know how to change the dbo for a database?when i look at the properties of the database it shows that my account is the owner of the SharePoint_Admin_content database but when I expand the database and go to security--> Users-->dbo, it shows the dbo as someone else who already left the company.

try to grant the db_owner role for config db and admin db to this user.

Yeah I was able to change the db_owner role for config and admin db. Now when I try to attach the admin database with the central admin web application its still giving me an Access Denied error. Thus anybody know how to fix this? Please help.

When you run the Management Shell right click and choose run as administratorHTH Nagesh S Days and years do not mean anything to me. Moments shared are frozen in their time frame. Distance or time never fades them for me. I cherish them like my life. I have never let them sleep alone. Sachi