Results 1 to 8 of 8

Thread: copy database

  1. #1
    Join Date
    Apr 2003
    Posts
    176

    Unanswered: copy database

    when i'm copying my database from one server to another server the package is faling with the follwoing errors



    Step Error Source: Microsoft SQL-DMO (ODBC SQLState: 28000)
    Step Error Description:[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'mmm\servicestart'.
    Step Error code: 80004005
    Step Error Help FileQLDMO80.hlp
    Step Error Help Context ID:700

    What is the exact problem with these errors and what should i do to overcome this.Can anyone help me in this regard.

    Thanks.

  2. #2
    Join Date
    Jan 2004
    Location
    Boston
    Posts
    58
    Make sure the login account is a domain account with permission to access the target server.

  3. #3
    Join Date
    Apr 2003
    Posts
    176
    which acount u r talking abt?service start or my login account...?

  4. #4
    Join Date
    Jan 2004
    Location
    Boston
    Posts
    58
    the account for sqlserveragent. what is mmm\servicestart?

  5. #5
    Join Date
    Apr 2003
    Posts
    176
    yes, the sqlserver agent user in source server is mmm\administrator and in the destination server is mmm\servicestart.
    The logins are not same for the sqlserver agents on the two servers.
    Is that the reason behind the error?
    So how should i overcome this problem?

    Thanks for ur time and efforts in this issue.

  6. #6
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621
    Originally posted by bruce_Reid
    yes, the sqlserver agent user in source server is mmm\administrator and in the destination server is mmm\servicestart.
    The logins are not same for the sqlserver agents on the two servers.
    Is that the reason behind the error?
    So how should i overcome this problem?

    Thanks for ur time and efforts in this issue.
    Set the same accounts for your servers and agents.

  7. #7
    Join Date
    Apr 2003
    Posts
    176
    should I just create the user or i should change the login in the sqlserver agent to the source server(mmm\admin...) to the user of the destination(mmm\servicestart). ANd should the passwords the same for the logins on the two servers means for the login servicestart on both source and target servers.
    Can u please let me know the detailed procedure to do this copy...
    Thanks.

  8. #8
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621
    Originally posted by bruce_Reid
    should I just create the user or i should change the login in the sqlserver agent to the source server(mmm\admin...) to the user of the destination(mmm\servicestart). ANd should the passwords the same for the logins on the two servers means for the login servicestart on both source and target servers.
    Can u please let me know the detailed procedure to do this copy...
    Thanks.
    You should have domain account with sufficient rights for designed activity (DTS, network, etc.). Use this account as Log On instead of Local System account (see Control Panel\Administrative Tools/Services/MSSQLSERVER/Properties and the same for MSSQL Agent) for both your servers. Also you have to add login for domain\account on servers and add this account to System Administrators server role. After that your servers will have the same rights in domain.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •