Wednesday, August 13, 2008
how to transfer blackberry images to laptop
2. Another way if you only have a few pictures and it's not too inconvenient to do one at a time is to use Bluetooth, assuming your computer is capable.
Monday, August 11, 2008
how to shrink file log LDF file
2. backup database {Database} to disk='c:\Program files\MS SQL\...
3. use {Database}
dbcc shrinkfile ({LogFileName}, {SizeToShrinkTo})
[where Database is db that you want to shrink; {LogFileName} is your db log file name (not the Logfile names); {SizeToShrinkTo} can be any size you want 100
show desktop icon is not on Quick launch tool bar
Manual steps to re-create the Show Desktop icon on the Quick Launch toolbar
| 1. | Click Start , click Run, type notepad, and then click OK. |
| 2. | In Notepad, type the following text on individual lines: [Shell] Command=2 IconFile=explorer.exe,3 [Taskbar] Command=ToggleDesktop |
| 3. | On the File menu, click Save As, and then save the file to your desktop as Show Desktop.scf. Note Notepad might automatically append a .txt extension to the file name. Remove this extension if present. The file name should be Show Desktop.scf. |
the following methods.
| a. | Use the mouse to drag the Show Desktop.scf icon to the Quick Launch toolbar or another location where you want the shortcut to appear. |
| b. | Click Move Here. |
Tuesday, July 29, 2008
No report builder models are available. To use Report Builder, at leasetr one model must be published to the report server
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
Thursday, July 24, 2008
Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\ReportServer\RSReportServer.config' is denied
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)
Wednesday, July 23, 2008
Blackberry error msg: "No available message stores"
Blackberry error msg: "No application configured for synchronization"
Cause: You have not selected applications for synchronization.
Resolution: Configure the translators for synchronization:
- Connect the BlackBerry device to the personal computer and open BlackBerry Desktop Manager.
- Open Intellisync and click Configure PIM.
- Select an application and click Choose.
- Select a translator from the Available Translator list and click OK.
- Repeat steps 3 and 4 for the remaining applications.
- Click OK to close the Configuration window.
- From the Intellisync window, select Synchronize PIM and click Synchronize now.
Thursday, July 17, 2008
How to create SQL 2005 database mail notification
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
- Right click Database Mail
- Click "Configure Database Mail"
- Welcome to Database Mail Configuration Wizard apper
- Click Next button
- Select "Manage Database Mail accounts and profiles"
- Click "Next" button
- Select "Create a new profile"
- Type in your Profile name: in text box under "Database Mail configuration Wizard" window.
Unable to modify fail-safe operator in SQL Server 2005
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
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"
Tuesday, July 15, 2008
Global management group settings - reporting is grayed out
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.
Friday, July 11, 2008
how to get read of 'abc' icon on the top rigt corner of my Blackberry screen
Hit Menu>options>Enable Suretype
Or you can try
Option>Language>Input Language - English (United States)
- Go to the main applications view on the Pearl.
- Choose Options (it's the little crescent wrench icon) and select it.
- Scroll down to Language and click the trackball.
- 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.
- Now just click the menu button and select Save and you're back to normal.
Thursday, July 10, 2008
An attempt was made to send an email when no email session has been established
Configure SQL Server Agent Mail to Use Database Mail
- To set up SQL Server Agent Mail to use Database Mail
- In Object Explorer, expand a server.
- Right-click SQL Server Agent, and then click Properties.
- Click Alert System.
- Select Enable Mail Profile.
- In the Mail system list, select Database Mail.
- In the Mail profile list, select a mail profile for Database Mail.
- Restart SQL Server Agent.
Monday, July 07, 2008
Slipstreaming Windows XP (SP2) with Service Pack 3
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]
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]
Wednesday, July 02, 2008
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
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
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:
where
Ref: http://support.microsoft.com/kb/137890#appliesto
How to change service path for any Windows services
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
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
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).