Download and Install Microsoft Office Access Database Engine 2007 and restart the system
The requested OLE DB provider Microsoft.ACE.OLEDB.12.0 is not registered
February 6th, 2013SSIS Error Code DTS_E_OLEDB_EXCEL_NOT_SUPPORTED: The Excel Connection Manager is not supported in the 64-bit version of SSIS, as no OLE DB provider is available
February 6th, 2013Method 1 : set the 32 bit runtime environment using Project Properties -> Debugging -> Run64BitRuntime = False (in Visual Studio)
Method 2 : Open up the Agent Job -> Go to Steps -> Double click and Open the Step -> Go to Execution Options and Select Use 32 bit Runtime
Cannot connect remotely to SSAS
December 12th, 2012TS into the machine on which SSAS is installed using Admin priviledges
Navigate to Start -> Administrative Tools -> Windows Firewall
Then Create Inbound Rules -> New Rule -> Port -> All Local Ports -> Allow the Connections -> Name the Rule and Click Finish
Then Create Outbound Rules -> New Rule -> Port -> All Local Ports -> Allow the Connections -> Name the Rule and Click Finish
OR
Else create a Inbound Rule for Port 2383 and click on Finish
SSRS service not starting
October 29th, 20121.Click Start, click Run, type regedit, and then click OK.
2.Locate and then click the following registry subkey:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control
3.In the right pane, locate the ServicesPipeTimeout entry.
Note If the ServicesPipeTimeout entry does not exist, you must create it. To do this, follow these steps:
a.On the Edit menu, point to New, and then click DWORD Value.
b.Type ServicesPipeTimeout, and then press ENTER.
4.Right-click ServicesPipeTimeout, and then click Modify.
5.Click Decimal, type 60000, and then click OK.
This value represents the time in milliseconds before a service times out.
6.Restart the computer
Shift Key not working in Ubuntu
June 14th, 2012Start ubuntu
Click on System Settings
Under Personal, double click on Keyboard Layout
Click on (+) symbol in the keyboard Layout window and select English(US)
Remove if any other Layout is present by selecting that layout and clicking on (-) symbol on the keyboard layout page.
Excel 2007 : There was a problem sending the command to the program
February 7th, 2012Open Start – > All Programs ->Microsoft Office -> Excel 2007
Go to Excel Options on the Menu. Click on Advanced and then go to General Section.
Uncheck the checkbox for “Ignore other applications that use Dynamic Data Exchange (DDE)”
Click on OK
How to Remove or Delete other’s workspace in TFS
June 28th, 2011Open the Command prompt with administrator rights
Run the below command and prompted to deeleted ,enter Yes
tf workspace /delete [/server:servername] workspacename[;workspaceowner]
BACKUP LOG cannot be performed because there is no current database backup
June 14th, 2011I changed my database Recovery model from simple to full. Then i tried to take the backup of the transaction log but got the above error.
Sol : Take the Full backup of the database and then try to take the backup of the log.
This installation is forbidden by system policy
June 14th, 2011Click Start -> Control Panel
Open Administrative Tools
Open Local Security Settings
Click Software Restriction Policies
If no software restrictions are defined, right click the Software Restriction Policies node and select New Software Restriction Policy
Double click Enforcement
Select “All users except local administrators”
Click OK
Reboot the machine