.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Unable to Backup Service Master Key on SQL 2008 Express

Posted By:      Posted Date: September 06, 2010    Points: 0   Category :Sql Server
Hi I am attempting to do a backup of the Server Master Key but it fails. The error message I am receiving is as follows: Msg 15240, Level 16, State 1, Line 1 Cannot write into file 'C:\Users\harvey norman\Documents\SQL Server Management Studio Express\SQLEXPR2008ADV_ServerMasterKey'. Verify that you have write permissions, that the file path is valid, and that the file does not already exist. The PC I am running SQL 2008 Express (64 bit) is running on Vista Ultimate (64-bit) SP2. The SQL I wrote is as follows: BACKUP SERVICE MASTER KEY TO FILE = 'C:\Users\harvey norman\Documents\SQL Server Management Studio Express\SQLEXPR2008ADV_ServerMasterKey' ENCRYPTION BY PASSWORD = '??' GO Note that the ?? represents the password but is not actually the password for obvious reasons. I am logged in to the PC as a user with Admin permissions.  I had a look at the destination folder, and it shows I have full control. So, I am mystified. If somebody could advise me I would really appreciate it. Many thanks in advance. Kind regards Ross Ross

View Complete Post

More Related Resource Links

Unable to install SQL Server 2008 Express R2 after installing .NET 4.0

Hi experts, I intend to redistribute SQL Server 2008 Express R2 in my installer. I've extracted the setup files from SQLEXPR32_x86.exe and pass in the appropriate command line parameters during the setup. Recently, I noticed if I applied the following Windows Update: .NET 4.0 Client Profile, I will hit into the following error when I installed SQL express. .NET Runtime 4.0 Error Reporting EventType clr20r3, P1 setup100.exe, P2 10.50.1600.1, P3 4bb67524, P4 mscorlib, P5, P6 4ba1da6f, P7 44f0, P8 32, P9 system.security.security, P10 NIL. .NET Runtime Application: setup100.exe Framework Version: v4.0.30319 Description: The process was terminated due to an unhandled exception. Exception Info: System.Security.SecurityException Stack: at Microsoft.SqlServer.Chainer.Setup.Setup.DebugBreak() at Microsoft.SqlServer.Chainer.Setup.Setup.Main() Running the setup.exe from a file server will give these errors but if I copied the entire setup files to a local folder and run setup.exe from there, it runs fine. May I know what am I missing? I definitely need to support to install SQL express running from a file server location. Thanks, MK  

SQL Server 2008 express SQL Server Service won't start

Could really use some help. Am running XP Pro SP3.  Had 2005 Express running fine previously.  Installed 2008 Express but cannot get the SQL Server service to start.  SQL Server Agent does start though.  In log (below) it seems to be trying to access an E:\ drive that doesn't exist (did default install to C:\Program Files) - plus other issues.  Have 5gig+ free, so not sure why it's saying not enough space.  Have RTFMd the problem for a whole day with no luck.  Any advice much appreciated.   Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86)  Apr  2 2010 15:53:02  Copyright (c) Microsoft Corporation Express Edition with Advanced Services on Windows NT 5.1 <X86> (Build 2600: Service Pack 3) (Hypervisor)   Error: 17054, Severity: 16, State: 1. The current event was not reported to the Windows Events log. Operating system error = 1502(The event log file is full.). You may need to clear the Windows Events log if it is full. (c) Microsoft Corporation. All rights reserved. Server process ID is 4988. Authentication mode is WINDOWS-ONLY. Logging SQL Server messages in file 'c:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\Log\ERRORLOG'. This instance of SQL Server last reported using a process ID of 3232 at 9/4/2010 9:36:12 AM (local) 9/4/2010 1:36:12 PM (UTC). This is an informational

Unable to start SQL Express 2005 service as a network user

I am trying to start ms sql server 2005 express as a network user from originally starting as local system. I cannot start the service.I have given this network user administrator access to sql express from the sql server surface area configuration "Add New Administrator". I have went into the local users/groups and added this network user to the 3 security groups SQLServer2005MSSQLServerADHelperUser$SQL1SQLServer2005MSSQLUser$SQL1$SQLEXPRESSSQLServer2005MSSQLBrowserUser$SQL1I receive one alert int he event logs/applicationEventID: 26010The server could not load the certificate it needs to initiate an SSL connection. It returned the following error: 0x8009030d. Check certificates to make sure they are valid.I receive five errors in the event logs/applicationEventID: 26014Unable to load user specified certificate. The server will not accept a connection. You should verify that the certificate is correctly installed. See "Configuring Certificate for Use by SSL" in Books Online.EventID: 17182TDSSNIClient initialization failed with error 0x80092004, status code 0x80EventID: 17182TDSSNIClient initialization failed with error 0x80092004, status code 0x1EventID: 17826Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately prceding this one in the error log.EventID: 17120SQL Serve

Does SQL Server 2008 R2 Express Reporting Service support Shared Datasets?

I have spent a few hours trying to get this to work. I am using Report Builder 3.0 (locally), with SQL Server 2008 R2 Express Edition on a remote web server. I am running Report Builder as an Admin under Win7 64bit. All is OK until I attempt a Save of a newly created shared dataset. The error message is: Failed to save dataset "mydataset.rsd" The feature "Shared dataset" is not supported in this edition of Reporting Services. Details: The feature: "Shared dataset" is not supported in this edition of Reporting Services. ---> Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedException: The feature: "Shared dataset" is not supported in this edition of Reporting Services. I have researched the web, and the list of features for Express Edition does not list this feature as not being supported, although it does list "Shared component library" as being missing. Could anyone please confirm the situation please. If it is  a bug, is there any fix or workaround?  John Walton  

SQL 2008 Express with Reporting Service

My internal url for reporting service works on my SBS 2003 server, but I cannot access this url via the internet. Could anyone help?

SQL Express 2008 R2 - CREATE DATABASE permission denied in database 'master'. (Microsoft SQL Serve


So, we have an application that we've written to leverage SQL Express 2008 R2 - which our setup installs on the command line using the following instructions:


The code that does the installation can be found here:


//Path to the SQL Installation files 

string strSQLPath = Application.StartupPath + "\\Install_Support_Files\\SQL_86\\Setup.exe"; 

//If we're on a 64-bit OS use the 64 bit setup

if (Wow.Is64BitOperatingSystem == true)


strSQLPath = Application.StartupPath + "\\Install_Support_Files\\SQL_64\\Setup.e

File system permission error during BACKUP service master key



I'm having a strange issue with file system permissions.

A backup database to file location e:\sqlbackup works fine.
A BACKUP SERVICE MASTER KEY or BACKUP MASTER KEY fails with the error ´MSG 15240, Level 16, State 1 Cannot Write into file ´e:\sqlbackup\file.bak' Verify that you have write permissions, etc...'

What am I missing?


Unable to upload report file to SSRS 2008 R2 Express

I'm attempting to upload a report file into an instance of SQL Server 2008 R2 Reporting Services (Express edition), and I'm having difficulty. While I can do things like create folders and manage security, I am unable to upload a report definition (.rdl) file from either the web console or via the ReportService2005.asmx web service. Both avenues eventually time out and generate a 401 error (though I am not sure that this 401 is legitimate, as it takes over a minute and a half to generate the error).

This instance is running the web services on a non-standard port (8080) in HTTP (not HTTPS) mode, as it's on a Windows XP Pro machine with an existing website on IIS.

I have looked at the report server access log, and this appears to happen when it errors out:

    rshost!rshost!380!10/13/2010-14:39:10:: e ERROR: ReadCallback(): failed to read in read callback.
    rshost!rshost!380!10/13/2010-14:39:10:: e ERROR: Failed with win32 error 0x03E3, pipeline=0x016F8D48.
    rshost!rshost!244!10/13/2010-14:39:10:: e ERROR: HttpPipelineCallback::ReadEntityBody(): failed reading data.
    rshost!rshost!244!10/13/2010-14:39:10:: e ERROR: Failed with win32 error 0x03E3, pipeline=0x016F8D48.

Backup sqlserver 2008 express in VS2010



i serach for back up of data base from code in my wpf application

i find many article but that wasent complate ,


how can i craete backup from sqlserver 2008 express in VS 2010


SQL Express 2008 R2 service cannot log on


I just installed SQL Express 2008 R2 on an hp computer running Windows 7. The install reported no errors but when I configured the database service

log on I selected the log on to use my account (has Administrator privileges) and password. When I try to start the service I get the message "The parameter is incorerect. (0x80070057). Any advice will be appreciated.

Sigsby Rusk

SQL Express 2008 R2 - CREATE DATABASE permission denied in database 'master'


I have created a setup application with SQLEXpress 2008 as a prerequisite. On test SQLExpress installs OK

after the application is installed it must create and install a database using a mixture of SMO and Scripting. I used SMO to add the current user (who is a Windows Administrator) as a Login to the SQL Express server.

Dim l As Login = New Login(srv, My.User.Name)
                l.LoginType = LoginType.WindowsUser
                l.DefaultDatabase = "MASTER"

It fails on srv.CreateDatabase with error message "permission denied in database MASTER"

this thread talks about converting the server to single user mode before adding a login


how is it possible to scrip this? there is no&nbs

Backup and Restore SQL Express 2008 database


Hi All,

How can backup and restore SQL Express 2008 database using c#.net

Thank you


Unable to login to express 2008 remotely

I am using mssql express 2008 on a remote server.  I can VPN into the server and log on via my local account (Michael) with the appropriate password in either Windows mode or SQL mode.  I cannot log in from my remote client which is VPNed in.  The error is "Password mismatch".  I have set the user password for 'Michael" on the server as well as on the local machine but still no luck.  Where is the password that it is attempting to match?

Data Cleansing in SQL Server 2008 R2 Master Data Service

Does Master Data Service has some in built mechanism to deal with cleansing of data? Or, is there some cleansing service available that works with SQL Server 2008 R2 Master Data Services?

IIS7 access rights to SQL Express 2008 (both use Network Service)



I have IIS7 and SQL Express 2008 running on Windows Server 2008.  IIS7's application pool that my app belongs to is configured for Network Service account.  The SQL Server also uses the same account.  I noticed that MS no longer discourages use of Network Service account for SQL 2008 (as it used to for 2005).

In IIS5 I used to give ASPNET account selected rights to my app's database.  With IIS7/SQL 2008 - both using the same Network Service account - giving access rights to the database does not seem to be necessary.  All app's running in the pool that uses Network Service account have full access to all resources in the database.

Is this expected?  If yes, what are the risks?



Unable to install Microsoft SQL Server 2005 Express Edition Service Pack 4 (KB2463332)


I am not a techie but have been unable to install the update above.  I don't know how to look at registry keys, etc.  Is there an easy fix to this problem?  Does it really matter if this update is installed?

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend