Sunday, March 11, 2012

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 File:SQLDMO80.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.Make sure the login account is a domain account with permission to access the target server.|||which acount u r talking abt?service start or my login account...?|||the account for sqlserveragent. what is mmm\servicestart?|||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.|||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.|||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.|||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.

No comments:

Post a Comment