local system privildges - Microsoft SQL Server

Prashant Thakwani

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.

Jul 20 '05 #1

Subscribe Post Reply

1650

Simon Hayes

th******@rediffmail.com (Prashant Thakwani) wrote in message news:<bf**************************@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

Jul 20 '05 #2

Similar topics

local system privildges

by: Prashant Thakwani | last post by:

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

Microsoft SQL Server

How to translate from UTC/GMT time to local time?

by: Randall Parker | last post by:

Suppose one has a database of UTC times that are from different dates in the past. The problem with translating those times to a local time is that one does not know for each UTC time whether the...

C# / C Sharp

Window Services - Difference between Network Service, Local Service ANd Local System Account

by: ABCL | last post by:

Hi All, Can any one tell me that what is the difference between Network Service, Local Service and Local System ACcount for window services ABCL

C# / C Sharp

Adding Local Users to Local Groups

by: enilno | last post by:

I'm working on a C# app., and I need to programmatically add a local user to a local group on the computer on which the app. is running. When end-users run this app., they will be logged on as...

C# / C Sharp

Logon errors for local account appear on DC

by: robpimentel | last post by:

Hi, I've been using DB2 for about 1 week, so please bear with me. DB2 Connect Enterprise Edition v8.1 FixPack 5 Windows Server 2003 Standard Edition SP1 Here is an error that continues to...

DB2 Database

HELP: Cannot get network and local printers on the web server.

by: lmttag | last post by:

ASP.NET 2.0 (C#) application Intranet application (not on the Internet) Using Windows authentication and impersonation Windows Server 2003 (IIS6) Server is a member server on a domain Logged...

ASP.NET

publishing Hello World to local IIS

by: cj | last post by:

Perhaps someone knows how to do this. When I open a new ASP.NET web service application in VS 2008, it opens with a simple Hello World web service already written. I want to see this work. ...

.NET Framework

Setting local namespace in xaml file

by: DeanB | last post by:

Please excuse my ignorance here as I have not used WPF for long, but what is the statement that tells what the "local:" identifier is that allows a window event to call a function in a .cs file? ...

C# / C Sharp

Get data from Local Web.config not machine.config

by: =?Utf-8?B?SmVycnkgQw==?= | last post by:

I have a app that uses several membership/role providers. I can list these Providers with the code: Dim rootWebConfig1 As Configuration rootWebConfig1 =...

ASP.NET

How do you load a local file as a source for a bitmapImage stored in an array

by: martinsmith160 | last post by:

Hi everyone I am trying to create a simple wpf program that allows a user to select an image from a combo box and then where they click on th screen draw that image at the mouse co-ordinates. The...

C# / C Sharp

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing