Backup and Restore Database in CS 2.0

Reply

vantroeyen Posted: Thu, May 17 2007 3:51 AM

rated by 0 users

hello,

I am not very famliar with SQL Server 2005 and specialy in defining the security elements, this is the reason of my post before any action...

I will have to move my CS 2.1 server to a new computer. So I plan to backup the database file, copy it to the new computer, and then restore it on the new SQL Server 2005. I know that there are some security modifications to do. But I don't know all of them.

I didn't find a complete check up, can anyone help me ?

Thank's

Reply

Dave Stokes replied on Thu, May 17 2007 4:11 AM

rated by 0 users

Hi,

After restoring the database you will need to grant the following permissions/roles to the user account that Community Server will use to access the database.

• dbo
• aspnet_Membership_BasicAccess
• aspnet_Membership_FullAccess
• aspnet_Membership_ReportingAccess
• aspnet_Profile_BasicAccess
• aspnet_Profile_FullAccess
• aspnet_Profile_ReportingAccess
• aspnet_Roles_BasicAccess
• aspnet_Roles_FullAccess
• aspnet_Roles_ReportingAccess

Regards

Dave