.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

Database creation for System Center Operations Manager 2007

Posted By:      Posted Date: December 04, 2010    Points: 0   Category :Sql Server
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.


View Complete Post

More Related Resource Links

System center service manager



I have a task to create visual web part that creates simple request on System center service manager. Is there any code about that or references?


RibbonX API: Extend The 2007 Office System With Your Own Ribbon Tabs And Controls


If you want to create your own professional looking tabs and controls in Office, check out the RibbonX API of the 2007 Microsoft Office system.

Eric Faller

MSDN Magazine February 2007

Smarter Art: Create Custom SmartArt Graphics For Use In The 2007 Office System


SmartArt incorporates a gallery of templates and predefined shapes that can quickly be inserted and configured in your Microsoft Office documents. Find out how.

Janet Schorr

MSDN Magazine February 2007

SQL/MTS: Automating the Creation of COM+ Components for a Database Schema


Using Microsoft Windows DNA architecture as a guideline, it's possible to create scalable multitier database applications with COM+ and Microsoft Transaction Services. In fact, you can use existing table definitions to automatically build the MTS/COM+ business logic layer and data access components for your application. This article will walk you through the development of database transactions by mapping the transactions to automatically generated MTS/COM+ components. This technique can greatly simplify the task of creating components for a large project.

Aleksandr Mikunov

MSDN Magazine July 2000

unable to create new table in sql server 2000 enterprise manager on windows7(Operating system)

i have successfuly installed sql server 2000 on windows7 and i am able to browse all the tables and edit aswell(on enterprise manager) but i have a problem while creating new tables it says ' MMC has detected an error in a snap-in' and provides options to either continue with the error or send a report to microsoft ,   Please help regarding this compatibility issue   Thanks in advance !

Cannot connect Visio 2007 to SQL Server CE 3.5 database?

I am trying to reverse engineer a database (running under SQL Server CE 3.5 SP1) with Visio 2007 Professional.  I may be being blind, but I can find not way for Visio to do this.  Am I missing something or just piddling into the wind? Fully patched Vista. Thanks, Ed Bessant  

SQL Database Creation Path

Declare   @Path as varchar(500); Declare @mdfpath as varchar(500); Declare   @ldfpath as varchar(500); Set   @Path=(SELECT SUBSTRING(physical_name, 1,CHARINDEX(N'master.mdf',LOWER(physical_name)) -21) DataFileLocation FROM master.sys.master_files WHERE database_id = 1 AND FILE_ID = 1) set   @mdfpath=@Path+'\MSSQL.1\MSSQL\DATA\jjjj3.mdf'; set   @ldfpath=@Path+'\MSSQL.1\MSSQL\DATA\jjjj3_log.ldf';     CREATE DATABASE [jjjj3] ON PRIMARY ( NAME = 'jjjj3', FILENAME = @mdfpath , SIZE = 2048KB , FILEGROWTH = 1024KB )   LOG ON (   NAME = 'jjjj3_log', FILENAME = @mdfpath , SIZE = 1024KB , FILEGROWTH = 10%) The Above procedure creation error b'use of dynamic path of SQL, How to select Dynamic path to file name Thanks K. Govindaraj

Cannot crawl sharepoint site and mysite after database attach upgrade form sharepoint 2007 to 2010.

After database attach upgrade site and mysite from sharepoint 2007 to 2010 , I have full crawl and get "The crawler could not communicate with the server. Check that the server is available and that the firewall access is configured correctly. If the repository was temporarily unavailable, an incremental crawl will fix this error. ( Error from SharePoint site: HttpStatusCode ServiceUnavailable The request failed with HTTP status 503: Service Unavailable. )" for mysite and get "Access is denied. Verify that either the Default Content Access Account has access to this repository, or add a crawl rule to crawl this repository. If the repository being crawled is a SharePoint repository, verify that the account you are using has "Full Read" permissions on the SharePoint Web Application being crawled." for sharepoint site. The content access account for search is "db_owner" of both of site and mysite. How do I solved this problem ?

SharePoint Capacity Planning Tool and system Center Capacity Planner

Hi, It seems like we cannot use the SharePoint Capacity Planning Tool anymore. I downloaded this SharePoint Capacity Planning Tool but its prerequisite system Center Capacity Planner(SCCP 2007) has been discontinued, as per this URL, http://technet.microsoft.com/en-us/systemcenter/ff575746.aspx  So when I try to install SharePoint Capacity Planning tool, it ask me to install SCCP V2 first. Please share if somebidy has a copy SCCP V2 or do we have any other alternate tool that can be used for SharePoint Capacity planning? Thanks, San      

Access Database from another system..

I am using SqlExpress 2008, I have created a instance named "INSTANCEA" in one system as windows authontification mode and sql server authentification mode..  Its working well... But I can't access my instance from another system... while accessing the instance i have got the following message.... Cannot connect to NODEA\INSTANCEA. ------------------------------ ADDITIONAL INFORMATION: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 28 - Server doesn't support requested protocol) (Microsoft SQL Server, Error: -1)

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? 

Hide system database in SQL Management Studio

I am using SQL server 2008 . What i all want is to create a uses that can only see the ABCDatabase in Management studio onced login. And to achieve that:1- I have created a new user.2- Deny View all database right to that user.3-Set that user as Owner of ABCDatabaseNow on login that user cannot see other databases but still able to see the system databases. How can i hide those system databases from that user?

need a simple login page cus my hosting provider system wont allow me to have more than one database

I dont really write html code too well  but I manged to get my web site developed and deployed using the built in features such as drag n drop, master page and user account authentication that make web developing almost a codeless experience. However; my hosting provider system wont allow me to have more than one database, this causes problems becasue when I developed my web app using vb2010 web developer (asp.net v2) I used the built in web config tool to manage users for my site, now after I deployed to my domain it all worked ok with the exeption of the login page, when I tried to log in the system threw a error message saying "database not found." or a page of "gobble-dee-gook" that says the same thing When I contacted support (my hosting provider) they said i have to create a table of users in my database file via 2008 sql server, thats ok I can do that, but my real problem is I dont know how to write appropriate code to reference the table. So heres my problem:  I just want to have some kind of login page with a couple of txtboxes and a click button that maybe using the VB code behind or html checks the input variables "username" "password" against something that is hard coded into vb a string variable or a constant and then branches to Mainmenu.aspx if successfull. I just need it real simple, no fancy stuff just a login s

Attaching the Config Database in SharePoint 2007 with STSADM

Hello, We've moved our MOSS 2007 dev environment SQL database to a new server and we're having trouble attaching the config database to SharePoint using stsadm so we can access central admin. Here is the command we're running: stsadm -o setconfigdb -connect -databaseserver kraspsqltest\mosstest -databasename wss_config -farmuser "farmaccountname" -farmpassword "farmpassword" When I run this command (obviously with the correct username and password), the only message I see is: Access denied. I've checked with our DBA and nothing on his end is blocking the command. I do see the following in the event log where the command is being run: "Unknown SQL Exception 10061 occured. Additional error information from SQL Server is included below. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.)" I've also noticed the folder containing the web.config file in IIS is no longer present on the MOSS server. Is this deleted when the config database is detached and added back when reattached? This server was working just fine prior to the database move

How to configure Sharepoint 2007 Reporting Services 2005 with NLB sharing same RS database

Hello, I'm trying to configure RS using two FE and a single SQL database in sharepoint integrated mode. At first i was getting an error about version of reporting server wouldnt support scale-out configuration, so i upgraded RS Instances in both FE's to 2005 Ent Ed. and re-installed sharepointRS_Addin in both FE servers and successfully initialized both with the reporting services configuration tool. after successfully granted database access to both FE's using CAS.  if i browse to                    http://WFE1:port/ReportServer/                    or                    http://WFE2:port/ReportServer/                    the database content is listed in browser.   if i browse to:                    http://NLB-sitename:port/ReportServer                    the database content gets listed also, tho it seams to list random conten

When attempting to install Security Update Microsoft for the Microsoft 2007 Office system updates (u

When attempting to install "Security Update Microsoft for the Microsoft 2007 Office system updates (updates KB2277947 and KB982331)" the sintallation fails and then I recieve the error "The detection failed, this can be due to a corrupted installation database". System Info: XP Home Edition Version 2002 Service Pack 3 Intel Atom CPU N270 @ 1.60 GHz I am running XP and have installed and run the "Fit It" tool, to no avail. I even tried downloading each update individually, from the Microsoft site, instead of through the automatic update. I also read this same question posted by another user (link: http://social.technet.microsoft.com/Forums/en-US/sharepointadmin/thread/cfa66cd3-2aa2-44ee-9393-ffae41d4f70c/) only to find his info contained no answer either. How do I fix this so that I can get these updates installed?

what is the better design for location of system database data / log files and user data/log file,

is there a guideline for better performance for system database data location log location, like tempdb location etc. also better location for user databases/data and log.
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