No report builder models are available. To use Report Builder, at leasetr one model must be published to the report server

Most have you will have clicked on the ‘Design a new report’ button and found that there were ‘No Data Sources available’.

Here is how you can setup this feature for SCOM 2007.

CREATE A REPORT MODEL

1. Open SQL Server Business Intelligence Development Studio
2. Click File -> New -> Project
3. Select Report Model Project
4. Fill in a Name and Location
5. Click OK

CREATE A DATA SOURCE

1. In Solution Explorer, right-click Data Sources, Click Add New Data Source

2. Click Next on the Welcome Screen
3. Click New
4. Fill in the connection to the SQL Server and Instance (ie: SERVER\INSTANCE) to your SCOM Database
5. Select the Database you want to interact with. (ie: OperationsManagerDW)

6. Click OK
7. Click Finish

You will now see the Data Source under Solution Explorer

CREATE A DATA SOURCE VIEW

1. In Solution Explorer, right-click Data Sources, Click Add New Data Source View
2. Click Next
3. Select the data source from the Relational data souces: panel
4. Click Next
5. This is the part where you need to think, You will need to select the tables and views you want to include in the model. If you not sure and just want to play around you can however I would not suggest it… but you can sellect all the tables, however leave the views out as they can cause issues.
6. Click Next
7. Click Finish

You will now see the Data Source View under Solution Explorer

CREATE A REPORT MODEL

1. In Solution Explorer, right-click Data Sources, Click Add New Report
2. Click Next
3. Select the Data Source and Click Next
4. Select the Model Rules and Language (If unsure, keep the defaults) Click Next
5. Select Update model statistics before generating and Click Next
6. Type in a name Name and Click Run

Note: This may take some time depending on the number of Tables and Views selected when creating the Data Source View.

7. Click Finish
8. Under Solution Explorer Right-Click the new Report Model and selct Deploy

9. Exit SQL Server Business Intelligence Development Studio and Save.

RUN DESIGN A NEW REPORT

1. Open System Center Operations Manager Console
2. In Report Click Design new report
3. Report Builder will launch and you will see a Data Source
4. Highlight it and Select a Report Layout Click OK

Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\ReportServer\RSReportServer.config' is denied

The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError)
Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\ReportServer\RSReportServer.config' is denied.

Solution:

1. Right click RSReportServer.config file
2. GO to Properties
3. Click Security tab
4. Click Add button
5. Type "Network Service" and select "Location" as local PC.
6. Click "Check Names" button
7. Click OK; OK and you it should work now.

Server Error in '/ReportServer' Application.

Configuration Error

Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: An error occurred loading a configuration file: Access to the path 'c:\inetpub\wwwroot\web.config' is denied.

Source Error:

[No relevant source lines]

Source File: c:\inetpub\wwwroot\web.config Line: 0

---

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

Solution:

1. Check if the reportserver is running in your machine.
2. Also check if the IIS is properly configured in the machine
3. Delete Web.Config in c:\InetPub\wwwroot.

(NOTE: A common configuration mistake is to have both SSRS and SharePoint in the default web site. When SharePoint is installed it takes over the default website. SSRS website should be changed to listen on a different port, e.g. port 8080; use http://localhost:8080/reports for Report Manager and http://localhost:8080/ReportServer for Report Server if you got sharePoint installed on same server)

Blackberry error msg: "No available message stores"

There is a way to stop sync problem with Outlook 2007 and Blackberry devices. First of all your Blackberry Desktop Manager Software must be 4.2 or higher. The key point is installation of Office 2007. While in the beginning of installation you have to choose customise menu in order to set installation options by yourself. In the installation options you have to disable Add-In section under the Outlook tab. If you don't install Outlook Add-In section at the installation of Office 2007, you system will sync between your blackberry and your device. Also you don't need to mess up things like mail exchanger folder creation or renaming. The real problem is Microsoft Outlook Connector Software Error. The file is omsmain.dll. The Add-In section sets up this Connector Software. If you had already installed Office 2007 I recommend uninstall and install fresh one with customised options. Deleting or Disabling Connector Add-In feature (omsmain.dll) after the installation will not work. Also don’t forget to cleanup intellisync folder after the installation.

Blackberry error msg: "No application configured for synchronization"

When synchronizing my BlackBerry Wireless Handheld, I receive the message: No applications configured for translation. What should I do?

Cause: You have not selected applications for synchronization.

Resolution: Configure the translators for synchronization:

1. Connect the BlackBerry device to the personal computer and open BlackBerry Desktop Manager.
2. Open Intellisync and click Configure PIM.
3. Select an application and click Choose.
4. Select a translator from the Available Translator list and click OK.
5. Repeat steps 3 and 4 for the remaining applications.
6. Click OK to close the Configuration window.
7. From the Intellisync window, select Synchronize PIM and click Synchronize now.

How to create SQL 2005 database mail notification

1. Right click "Database Mail"

2. Click "Configure Database Mail"

3. Welcome to "Database Mail Configuration Wizard" appears

4. Click "Next" button

5. Select "Manage Database Mail accounts and profiles"

6. Click "Next" button

7. Select "Create a new account"

8. Type in your "Account name", "Description", "E-mail Address", "Display name", "Server name:" and select "Windows Authentication using Database Engine service credentials" under "Database Mail configuration Wizard" window.

How to create SQL 2005 database mail profile and mail notification

1. Right click Database Mail
2. Click "Configure Database Mail"
3. Welcome to Database Mail Configuration Wizard apper
4. Click Next button
5. Select "Manage Database Mail accounts and profiles"
6. Click "Next" button
7. Select "Create a new profile"
8. Type in your Profile name: in text box under "Database Mail configuration Wizard" window.

Unable to modify fail-safe operator in SQL Server 2005

I am trying to change the fail-safe operator in SSMS from one operator to another operator. It allows me to make the changes, but after selecting ok and going back into the SQL Server Agent Properties it still shows up as the old operator. This behavior prevents me from removing the old operator.

There are few step that you can take

I) Disable Opeartor a/c

II)
1) Right-click "SQL Server Agent" and select "Properties"
2) On the left select "Alert System"
3) When the Alert System page comes up check "Enable fail-safe operator"
4) Make sure you choose "NewOperator" from the "OldOperator" drop down box
5) Click "Ok"

OR

Create two operators in SQL Server Management Studio
1) In SSMS expand -> SQL Server Agent
2) Right-click "Operators" and select "New Operator..."
3) In the "Name:" text box enter "Operator1"
4) Click "OK"
Repeat Steps 1-4 and create another operator names "Operator2"

Set original fail-safe operator
1) Right-click "SQL Server Agent" and select "Properties"
2) On the left select "Alert System"
3) When the Alert System page comes up check "Enable fail-safe operator"
4) Make sure you choose "Operator1" from the "Operator:" drop down box
5) Click "Ok"

Verify fail-safe operator
1) Right-click "SQL Server Agent" and select "Properties"
2) On the left select "Alert System"
3) Verify that the "Operator:" drop down box says "Operator1"

Change fail-safe operator
1) Right-click "SQL Server Agent" and select "Properties"
2) On the left select "Alert System"
3) Select "Operator2" from the "Operator:" drop down box
4) Click "Ok"

Check fail-safe operator
1) Right-click "SQL Server Agent" and select "Properties"
2) On the left select "Alert System"
3) Notice that the "Operator:" drop down box still says "Operator1"

Global management group settings - reporting is grayed out

I installed RS on my SCOM 2007 server but reporting tab on navigation pane on left of SCOM is grayed out. Reinstalling SQL 2005 Reporting service did not help and below are the few links that help you guys

http://msdn.microsoft.com/en-us/library/bb677368(SQL.100).aspx

http://msdn.microsoft.com/en-us/library/ms143219(SQL.100).aspx

http://msdn.microsoft.com/en-us/library/ms143773(SQL.100).aspx

also attached is the document that might help you out.

how to get read of 'abc' icon on the top rigt corner of my Blackberry screen

In a message

Hit Menu>options>Enable Suretype

Or you can try

Option>Language>Input Language - English (United States)

1. Go to the main applications view on the Pearl.
2. Choose Options (it's the little crescent wrench icon) and select it.
3. Scroll down to Language and click the trackball.
4. Under "Input Language" you want to either select your language with Multitap (to enable Multitap) or without (which puts you into SureType mode). For example, I selected English (United States) to get SureType.
5. Now just click the menu button and select Save and you're back to normal.

An attempt was made to send an email when no email session has been established

I got the above error when job which will send email to an operator when it is completed did not work and while troubleshooting I got below info

Configure SQL Server Agent Mail to Use Database Mail

1. To set up SQL Server Agent Mail to use Database Mail
2. In Object Explorer, expand a server.
3. Right-click SQL Server Agent, and then click Properties.
4. Click Alert System.
5. Select Enable Mail Profile.
6. In the Mail system list, select Database Mail.
7. In the Mail profile list, select a mail profile for Database Mail.
8. Restart SQL Server Agent.

Slipstreaming Windows XP (SP2) with Service Pack 3

Windows XP Home or Professional with SP2 Setup CD. It's possible that an original XP Setup CD or an XP with SP1 Setup CD will work, but I've only tested XP with SP2

Step 1: Copy the Windows XP Setup CD contents to your hard drive

Insert your Windows XP with SP2 Setup CD in the optical drive of your PC and close any auto-run window that appears. In My Computer (or Computer), right-click the optical drive and select Open. Leave the window open with a view of the contents of the Windows XP Setup CD.

Open My Computer again. This time, navigate to the root of the C: drive or another location to which you'd like to save the files you'll eventually integrate with SP3. Create a folder named XPCD (as in C:\XPCD). Then, create a second folder named sp3 (as in C:\XPSP3).

Now, drag and drop the contents of the XP Setup CD into the C:\XPCD folder.

Step 2: Extract the contents of the XP SP3 updater to your hard drive

Now, you need to extract the SP3 files. While the files are copying between the two locations, copy the Windows XP SP3 standalone installer (typically windowsxp-kb936929-sp3-x86-enu.exe in the US) to C:\XPSP3. Then, open a command line window (Start, Run, cmd in Windows XP; in Vista, just open the Start Menu and type cmd in Start Menu Search).

Then, using the following commands exactly, navigate to C:\XPSP3 and extract the files (Note that the text [ENTER] means hit the ENTER key):

cd \ [ENTER]
cd XPSP3[ENTER]
windowsxp-kb936929-sp3-x86-enu.exe -x:c:\XPSP3[ENTER]

An Extracting Files dialog will come up and display the progress

Step 3: Integrate XP with SP3

Now, type the following in the command line window (where [ENTER] means hit the ENTER key):

cd i386 [ENTER]
cd update [ENTER]
update.exe /integrate:c:\XPCD[ENTER]




An unknown error has occurred in the WMI Provider. Error code 80040219

If you are working with Reporting service and do see couple of Instance ID on SQL 2005. Most probably you might had deleted, moved or rename any of those Instance ID.

Ex: If you see MSSQL.1 and renamed to MSSQL.3 to make Reporting service configration Manager to show only one instance. This error will show up...

Refer to below link to help resolve this issues.

http://support.microsoft.com/kb/909967
http://blogs.msdn.com/astebner/archive/2005/09/13/465401.aspx
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=354408&SiteID=1

How To Create a User-Defined Service

To create a Windows NT user-defined service, perform the following steps:

1. At a MS-DOS command prompt(running CMD.EXE), type the following command:

path\INSTSRV.EXE My Service path\SRVANY.EXE

where path is the drive and directory of the Windows NT Resource Kit (i.e., C:\RESKIT) and My Service is the name of the service you are creating.

Example: C:\Program Files\Resource Kit\Instsrv.exe Notepad C:\Program Files\Resource Kit\Srvany.exe

NOTE: To verify that the service was created correctly, check the registry to verify that the ImagePath value under

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\service name

is set to point to SRVANY.EXE. If this is not set correctly, the service will stop shortly after it starts and return an Event ID 7000 "The service name failed to start."

WARNING: Using Registry Editor incorrectly can cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that problems resulting from the incorrect use of Registry Editor can be solved. Use Registry Editor at your own risk.For information about how to edit the registry, view the "Changing Keys And Values" online Help topic or the "Add and Delete Information in the Registry" and "Edit Registry Data" online Help topics in Registry Editor.NOTE: You should back up the registry before you edit it.

2. Run Registry Editor (Regedt32.exe)and locate the following subkey:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\

3. From the Edit menu, click Add Key. Type the following and click OK:

Key Name: Parameters
Class :

4. Select the Parameters key.

5. From the Edit menu, click Add Value. Type the following and click OK:

Value Name: Application
Data Type : REG_SZ
String : \

where \ is the drive and full path to the application executable including the extension (i.e., C:\WinNT\Notepad.exe)

6. Close Registry Editor.

By default, a newly created service it configured to run Automatically when the system is restarted. To change this setting to Manual, run the Services applet from Control Panel and change the Startup value to Manual. A service set to Manual can be started in one of several ways:

- From the Services applet in Control Panel
- From a MS-DOS command prompt, type the following:

NET START

- Use the Sc.exe utility from the Resource Kit. Type the following from a MS-DOS command prompt:

\Sc.exe start

where is the drive and directory of the Windows NT Resource Kit (i.e., C:\Reskit).

Ref: http://support.microsoft.com/kb/137890#appliesto

How to change service path for any Windows services

This article contains information about editing the registry. Before you edit the registry, make sure you understand how to restore it if a problem occurs. Make sure to backup registry before making any changes


HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\service name

is the path where one can find all windows services running.

rsRPCError; The report server installation is not initialized

Reporting Services Error

The report server installation is not initialized

Check the link for more details

Also best practice to start with troubleshoot is to make sure remote SCOM server have full privilege on ReportsServer and ReportServerTempDB database.

After trying many options the one that work was to uninstall and reinstall Reporting Service. Below are the services

1. Uninstall Reporting service from Add and remove program. Select Microsoft SQL server and click Change button. Then select SQL => Reporting services

2. Reboot the box after uninstallation

3. Install Report Service from SQL 2005 setup.exe file and select only Reporting Services. Click Advance button and make sure the Path and Entire feature will be installed on local hard drive.

4. Install SQL SP2 if its not embaded in you previous setup.exe file.

5. Reboot SQL 2005 server box.

6. Configure "Reporting Service Configuration" under All Programs => Microsoft SQL Server 2005 => Configuration Tools.

rsInvalidReportServerDatabase

SQL Server Reporting Services

You get r"sInvalidReportServerDatabase" and "The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'C.0.8.54'. The expected version is 'C.0.8.40'. To continue, update the version of the report server database and verify access rights. (rsInvalidReportServerDatabase) " error when trying to access http://localhost/reportserver

Solution:

Try to apply/re-apply SP2 to your reporting services installationsince the ReportServer database you are pointing to is at an SP2 level(C.0.8.54) whereas the Reporting Services instance that is trying to usethat database is at an RTM level and therefore looking for an RTM leveldatabase (C.0.8.40).


Also make sure if you got full access permissions on "Operations Manager 2007 WebConsole" or "Default Web Site" folder under IIS => local computer => Web Site (folder).

Where to download Management Packs from SCOM 2007

Management Packs for SCOM 2007


Best link that I got is from MS website


I can't find Double-Take, GeoCluster MP for SCOM 2007. Did found older version on double take website for MOM but not for SCOM 2007.