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?