[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 194
  • Last Modified:

Moving Sharepoint Databases

Hi,

We originally installed sharepoint into a seperate instance on our SQL 2008 server away from our other databases on the default instance. We now want to simplify our programming and move the databases onto the default instance.

I detached the databases and moved them and re-attached into the default instance and created an alias (Which the SQL management studio recognised) but sharepoint was unable to connect to the databases.

The sharepoint was setup by someone else and it appears that we do not have the passphrase either.

I have seen lots of methods, but most about moving from one server to another not instances. What would be the best way to move the exisiting sharepoint databases?
0
TyreeSupport
Asked:
TyreeSupport
  • 3
  • 2
1 Solution
 
QPRCommented:
Did sharepoint give a reason for not being able to connect?
Have you ensured that all the necessary logins (Sharepoint app pool account etc) have been created in the default instance?
0
 
TyreeSupportAuthor Commented:
When we entered the sharepoint url it would just say "unable to connect to the database"

We have rolled back to the named instance, so where would I see the pool account and logins you mention?

There is a specific user that is the owner of the databases.
0
 
QPRCommented:
Look at the service accounts listed in central admin "configure service accounts" under security.
Go through the drop down box taking note of the accounts used. Depending on how SP was installed/configured then these will be either dedicated windows acounts or "network service"

Of course the easiest way would be to compare the previous instance and the default instance to see if any accounts/permissions are missing.

Have you restarted all the services since the change?
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
TyreeSupportAuthor Commented:
I did restart the instances when I was testing.

I do have both instances available so I will compare and check the logins and make them the same and transfer the databases again tonight as staff are online now.
0
 
Shailendra_karveCommented:
Firstly are you moving the SharePoint Config database from one server to another
Microsoft doesn't recomend to move config database from one server to another
So the best way would be create a new config database on the new server
Attach the database to the new instance
Then to attach the database to the web application use this command stsadm -o addcontentdb -url <sitename> -databasename <databasename>
0
 
TyreeSupportAuthor Commented:
Hi,

So your saying run the config wizard with the new SQL instance (Default) and then run the command that you specified to attache the content (wss_content) databases only to the new instance.
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now