Windows 2008 & 2008 R2 Task Sheduler Error 2147943712

An error has occurred for task. Error message : The following error was reported: 2147943712

=========================================================================
Fix

1. Click Start, click Run,
2. Type secpol.msc and then click OK.
2. Under Computer Configuration -> Windows Settings -> Security Settings -> Local Policies Click on Security Options.
3. In the Policy pane, right-click Network access: Do not allow storage of credentials or .NET Passports for network authentication, click Properties, click to select Disabled, and then click OK.
4. Click Start, click Run,
5. Type "Gpupdate /force" with out quots and then click OK.

 

SQL 2005 Cluster Full Text Search Resource erorr

Generic service 'SQL Server Fulltext (MSSQL2K5)' could not be brought online (with error '1075') during an attempt to start the service.  Possible cause: the specified service parameters might be invalid.

=======================================================================
Fix1
1) Assuming that Node A is now active and Node B is passive
2) Install SP4 on Node A (Active Node First) and reboot it. Resources will fail over to Node B now.
3) One Node A comes back, move resources to Node A, and then install SP4 on Node B and reboot.
4) Once it comes back, check if the issue is resolved.
5) If not Follow Fix2

Fix2
1) Assuming Node A is Active, Open Regedit on Node B (Passive Node)  and follow below mentioned Reg Changes (Screenshot below)
Key: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSFTESQL$InstanceName\
Multi-String Value: DependsOnService
Value Changed from …
NTLMSSP
RPCSS
to
RPCSS
(Delete NTLMSSP)

2) Restart Node B
3) Once Node B comes back, Fail Over resources to Node B and try to start the Full Test Search Cluster resource. You should be able to start it now.
4) Do the Same Reg Change in NodeA (Passive now) and reboot that too 


R.hari

SQL 2005 Integration Service Installation Error

Failed to install and configure assemblies C:\Program Files\Microsoft SQL Server\90\DTS\Tasks\Microsoft.SqlServer.MSMQTask.dll in the COM+ catalog. Error: -xxxxx
Error message: Unspecified error

Error HRESULT E_FAIL has been returned from a call to a COM component

 

 

--------------------------------------------------------------------------------------------------------------------------

 

Fix

 

If you  getting this error in between installing a cluster, you can skip it and install SSIS on the node where you are getting

 

On the node where you have issue -

 

1) Deleting MSMQTask COM+ Components from Component Services:
- Open: Start\Programs\Administrative Tools\Components Services,
- Expand "Component Services" -> "My Computer" -> "COM+ Applications",
- You'll see "Microsoft.SqlServer.MSMQTask" component. Right click on it and Delete it.
- If that dialog box is open which poped up during SQL Server Setup then click Retry, otherwise start over and this problem will be gone.

Try to restart the installation

 

2) If that dosent work - ignore the error and install SSIS

3) Reboot Server

4) Once it comes back, un-install SSIS

5) Reboot the Server

6) Install SSIS again this time it shoud get installed with out issues!

 

R.hari

SQL 2005 Cluster Installation Issue on Windows 2008 R2 Failover Clueter

SQLSetup0012_XXXX_Core(Local) Error
Error: Action "InstallDTSAction.11" failed during execution.  Error information reported during run:
Action: "InstallDTSAction.11" will be marked as failed due to the following condition:
Condition "Package "11" either passed when it was last installed, or it has not been executed yet" returned false. Condition context:
Prereq package will be failed due to the previous installation attempt returning: 1602
Installation of package: "sqlsupport"  failed due to a precondition.

SQLSetup0012_XXXX_Core Error
Error: Action "LaunchLocalBootstrapAction" threw an exception during execution.  Error information reported during run:
"C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe" finished and returned: 1602
Aborting queue processing as nested installer has completed
Message pump returning: 1602

=========================================================================

Fix

1. Make sure task scheduler service is running on Remote Server
2. Make sure Remote registry service is runnning on Remote Server
3. Try if you can access \\<RemoteServerHostname>\C$ and \\<RemoteServerHostname>\Admin$

and if all looks good login to remote computer

1. Click Start, click Run,
2. Type secpol.msc and then click OK.
2. Under Computer Configuration -> Windows Settings -> Security Settings ->  Local Policies Click on Security Options.
3. In the Policy pane, right-click Network access: Do not allow storage of credentials or .NET Passports for network authentication, click Properties, click to select Disabled, and then click OK.
4. Click Start, click Run,
5. Type "Gpupdate /force" with out quots and then click OK.

R.hari