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


Post New Web Links

recover datawarehouse in operations manager

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

Hello,

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

------------------------------
ADDITIONAL INFORMATION:

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\1.0.0.1122__\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.

Marta

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?


Thanks!


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.

CN=Gegore Lid,OU=IT,OU=Sales,OU=XXXXX,OU=XXXX,DC=YYYY,DC=intra


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" };
            dSearcher.PropertiesToLoad.AddRange(arrPropertiesToLoad);

          SearchResultCollection sResultColl = dSearcher.FindAll();

 the above code is not returning any result.


Please help me in this.


Regards

Prakash



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.


Regards

Prakash


.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


Categories: 
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