locked
How to add new database server instance in Sharepoint 2010? RRS feed

  • Question

  • I have installed SQL server 2012 BI edition and I have been trying to add new SQL Server reporting services in Sharepoint 2010 central admin .But When I click "ok "after giving the new SQL server name in the SQL Server reporting service creating process, I get an error stating "This user does not have permission on the SQL server".Though ,I have given this user dbcreator role on that particular database instance.Could you please help me out?

    Wednesday, January 22, 2014 8:38 AM

All replies

  • Does the initial installation account used to set-up the farm have these permissions on the database?

    Steven Andrews
    SharePoint Business Analyst: LiveNation Entertainment
    Blog: baron72.wordpress.com
    Twitter: Follow @backpackerd00d
    My Wiki Articles: CodePlex Corner Series
    Please remember to mark your question as "answered" if this solves (or helps) your problem.

    Wednesday, January 22, 2014 9:43 AM
    Answerer
  • http://www.cospug.com/Lists/Discuss/Flat.aspx?RootFolder=%2fLists%2fDiscuss%2fHow%20to%20Change%20the%20instance%20of%20a%20Sharepoint%20Database%20server&FolderCTID=0x01200200AACA264BD3CDE14BAA5FE824BD31F380

    http://sharepointpromag.com/sharepoint-administration/simple-guide-moving-sharepoint-content-databases-new-server

    Wednesday, January 22, 2014 10:00 AM
  • I am not sure onthis.But I used completely new account.Earlier the database that was being used was SQL 2008 express and it some XYZ\Databaseserver1 and now I installed new SQL server 2012 BI evaluation version and I have created a name instance name XYZ\DB1 .I also gave administrator the dbcreator access.

    Wednesday, January 22, 2014 2:39 PM