Copy database from one server to a different server

Hi
I am trying to copy a database from one server to another using copy database wizard. However, in the process, I am receiving the following error message : 'Your Sql Server Service is running under the local system account. You need to change your sql server Service account to have the rights to copy files over the network.'
I have no idea how to handle this. Any help is greatly appreciated. Thanks in advance.Hi
You may want to check out alternative methods:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q314546
The service account seems can be found either the services applet or
Enterprise Manager.
John
"John" <john_si100@.yahoo.com> wrote in message
news:05CD7ACF-B765-468A-B9FD-BA501C286A89@.microsoft.com...
> Hi,
> I am trying to copy a database from one server to another using copy
database wizard. However, in the process, I am receiving the following error
message : 'Your Sql Server Service is running under the local system
account. You need to change your sql server Service account to have the
rights to copy files over the network.'
> I have no idea how to handle this. Any help is greatly appreciated. Thanks
in advance.|||Create a domain login for SQL Server... THen using SQL Enterprise Manager
right click your server-> Properties->Security and set the login and
password that you have just created...
Then give that NT login permissions on the appropriate files to do the copy
and you are done.
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"John" <john_si100@.yahoo.com> wrote in message
news:05CD7ACF-B765-468A-B9FD-BA501C286A89@.microsoft.com...
> Hi,
> I am trying to copy a database from one server to another using copy
database wizard. However, in the process, I am receiving the following error
message : 'Your Sql Server Service is running under the local system
account. You need to change your sql server Service account to have the
rights to copy files over the network.'
> I have no idea how to handle this. Any help is greatly appreciated. Thanks
in advance.