MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

Database Migration Problem

  Asked By: Alex    Date: Dec 19    Category: MOSS    Views: 1099

We restored our production 2003 Portal to a migration server and then I ran
prescan and it finished successfully. I copied the content databases to the
SQL server on our MOSS farm and attached the datagbases. When I try using
stsadm to add the content database, I get an error:

C:\Program Files\Common Files\Microsoft Shared\web server
dm.exe -o addcontentdb -url http://[servername] -databasename
[db_name] -databaseserver [SQL servername] -databaseuser
[username] -databasepassword [PAssword]

Login failed for user '[username]'. The user is not associated with a
trusted SQL Server connection.

C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN>

If I leave off the username and password, I get a different error:

Input string was not in a correct format.



2 Answers Found

Answer #1    Answered By: Doris Leach     Answered On: Dec 19

The account specified for the -databaseuser parameter must be added to
the SQL Server Logins "folder" before running stsadm. This account must
have the "dbcreator" and "securityadmin" roles checked.

Answer #2    Answered By: Sumitra 2004     Answered On: Dec 19

The account is the dbo and has dbcreator and securityadmin roles. I have
uninstalled MOSS 2007 from the farm servers and uninstalled SQL 2005 and
reinstalled both SQL 2005 and MOSS 2007. Still get the error. ??????

Didn't find what you were looking for? Find more on Database Migration Problem Or get search suggestion and latest updates.