|
  |
|
|
Solving a SQL Express Restore Failed Issue
After installing SQL Express and trying to restore a SQL Server 2000 database to a new database I got the following error: Restore failed for Server 'SERVERNAME\SQLEXPRESS'. (Microsoft.SqlServer.Express.Smo)
The full error was:
System.Data.SqlClient.SqlError: The operating system returned the error '5(Access is denied.)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATABSENAME.MDF'. (Microsoft.SqlServer.Express.Smo)
This problem occurers if the SQL Express service is running as NT AUTHORITY\NetworkService. To fix it uses the Services option in the Control Panel to change the service to run as the local system account. After that restart the SQL Server and the restore should work properly. |
PLEASE VISIT THE CONTRIBUTOR'S WEBSITE
No reactions yet.
Please login or sign up to rate this intel.
Please login or sign up to add a comment.
The copyright for this content entitled "Solving a SQL Express Restore Failed Issue" has been specified by the contributor as:
Public Domain
The copyright for this content has been relinquished by the author. The content may be used freely by anyone.
|
 |
May, 2012
2008
January, February, March, April, May, June, July, August, September, October, November, December
2009
January, February, March, April, May, June, July, August, September, October, November, December
2010
January, February, March, April, May, June, July, August, September, October, November, December
2011
January, February, March, April, May, June, July, August, September, October, November, December
2012
January, February, March, April, May
|
|
Not a member yet?
Qondio is a powerful network for making it online. If you have a website to
promote, we can help.
Sign up and get in on the action.
|
|
Welcome to Qondio! Discover the awesome power this network can deliver by going to our About page. Or you could skip straight to the Sign Up form.
|
|
