SqlServer2k is on the domain server
SqlServer2k is on a laptop too

I want to copy a database from the domain to the laptop over the network
using the copy database wizard.

I have done this before with no problem but this time I get the
following error:

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 went into the properties of MSSQLSERVER under Services and
Applications and see no setting described.

Where do manage the SQL Server Service?


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

There should be a log-on tab when you look at the service for MSSQLServer.
You have to change your system from "Local System" to an account on the
domain.


"Douglas Buchanan" <anonymous@devdex.com> wrote in message
news:415c21be$0$26083$c397aba@news.newsgroups.ws.. .
> SqlServer2k is on the domain server
> SqlServer2k is on a laptop too
>
> I want to copy a database from the domain to the laptop over the network
> using the copy database wizard.
>
> I have done this before with no problem but this time I get the
> following error:
>
> 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 went into the properties of MSSQLSERVER under Services and
> Applications and see no setting described.
>
> Where do manage the SQL Server Service?
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

Windows 2003 Small Business Server

> There should be a log-on tab when you look at the service for
MSSQLServer.
> You have to change your system from "Local System" to an account on
the
domain.

I am on the log-on tab.
It is *already* set to an account on the dopmain

This how I got there...

Start
>RightClick:MyComputer
>Manage
>Services and Applications
>Services
>RightClick:MSSQLSERVER
>Properties
>Page:Logon

These are my current settings - The settings under which the error
occurred...

Log on as:
( ) Local System

(*) This Account [DomainName\AdministratorName]
Password [********** ]
Confirm [********** ]

Then there is a hardware profile service listed and enabled

What is wrong?
What do I do next?
(I have no other restrictions of access to the laptop)


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Hi

It is not clear which computer you are looking at, but I assume you are
pushing the database and it is the source database server you are looking
at? It could be that the security information has been lost/corrupt so you
may want to try removing the machine from the domain and/or changing the
service account and stop/starting the SQL Server service.

It should be easier and quicker to use either backup/restore or
sp_detach_db/sp_attach_db instead see:
http://support.microsoft.com/default...;en-us;Q314546

John

"Douglas Buchanan" <anonymous@devdex.com> wrote in message
news:415cdae5$0$26115$c397aba@news.newsgroups.ws.. .
> Windows 2003 Small Business Server
>
> > There should be a log-on tab when you look at the service for
> MSSQLServer.
> > You have to change your system from "Local System" to an account on
> the
> domain.
>
> I am on the log-on tab.
> It is *already* set to an account on the dopmain
>
> This how I got there...
>
> Start
> >RightClick:MyComputer
> >Manage
> >Services and Applications
> >Services
> >RightClick:MSSQLSERVER
> >Properties
> >Page:Logon
>
> These are my current settings - The settings under which the error
> occurred...
>
> Log on as:
> ( ) Local System
>
> (*) This Account [DomainName\AdministratorName]
> Password [********** ]
> Confirm [********** ]
>
> Then there is a hardware profile service listed and enabled
>
> What is wrong?
> What do I do next?
> (I have no other restrictions of access to the laptop)
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!