NT AUTHORITY\NETWORK SERVICE' is absent please help

Question

0.00/5 (No votes)

See more:

Please please Please help me on this ......

I want to restore MSSQL database backup in Parallels Plesk Panel .

Steps i did .

1) Created a new database
2) Uploaded the database Backup
3) Restoring the backup to the database .

Each time i get the same error message

Error: dbbackup failed: Unable to restore database 'ptPropMgmtDB'
Terminating this procedure. The User name 'NT AUTHORITY\NETWORK SERVICE' is absent or invalid.

Posted 29-Sep-11 1:16am

rajkumar9867

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mehdi Gholam · Answer 1 · 2011-09-29T03:21:00

Solution 1

I'm assuming you are trying to restore a database in a hosted environment (with your reference to Parallels Plesk Panel).

Contact your host support and get more information on how to restore your database, as they probably can help you more.

Posted 29-Sep-11 3:21am

Mehdi Gholam

Justin Porteous · Answer 2 · 2011-09-29T04:01:00

I found in this case the DB has metadata which the plesk software uses.

Try using a DB that originates from the server... Try this:

1. Create a blank DB on the hosting control panel (empty)
2. Backup and download
3. Restore locally and add required tables, procs and data
4. Backup and upload
5. Restore via plesk

NB: User the same username on the hosting as you do locally.
if you encounter issues with user not having access, google "orphaned sql users".