local system privildges

I am trying to upgrade the SQL Server 6.5 on one server to SQL
Server2000 on the other machine.

At that time, i am getting the following error:

"The local SQL Server is running under localsystem priviledges,
preventing the upgrade wizard to connect to the export server."

I am logged on thru the administrator on both the machines.

Pls tell how to to eradicate this error, so that my upgrade is
successful.

Thanks in advance.thakwani@.rediffmail.com (Prashant Thakwani) wrote in message news:<bf0d42bf.0404252301.780bce11@.posting.google.com>...
> I am trying to upgrade the SQL Server 6.5 on one server to SQL
> Server2000 on the other machine.
> At that time, i am getting the following error:
> "The local SQL Server is running under localsystem priviledges,
> preventing the upgrade wizard to connect to the export server."
> I am logged on thru the administrator on both the machines.
>
> Pls tell how to to eradicate this error, so that my upgrade is
> successful.
>
> Thanks in advance.

During the upgrade, the SQL2000 server needs to connect to the
filesystem on the SQL6.5 server. This is not possible if the MSSQL
service is running as LocalSystem, because LocalSystem has no network
access. You should consider changing your SQL2000 installation to run
using a domain account, instead of LocalSystem - this is recommended
anyway, as some functionality requires a domain account, and it's also
possible to limit the permissions of the service account, which is
better for security.

See "Setting up Windows Services Accounts" and "Changing Passwords and
User Accounts" in Books Online.

Simon

Local 2K5 server & Remote 2K server

Hi,
I was wondering what the issues I might face if I were to upgrade my
local SQL server to 2005 while my remote hosting server is still SQL
2000. Are there huge differences in formats of dbs, tables, jobs, etc
or is it largely UI & feature enhancements?
There isn't a great deal of interation between the servers, but I would
like to be able to, for instance, continue exporting a nightly copy
down to my local server and it being useable without too having to
re-jig things too much.
Thanks for any help you can lend,
Mick
Mick
I have installed on my pc sql server 2005 and linked/connected to sql server
2000 . By saying "nightly copy" dod you mean a backup of the database and
then restore in on local server. It is also possible.
<mick.hodgson@.gmail.com> wrote in message
news:1162982342.259348.291440@.m73g2000cwd.googlegr oups.com...
> Hi,
> I was wondering what the issues I might face if I were to upgrade my
> local SQL server to 2005 while my remote hosting server is still SQL
> 2000. Are there huge differences in formats of dbs, tables, jobs, etc
> or is it largely UI & feature enhancements?
> There isn't a great deal of interation between the servers, but I would
> like to be able to, for instance, continue exporting a nightly copy
> down to my local server and it being useable without too having to
> re-jig things too much.
> Thanks for any help you can lend,
> Mick
>
|||Thanks Uri,
It is a nightly DTS Export which copies the database objects down to
the local server.
Do you have the full 2005 database engine on your PC or just the client
tools? I need to know i can develop on a SQL2005 db and it will work
when uploaded to the SQL2000 db.
Thanks again!
Mick
Uri Dimant wrote:[vbcol=seagreen]
> Mick
> I have installed on my pc sql server 2005 and linked/connected to sql server
> 2000 . By saying "nightly copy" dod you mean a backup of the database and
> then restore in on local server. It is also possible.
>
> <mick.hodgson@.gmail.com> wrote in message
> news:1162982342.259348.291440@.m73g2000cwd.googlegr oups.com...
|||Mick
> Do you have the full 2005 database engine on your PC or just the client
> tools? I need to know i can develop on a SQL2005 db and it will work
> when uploaded to the SQL2000 db.
Yes, I do. Using DTS/SSIS to move the data is a headache ,epsecially
between 2000/2005.
Most likely to backup database on the sql server 2000 and restore on sql
server 2005
<mick.hodgson@.gmail.com> wrote in message
news:1162986618.135708.111690@.m7g2000cwm.googlegro ups.com...
> Thanks Uri,
> It is a nightly DTS Export which copies the database objects down to
> the local server.
> Do you have the full 2005 database engine on your PC or just the client
> tools? I need to know i can develop on a SQL2005 db and it will work
> when uploaded to the SQL2000 db.
> Thanks again!
> Mick
> Uri Dimant wrote:
>

Local 2K5 server & Remote 2K server

Hi,
I was wondering what the issues I might face if I were to upgrade my
local SQL server to 2005 while my remote hosting server is still SQL
2000. Are there huge differences in formats of dbs, tables, jobs, etc
or is it largely UI & feature enhancements?
There isn't a great deal of interation between the servers, but I would
like to be able to, for instance, continue exporting a nightly copy
down to my local server and it being useable without too having to
re-jig things too much.
Thanks for any help you can lend,
MickMick
I have installed on my pc sql server 2005 and linked/connected to sql server
2000 . By saying "nightly copy" dod you mean a backup of the database and
then restore in on local server. It is also possible.
<mick.hodgson@.gmail.com> wrote in message
news:1162982342.259348.291440@.m73g2000cwd.googlegroups.com...
> Hi,
> I was wondering what the issues I might face if I were to upgrade my
> local SQL server to 2005 while my remote hosting server is still SQL
> 2000. Are there huge differences in formats of dbs, tables, jobs, etc
> or is it largely UI & feature enhancements?
> There isn't a great deal of interation between the servers, but I would
> like to be able to, for instance, continue exporting a nightly copy
> down to my local server and it being useable without too having to
> re-jig things too much.
> Thanks for any help you can lend,
> Mick
>|||Thanks Uri,
It is a nightly DTS Export which copies the database objects down to
the local server.
Do you have the full 2005 database engine on your PC or just the client
tools? I need to know i can develop on a SQL2005 db and it will work
when uploaded to the SQL2000 db.
Thanks again!
Mick
Uri Dimant wrote:
> Mick
> I have installed on my pc sql server 2005 and linked/connected to sql server
> 2000 . By saying "nightly copy" dod you mean a backup of the database and
> then restore in on local server. It is also possible.
>
> <mick.hodgson@.gmail.com> wrote in message
> news:1162982342.259348.291440@.m73g2000cwd.googlegroups.com...
> > Hi,
> >
> > I was wondering what the issues I might face if I were to upgrade my
> > local SQL server to 2005 while my remote hosting server is still SQL
> > 2000. Are there huge differences in formats of dbs, tables, jobs, etc
> > or is it largely UI & feature enhancements?
> >
> > There isn't a great deal of interation between the servers, but I would
> > like to be able to, for instance, continue exporting a nightly copy
> > down to my local server and it being useable without too having to
> > re-jig things too much.
> >
> > Thanks for any help you can lend,
> > Mick
> >|||Mick
> Do you have the full 2005 database engine on your PC or just the client
> tools? I need to know i can develop on a SQL2005 db and it will work
> when uploaded to the SQL2000 db.
Yes, I do. Using DTS/SSIS to move the data is a headache ,epsecially
between 2000/2005.
Most likely to backup database on the sql server 2000 and restore on sql
server 2005
<mick.hodgson@.gmail.com> wrote in message
news:1162986618.135708.111690@.m7g2000cwm.googlegroups.com...
> Thanks Uri,
> It is a nightly DTS Export which copies the database objects down to
> the local server.
> Do you have the full 2005 database engine on your PC or just the client
> tools? I need to know i can develop on a SQL2005 db and it will work
> when uploaded to the SQL2000 db.
> Thanks again!
> Mick
> Uri Dimant wrote:
>> Mick
>> I have installed on my pc sql server 2005 and linked/connected to sql
>> server
>> 2000 . By saying "nightly copy" dod you mean a backup of the database
>> and
>> then restore in on local server. It is also possible.
>>
>> <mick.hodgson@.gmail.com> wrote in message
>> news:1162982342.259348.291440@.m73g2000cwd.googlegroups.com...
>> > Hi,
>> >
>> > I was wondering what the issues I might face if I were to upgrade my
>> > local SQL server to 2005 while my remote hosting server is still SQL
>> > 2000. Are there huge differences in formats of dbs, tables, jobs, etc
>> > or is it largely UI & feature enhancements?
>> >
>> > There isn't a great deal of interation between the servers, but I would
>> > like to be able to, for instance, continue exporting a nightly copy
>> > down to my local server and it being useable without too having to
>> > re-jig things too much.
>> >
>> > Thanks for any help you can lend,
>> > Mick
>> >
>

Local 2K5 server & Remote 2K server

Hi,
I was wondering what the issues I might face if I were to upgrade my
local SQL server to 2005 while my remote hosting server is still SQL
2000. Are there huge differences in formats of dbs, tables, jobs, etc
or is it largely UI & feature enhancements?
There isn't a great deal of interation between the servers, but I would
like to be able to, for instance, continue exporting a nightly copy
down to my local server and it being useable without too having to
re-jig things too much.
Thanks for any help you can lend,
MickMick
I have installed on my pc sql server 2005 and linked/connected to sql server
2000 . By saying "nightly copy" dod you mean a backup of the database and
then restore in on local server. It is also possible.
<mick.hodgson@.gmail.com> wrote in message
news:1162982342.259348.291440@.m73g2000cwd.googlegroups.com...
> Hi,
> I was wondering what the issues I might face if I were to upgrade my
> local SQL server to 2005 while my remote hosting server is still SQL
> 2000. Are there huge differences in formats of dbs, tables, jobs, etc
> or is it largely UI & feature enhancements?
> There isn't a great deal of interation between the servers, but I would
> like to be able to, for instance, continue exporting a nightly copy
> down to my local server and it being useable without too having to
> re-jig things too much.
> Thanks for any help you can lend,
> Mick
>|||Thanks Uri,
It is a nightly DTS Export which copies the database objects down to
the local server.
Do you have the full 2005 database engine on your PC or just the client
tools? I need to know i can develop on a SQL2005 db and it will work
when uploaded to the SQL2000 db.
Thanks again!
Mick
Uri Dimant wrote:[vbcol=seagreen]
> Mick
> I have installed on my pc sql server 2005 and linked/connected to sql serv
er
> 2000 . By saying "nightly copy" dod you mean a backup of the database and
> then restore in on local server. It is also possible.
>
> <mick.hodgson@.gmail.com> wrote in message
> news:1162982342.259348.291440@.m73g2000cwd.googlegroups.com...|||Mick
> Do you have the full 2005 database engine on your PC or just the client
> tools? I need to know i can develop on a SQL2005 db and it will work
> when uploaded to the SQL2000 db.
Yes, I do. Using DTS/SSIS to move the data is a headache ,epsecially
between 2000/2005.
Most likely to backup database on the sql server 2000 and restore on sql
server 2005
<mick.hodgson@.gmail.com> wrote in message
news:1162986618.135708.111690@.m7g2000cwm.googlegroups.com...
> Thanks Uri,
> It is a nightly DTS Export which copies the database objects down to
> the local server.
> Do you have the full 2005 database engine on your PC or just the client
> tools? I need to know i can develop on a SQL2005 db and it will work
> when uploaded to the SQL2000 db.
> Thanks again!
> Mick
> Uri Dimant wrote:
>