|
You use SharePoint Central Administration to try to migrate content from
Microsoft Content Management Server (MCMS) 2002 to Microsoft Office SharePoint
Server 2007. When you click Connect in the Source Database area of the Create
Migration Profile page, you receive the following error message: Unable to
connect to the database server. Verify that the authentication method,
username, and password are correct.
This issue occurs if the user who you use to connect to the MCMS server is not
configured to use the master database as the default database in Microsoft SQL
Server.
WORKAROUND
To work around this issue, make sure that the user has Read access to the
master database in Microsoft SQL Server 2005 or in Microsoft SQL Server 2000.
Then, configure the user to use the master database as the default database. To
configure the user to use the master database as the default database, follow
these steps:
1. Use one of the following procedures, as appropriate for
your situation:
• If you are running Microsoft SQL Server 2005, start SQL Server Management
Studio.
• If you are running Microsoft SQL Server 2000, start SQL Server Enterprise
Manager.
2. Expand Security, and then expand Logins.
3. Double-click the user who you want to configure, and then
click General under Select a page.
4. In the Default database box, click master, and then click
OK.
|