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

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

Cannot rebuild system databases in 2008R2

Posted By:      Posted Date: September 01, 2010    Points: 0   Category :Sql Server
I'm trying to rebuild system databases, but after installing 2008 R2, this no longer work. Here is what I do: I open a command prompt in the below folder: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\SQLServer2008R2 Here, I execute: SETUP /ACTION=REBUILDDATABASE /INSTANCENAME=a /SQLSYSADMINACCOUNTS=TK\Tibor /SAPWD=Pa$$w0rd /Q I get below error in the console window: The following error occurred: Exception has been thrown by the target of an invocation. Error result: 1152035024 Result facility code: 1194 Result error code: 43216 Please review the summary.txt log for further details There is no trace of the rebuild in the summary.txt file. A folder *is* however created in the log directory for the rebuild (20100601_163136), and in here I have a file named Detail_ComponentUpdate.txt. In this file, I can find below errorr, which I believe is the root of the problem. Can anybody else perform rebuild? Any ideas or hints? 2010-06-01 16:32:04 Slp: Running Action: ExecuteInitWorkflow 2010-06-01 16:32:04 Slp: Workflow to execute: 'INITIALIZATION' 2010-06-01 16:32:04 Slp: Error: Action "Microsoft.SqlServer.Configuration.BootstrapExtension.ExecuteWorkflowAction" threw an exception during execution. 2010-06-01 16:32:04 Slp: Microsoft.SqlServer.Setup.Chainer.Workflow.ActionExecutionException: Exception has been thrown by the target of an invocation. ---> System.

View Complete Post

More Related Resource Links

need help moving System Center SQL Databases to new SQL Server about30 databases to be moved...

We are running various System Center products, SCSM, SCVMM, SCCM, DPM, OPALIS. and a few other servers all using the same SQL server, which currently is a VM. We have configured and built a new Physical box that will replace this. In the past we have moved SQL databases by doing a full backup and then restoring the backup on the new server, then renaming the servers, both network name and internal sql name.  This has worked fine in the past. However I've never had to move 30 databases before, nor have I had to move reporting services. Is there a better method. a recomended method? 

"NT AUTHORITY\SYSTEM" access - to which databases/actions and why?

Subquestion from the question Purpose of "NT AUTHORITY\SYSTEM" login in SQL Server 2005 discussing removal of NT AUTHORITY\System from SysAdmin group in MS SQL Server 2005. Is my SQL Server 2008 R2 "NT AUTHORITY\SYSTEM" login is mapped (right click on --> Properties --> User Mapping) to: user dbo for db AdvenureWorks user "NT AUTHORITY\SYSTEM" for databases - maser - msdb - ReportServer - ReportServerTempDB But no mapping exists for databases tempdb model any manually new created database AdvenureWorks2008 AdvenureWorks2008R2 AdvenureWorksDW AdvenureWorksDW2008 AdvenureWorks2008R2 AdvenureWorksLT AdvenureWorksLT2008 AdvenureWorksLT2008R2 Why such mapping was created for AdvenureWorks but not all other sample databases and newly created databases? Why does ReportServerTempDB requires mapping but not tempdb?

Error While Rebuilding system databases

Hi, I installed my SQL Server with a wrong collation. I tried to rebuild the instance and when i tried doing that I am getting a weird error as given below. ALso the installation is picking the edition as evaluation instead of enterprise, i tried executing the install file and it went through to install a enterprise edition. I am not sure why the installer is picking up the evaluation edition instead of enterprise as the option is set.  Exception summary: The following is an exception stack listing the exceptions in outermost to innermost order Inner exceptions are being indented Exception type: Microsoft.SqlServer.Setup.Chainer.Workflow.NoopWorkflowException     Message:          The state of your SQL Server installation was not changed after the setup execution. Please review the summary.txt logs for further details. SugeshKumar SQL Server MVP http://sugeshkr.blogspot.com

Cluster SQL 2005 SP3 (system databases)


Hello All !

I have a MSCS cluster Windows 2003 Ent SP2 R2 (2 nodes en Active / Passive) and I install SQL 2005 SP3. I need to install 2 MS SQL Server instances on this cluster.

I have volumes shared disks: - Q for Quorum, M for MSDTC, L for logs, S for Datas, T for TempDB, X for Indexes

I want to put system databases on Y.

I have a doubt:

I have 2 SQL instances (ISQL1 and ISQL2), do I need a separate volume for the system DBs (master, model, msdb, tempdb) per instance?

or  do I need one volume for all the system DB (Y) for the 2 instances?

Thanks for advance for your ideas / help - Regards - Have a nice day ! RHUM2

System databases corrupt recovery?


For SQL2K5, If I have for ex. Master or msdb got corrupt/suspect and I need to restore the entire database system? what are the steps I need to follow? If I have a two weeks old master, msdb can I use that and keep all current databases? or I need to restore two week old sytem dbs and all those corresponding user databases two weeks ago?

Please provide steps and how do I recover (using admin console, etc)?


Restricting access to System Databases for Windows User


Hi All,

     I was asked to provide access to windows user for only User databases in server. I added this user to db_reader role in all databases after creating login in Server. But here is the problem, this user can able to access System databases even I have n't assign any role for this login in system databases. Your response will be helpful  to fix this . Please let me know if I am missing here to understand it.





Getting server non system databases, getting database tables, getting table columns


I use next code to get server databases

string connectionString = "Data Source=DENIS\\SQLEXPRESS;Integrated Security=SSPI;";
DataTable tables = new DataTable("Tables");
using (SqlConnection connection =
    new SqlConnection(connectionString))
  SqlCommand command = connection.CreateCommand();
  command.CommandText = "sp_databases"; 
  command.CommandType = CommandType.StoredProcedure;


this.dataGridView1.DataSource = tables;

I've got many databases :

- model ( i guess it is system )

- master ( i guess it is system )

- tempdb ( i guess it is system )

- db1 ( my table )

and etc.

How to determinate what table is system.



FROM information_schema.Tables

So how to determinate what table is system or not.

Can I get tables of database

Cant move system databases of SQL Server 2008 (Clustered) running in Windows 2008 with Service SID e



I was trying to move system databases of SQL Server 2008 on clustered emvironment running on Windows 2008.

I remember while doing the cluster installation somewhere it gave me a recomended option of using Service SID. I think that is the culprit here. Because if you see the "Security" of the DATA folder containing all the MDF and LDF (by default location) you will find a Group named "MSSQLSERVER" is having full access to that directory.

While moving the system databases you need that account (MSSQLSERVER) given access to the parent directory containing the MDF and the LDFs, But unfortunately you cannot add that account manually. Even I tried XCOPY to make sure that while copying the ACLs gets transferred properly to the destination, even that failed.

I think it does provide a solid Security but at the expense of Maintenance, which I cant agree.

Also I forgot to tell you that this Sevice SID option is available if you are using Windows Vista / Windows 2008 or above,

Does anyone has any experience of moving the system databases with Service SID enabled in a cluster environment.

As a testing just try to copy/xcopy/robocopy any folder having MSSQLSERVER group in the ACL and see what happens .. If you are lucky like me then you will get ACCESS DENIED error.

Have anyone faced the same error? I h

System Development Life Cycle

The Systems Development Life Cycle (SDLC) is a conceptual model used in project management that describes the stages involved in an information system development project from an initial feasibility study through maintenance of the completed application. Various SDLC methodologies have been developed to guide the processes involved including the waterfall model (the original SDLC method), rapid application development (RAD), joint application development (JAD), the fountain model and the spiral model. Mostly, several models are combined into some sort of hybrid methodology

The Agile System Development Life Cycle (SDLC)

The goal of this article is to describe the agile system development life cycle (SDLC), putting it in context from what you may have heard about within the agile community and more importantly within the context of your overall IT efforts.

Performance Tests: Precise Run Time Measurements with System.Diagnostics.Stopwatch

Everybody who does performance optimization stumbles sooner or later over the Stopwatch class in the System.Diagnostics namespace. And everybody has noticed that the measurements of the same function on the same computer can differ 25% -30% in run time. This article shows how single threaded test programs must be designed to get an accuracy of 0.1% - 0.2% out of the Stopwatch class. With this accuracy, algorithms can be tested and compared.



hello i have the following problem

i have upload my content to hosting server but i get the following error

Security Exception

Description: The application attempted to perform an operation not allowed by the security policy.  To grant this application the required permission please contact your system administrator or change the application's trust level in the configuration file.

Exception Details: System.Security.SecurityException: Request for the permission of type 'System.Web.AspNetHostingPermission, System, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SecurityException: Request for the permission of typ

Problem upgrading to MVC3 - System.Web.Routing



I'm trying to upgrade to .NET 4 and MVC 3.

When trying to compile my project, I get the error:

Error 1 The type or namespace name 'Routing' does not exist in the namespace 'System.Web' (are you missing an assembly reference?) C:\Users\spencer\Desktop\weblauncher\Common\MVCConfig.cs 4 18 Common

The type or namespace name 'Routing' does not exist in the namespace 'System.Web' (are you missing an assembly reference?)

I do have the System.Web.Routing in my references for the project.

BUT - when I try to view System.Web.Routing in the OBJECT BROWSER, nothing is inside!  The System.Web.Routing namespace is not in there - the entire thing is empty!  Could it that the dll is corrupted?  I tried to reinstall the .NET 4 and MVC 3 stuff, but its still empty!

The dll is coming from here:

C:\Program Files (x86)\Reference Assemblies\Microsoft\Framework\.NETFramework\v4.0\System.Web.Routing.dll

and the runti

System.Security.SecurityException: Request for the permission of type 'System.Web.AspNetHostingPerm


Good Day all,

Having an issue with an outside user accessing my IIS7 box. I do not have this problem when running the website from my host machine. I found this post: Http://forums.asp.net/t/1371394.aspx. I assure you that this is not a solution because I am not storing any of my files on a network share. 

What do you think my approach should be. 

I already have read rights to IIS user to my BIN folder. 

Thanks for the help. 

System.IO.Packaging is not visible


I am new to ASP.net, I installed VS2005 and IIS 5 on my PC and set up my first website using IIS (not the embedded webserver in VS).

For some reason I cannot find the Assembly: "System.IO.Packaging", please let me know if I am allowed to use it in that medium and how can I reference it?

Thanks in advance.

how i can install sql server in my system


which edition of sql server  are best for me  Developer edition or express editon for development purpose.

i try to install last time sql server in my system but not successful so what i do for get the sql server in my system.

The type 'System.Data.Linq.DataContext' is defined in an assembly that is not referenced. You must



This is frustrating, and I don't know how to solve it.

I have a strange problem. I am adding a LinqDatasource object, and set the context:

        protected void LinqDataSource_ContextCreating(object sender, LinqDataSourceContextEventArgs e)
            e.ObjectInstance = new KaruselaDataContext(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);

Then I get this error:
The type 'System.Data.Linq.DataContext' is defined in an assembly that is not referenced. You must add a reference to assembly 'System.Data.Linq, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089'.


On web.config I already have this:
<add assembly="System.Data.Linq, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>

NOTE: The datacontext is in a different project (DLL proect) where I added a refernce to System.Data.Linq.

is there another way adding a refernce to a web project? or only though teh web.config?


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