SQL 2008 BACKUP UTILITY

DOWNLOAD

Solution for MSDTC Error While Submit Account of Point of Sale in SQL 2008 R2

1. On the Start menu, point to All Programs, point to Microsoft SQL Server 2008 R2, point to Configuration Tools, and then click SQL Server Configuration Manager.
2. In SQL Server Configuration Manager, click SQL Server Services.
3. In the details pane, right-click the name of the SQL Server instance for which you want to change the service startup account, and then click Properties.
4. In the SQL Server <instancename> Properties dialog box, click the Log On tab, chose Built in Account and select Local System as account type.
5. After selecting the new service startup account, click OK.
   A message box asks whether you want to restart the SQL Server service.
6. Click Yes, and then close SQL Server Configuration Manager.

SQL 2008 R2 EXPRESS EDITION FROM MICROSOFT

FOR 32 BIT OS      DOWNLOAD

FOR 64 BIT OS      DOWNLOAD

Active X component error in server

Re-register the following DLLs by using Regsvr32.exe, and then restart the computer:

C:\Program files\Common Files\System\ADO\Msado15.dll
C:\Program files\Common Files\System\Ole Db\Oledb32.dll
C:\Program files\Common Files\System\Ole Db\Sqloledb.dll
C:\WINNT\System32\Atl.dll

MSDTC on server 'servername' is unavailable

By default, when a stand-alone instance of Microsoft SQL Server exists in a cluster environment, the SQL Server-based instance is set to start automatically. If the host node is rebooted, you may receive the following error message when you issue commands that are related to distributed transactions:

ERROR: MSDTC on server 'servername' is unavailable.

RESOLUTION On the server where the trigger resides, you need to turn the MSDTC service on. You can this by clicking START > SETTINGS > CONTROL PANEL > ADMINISTRATIVE TOOLS > SERVICES. Find the service called 'Distributed Transaction Coordinator' and RIGHT CLICK (on it and select) > Start.

( or Change the Startup type into Automatic and Right Click and Restart the service )

To do this, type the following command at a command prompt, and then press ENTER:

net start msdtc

Verify that a message is displayed that indicates that the MSDTC service was started successfully.

SQL 2008 R2 EXPRESS EDITION

DOWNLOAD