SQL Server Service Account

[Douglas Buchanan]

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!

[Oscar Santiesteban Jr.]

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" <an*******@devdex.com> wrote in message
news:41**********************@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!

[Douglas Buchanan]

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...

StartRightClick: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!

[John Bell]

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" <an*******@devdex.com> wrote in message
news:41**********************@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!