If you have look at my posts before this, this post is connected to Migrating SharePoint 2010 Databases from SQL Server 2008 Express Edition to SQL Server 2008 R2 Enterprise Edition. After detach and attach all MOSS 2010 databases from SQL Server Express, now we have to go back to SharePoint Central Administration.
1st step---
Log on to your Central Administration as farm administrator.
2nd step---
In the SharePoint 2010 Central Administration Page go to Application Management > Databases > Specify the default database server.
3rd step---
In the default database server page, fill in the Domain\SHAREPOINT_DB_Instance of the SQL Server Instance that you'd like to be as the default.
And if on that Instance you are using SQL Authentication, then you have to fill in the Username and Password, instead leave it blank if you're using Windows Authentication.
Sometimes you may get an error message if there's an issue with the permission for NT AUTHORITY/NETWORK SERVICE group like shown below:
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'
This happens when you're using Windows Authentication, and means you will need to grant permission for NT AUTHORITY/NETWORK SERVICE. Below are some steps that i did to grant permission for NT AUTHORITY/NETWORK SERVICE group.
1st step---
Open SQL Management Studio and then connect to the Database Instance. After you are connected, right click on the Database Instance and point to New Query, because we are going to use Transact-SQL to grant the permission.
2nd step---
Execute the script below:
sp_grantlogin 'NT AUTHORITY\NETWORK SERVICE'
After that you will need to go back to the SharePoint Central Administration, and redo the 2nd step--- and 3rd step--- up above. You will not find any error anymore. :)
1 comments:
I followed these steps but am still receiving the same error.
Post a Comment