.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

recover datawarehouse in operations manager

Posted By:      Posted Date: October 07, 2010    Points: 0   Category :Sql Server


Here is the situation... I had to move my operations manager installation to a new server.

1- I stopped sql server and made a veritas back up of the databases and log files

2- I created a new server with the same name and OS and Sql specs (W2K Server / SQL 2005)

3- Reinstalled OpsMgr and installed reporting

4- Removed newly created warehouse and now attempting to put the original datawarehouse back in place but I am unable to attach it.  I get:


TITLE: Microsoft SQL Server Management Studio

Attach database failed for Server 'RUTILITY-2850'.  (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476


An exception occurred while executing a Transact-SQL statement or batch. (Mic

View Complete Post

More Related Resource Links

Error: "An exception occurred communicating with the Operations Manager RMS" when attempting to refr


I am trying to publish a vdw drawing that is connected to SCOM data to my SharePoint 2010 environment. I am able to successfully publish the file, but any refreshes result in this error:

"An exception occurred communicating with the Operations Manager RMS.  Please contact the administrator."

According to an article I read, there is the ability to enable trace logging for the data provider. I have attempted to enable logging by creating the file C:\Windows\assembly\GAC_MSIL\Microsoft.Office.Visio.Server.OperationsManager\\Microsoft.Office.Visio.Server.OperationsManager.dll.config, however, nothing is logged to the location specified when I perform refreshes (this config file was installed on all WFE's).

Here's the output of the SharePoint trace log:

11/03/2010 07:06:00.09 	w3wp.exe (0x1770)            	0x0F68	Visio Graphics Service    	Web Access          	9lob	Verbose 	Retrieving source data using addons	6742d572-403f-45a6-aa50-b60503711c73
11/03/2010 07:06:00.09 	w3wp.exe (0x1770)            	0x0F68	Visio Graphics Service    	Web Access          	9ln9	Verbose 	Registering addon data sources	6742d572-403f-45a6-aa50-b60503711c73
11/03/2010 07:06:00.09 	w3wp.exe (0x1770)            	0x0F68	Visio Graphics Service    	Web Access          	9lnn	Verbose 	Parsing data module connection string...	6742d572-403f-45a6-aa50-b60

Database creation for System Center Operations Manager 2007

I want to install System Center Operations Manager, and create the database in SQL Server 2008 R2 that is hosted on a different server, the problem is telling me that the version of SQL does not match the version that SCOM needed.
I tried putting SP1 and SQL 2008 SP2 to R2, but not let me.
It says that "The version of the instance of SQL Server Shared Component does not match the version expected by the SQL Server. The version of SQL Server product is installed 10.50.1600.1 and awaited version of SQL Server is 10.0.1600.22. "
I think it's the version of SQL.


How to Perform SQL Server Row-by-Row Operations Without Cursors

SQL cursors have been a curse to database programming for many years because of their poor performance. On the other hand, they are extremely useful because of their flexibility in allowing very detailed data manipulations at the row level. Using cursors against SQL Server tables can often be avoided by employing other methods, such as using derived tables, set-based queries, and temp tables

browser gives jibberish when State manager (sql) is turned on


Hi all, we're testing our web app with a state manager so that we can do distributed rollouts. We're not getting any errors, but we are getting jibberish returned for every page request. 

(it won't even let me paste it in here)

HOw do I get it to serve the pages normally?


Getting users list reporting to manager from LDAP


Dear All,

I need to get list of users reporting to a particular manager from the Active directory.

In the active directory there is manager property with contains the data in the following way.


Please help me in building the filter condition.

I am using the following

pUserName="Gegore Lid";

strSearch = "(&(objectClass=user)(objectCategory=user)((Manager cn=" + pUserName + "))";

DirectorySearcher dSearcher = new DirectorySearcher(dEntry, strSearch);

            //Account properites to load
            string[] arrPropertiesToLoad = { "displayName", "department", "manager", "sAMAccountName", "EmployeeNumber", "Title" };

          SearchResultCollection sResultColl = dSearcher.FindAll();

 the above code is not returning any result.

Please help me in this.



Getting list of users reporting from specific Manager from Active Directory


Dear All,

I am have requirement like displaying all the user information reporting to specific manager from Active Directory.

Please help me regarding this.



.NET Matters: Parallelizing Operations With Dependencies


In this month's installment, Stephen Toub examines some techniques for enforcing dependencies in the running order of asynchronous operations and builds a DependencyManagement class to help.

Stephen Toub

MSDN Magazine April 2009

ASP.NET Workflow: Web Apps That Support Long-Running Operations


Integrating workflow into ASP.NET applications means communicating with activities via a workflow queue and hosting the runtime in the global application class. We'll show you how.

Michael Kennedy

MSDN Magazine January 2009

Going Places: How Connection Manager Connects


Marcus Perryman explains the correct use of Connection Manager when a Windows Mobile application requires network data.

Marcus Perryman

MSDN Magazine December 2008

Concurrent Affairs: Asynchronous Device Operations


Jeff Richter uses the AsyncResult class to implement the CLR's Asynchronous Programming Model to perform hardware device operations asynchronously.

Jeffrey Richter

MSDN Magazine June 2007

Aero Glass: Create Special Effects With The Desktop Window Manager


In this article we introduce the Desktop Window Manager, the new interface that manages how windows are rendered on the Windows Vista desktop.

Ron Fosner

MSDN Magazine April 2007

.NET Matters: Restart Manager and Generic Method Compilation


This month Stephen Toub answers questions pertaining to the Windows Vista Restart Manager API and generic method compilation.

Stephen Toub

MSDN Magazine April 2007

Visual Studio 2005: Bridge the Gap Between Development and Operations with Whitehorse


Microsoft is introducing a new suite of tools (code-named "Whitehorse") that will make it easier for you to design and implement systems that conform to a service-oriented architecture. Two of these tools -- the SOA Design Suite and the Class Designer -- support the graphical design of systems and components with support for code generation and support for bi-directional synchronization which lets you ensure that your diagram always represents your system design. This article introduces these tools and shows you how they'll improve your design and development efforts.

Brian A. Randell and Rockford Lhotka

MSDN Magazine July 2004

Authorize It: Use Role-Based Security in Your Middle Tier .NET Apps with Authorization Manager


Authorization Manager in Windows Server 2003 represents a significant improvement in the administration of role-based security, making it more scalable, flexible, and easier to implement. Using Authorization Manager, you can define roles and the tasks those roles can perform. You can nest roles to inherit characteristics from other roles, and you can define application groups. In addition, Authorization Manager lets you use scripts to modify permissions dynamically, and it allows you to wrap your security logic in a security policy that can be stored in Active Directory. Authorization Manager also includes an easy-to-use API for running access checks. The author discusses all of these topics and demonstrates them with a working sample.

Keith Brown

MSDN Magazine November 2003

COM+: Create a Compensating Resource Manager to Extend Your App's Transactional Features


A Compensating Resource Manager (CRM) is any COM+ object that uses the CRM facility provided by COM+, a set of tools that make it simple to create a custom resource manager for business scenarios that require handling some non-database operation (such as generating a file) as part of a transaction. This article provides an overview of transaction processing, distributed transactions, and the two-phase commit protocol for transactions. Also covered are the implementation and configuration of a CRM.

Alan Gordon

MSDN Magazine March 2001

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