locked
SharePoint central admin not finding users/roles when connected to different sql server RRS feed

  • Question

  • Can anybody tell why SharePoint central admin is not able to find users/roles when connectionString on IIS was changed to different server and database.

     

    I have aspnet_regsql.exe configured for different server and database and the database and sharepoint admin has all the permissions required to connect to the database.

    Wednesday, June 1, 2011 4:23 PM

Answers

  • Did you make sure that the appPool identity account for Central Admin has access to the ASPNETDB database on the new SQL server.  The connection string connects to the SQL server as the app pool identity, not the sharepoint admin.
    Paul Stork SharePoint Server MVP
    • Marked as answer by Peng Lei Wednesday, June 8, 2011 9:01 AM
    Wednesday, June 1, 2011 4:50 PM