Active Direcory Helper Service Fails To Launch

Oct 10, 2007

I just installed a copy of sql2005 express, and need to use windows authentication. the ad helper service bombs on startup, any helpfull suggestions would be appreciated.
thanks

View 2 Replies


ADVERTISEMENT

SQL Server Active Directory Helper Service

May 9, 2007

Hi,
Couple questions regarding SQL Server Active Directory Helper service:
a)What is its purpose?
b)Where can I get more detailed information about this service and
SQL Server 2005 services in general?
c)How can the following error during start up phase of this service
be avoided?
Error Message:
'0' is an invalid number of start up parameters. This service takes two start up parameters.

FYI: SQL Server 2005 is run on Windows XP professional.

Thanks,
Mike

View 2 Replies View Related

Active Directory Helper Service Aborting Upon Startup

Sep 6, 2007



On a fairly new install of SQL 2005 64-bit, upon bootup the Active Directory Helper Serivice is aborting with the error 3221225572 (0XC0000064). When an attempt is made to start the service manually the following error appears: "Windows could not start teh SQL Server Active Directory Helper on Local Computer. For more infromation, review the System Event Log. If this is a non-Microsoft service, contact the service vendor, and refer to the service-specific error code - 1073741724."

The service is strating up under the network services account, which I am suspicous may be a problem. Currently the SQL server is running under SQL 2005 SP2 with no post service pack hotfixes. Do you have any advice on how to get the service to launch without errors?

View 4 Replies View Related

Report Builder Fails To Launch

Jun 20, 2007



Good day:





I've searched and found a whole lot of information regarding Report Builder's occasional failures to launch, but every single suggestion has not worked for me. I'll try to describe this as completely as possible.



PC 1: Login with my user id, navigate to either my test or production report server, click 'Report Builder'; application launches and can be used as expected. Login with a 2nd user id, and it works. OS is Win2003 Server. Because both logins work on this PC, which tells me the security credentials are set correctly.



PC2: Login with my user id, navigate to either my test or production report server, click 'Report Builder'; application fails to launch. I do not receive an error message or dialog. The 'frames' for the Report Builder form flash momentarily on the screen. Login with same 2nd user id, and it fails the same way. OS is WinXP SP2; all updates.



PC3: Login with my user id, navigate to either my test or production report server, click 'Report Builder'; application fails to launch. I do not receive an error message or dialog. The 'frames' for the Report Builder form flash momentarily on the screen. Login with same 2nd user id, and it fails the same way. OS is WinXP SP2; all updates.



On PC2 and PC3, I navigate to the ClickOnce cache in my profile, right-click and 'run as' the reportbuilder.exe file. Choosing 'run as' my login and providing a password -- voila -- the application runs. I have to manually set the link to the report server, but it appears all else works fine. Same situation when I use my 2nd user id. If I don't 'run as' and provide the password (just double-click to launch the file), I get the same 'flash frames' above.



Ultimately, the push is to get PC2 and PC3 to function as does PC1. My resident .NET expert is stumped, as am I. Please help.

View 4 Replies View Related

How To Launch Package From A Windows Service

May 20, 2006

I'm developing a Windows Service to watch for an e-mail and then launch a package.  It extracts some parameters from the e-mail that I then need to pass to the package.  What is the best way to launch the package from the service?  Should I run it in a new thread? I don't want the service to have to wait for the package to complete.  How would I pass the parameters?  Should I use dtexec?  If the service fails or is stopped and the package is still running, it would terminate the package also, correct?  Any way to avoid that?  Thanks.

View 3 Replies View Related

Active Script OK But Scheduled Job Fails

Jul 20, 2005

I have an ActiveX Script task in a DTS package which executes finewithin DTS.However, if I run it as a sheduled job, it fails with a 'path notfound error'. I've cut the code down to the approriate problem andposted it here, it just makes a simple text file with a name derivedfrom the current date and time and puts 'Hello World' in the filealthough in reality I go on to make an xml file. (make sure your pathexists before you execute it). Why does the scheduled job not executethis simple task. I have loads of other jobs that run packages to aschedule and the account is a domain account with windowsadministrative rights.'******************************' Visual Basic ActiveX Script'**********************Const strPath="d:xml"Private Function GetDateTime()Dim strNow, stryear, strMonth, strDay, strTimestrNow = Nowstryear = Mid(strnow, 7, 4)strMonth = Mid(strnow, 4, 2)strDay = Left(strnow, 2)strTime = Replace(Mid(strnow, 12, 8), ":", "")GetDateTime = stryear + strMonth + strDay + strTimeEnd FunctionFunction Main()Dim fso,f,MyFile 'file objectsSet fso = CreateObject("Scripting.FileSystemObject")dim strRightNowstrRightNow=GetDateTime()Set MyFile= fso.CreateTextFile(strPath &"" & "UPD-"& strRightNow & ".txt", True) 'This line fails from a scheduled jobMyFile.WriteLine("Hello World")MyFile.CloseMain = DTSTaskExecResult_SuccessEnd Function'Error Source= Microsoft VBScript runtime error Error Description:Path not found Error on Line 25

View 1 Replies View Related

Active Directory Service And IIS Problem

Jun 21, 2007

I have a ASP.Net Project to read active directory usernames.

Its working fine when running thru asp development server.

But while running thru IIS Server. It displays the following error


"An exception of type 'System.DirectoryServices.DirectoryServicesCOMException' occurred in System.DirectoryServices.dll but was not handled in user codeAdditional information: Logon failure: unknown user name or bad password."



This is my Code :

Public Function readADSusers()
Dim enTry As DirectoryEntry = New DirectoryEntry("LDAP://spiretek.local")
Dim mySearcher As DirectorySearcher = New DirectorySearcher(enTry)
mySearcher.Filter = ("(objectClass=user)")
Dim resEnt As SearchResult
For Each resEnt In mySearcher.FindAll()
Select Case myKey
Case "samaccountname"
TextBox1.Text += myResultPropColl(myKey)(0)
End Select
Next
End Function



Please Help Me......

View 1 Replies View Related

Where Can I Download The OLE DB Provider For Microsoft Active Directory Service

Feb 23, 2006

Hi,

Where can I download the OLE DB Provider for Microsoft Active Directory Service.

I'm using sql server 2005, windows server 2003. not sure the version of AD. (all 32 bit).

Cheers
Chris

View 1 Replies View Related

SQL 2012 :: Service Accounts For Active / Passive Cluster

Aug 26, 2014

This is the 1st time we are building a active/passive cluster with 1 node each. we usually install default instance and setup domain account as service account which will have an spn delegated. Now for active/passive cluster is it ok to use same domain account as service account for both clusters with both creating as default instance again as the windows was built as SERVER1 and SERVER2.

View 4 Replies View Related

Sql Helper Help

May 29, 2008

Hi I am building 3 tier application using ASP.NET and i am using sqlhelper class in Data Access Layer..now my question is "How to make use of sqltransaction using sqlhelper class.."means i want to make use of sqltransaction object for concurrency control...but since i m new to sql helper. that's why i am not able to do this... Please solve my problem by giving some sample code..so that i can understand the code & implement in my application.... Thanks in Advance...Abdul Javed Khan  

View 9 Replies View Related

SQL Helper Help

Jun 16, 2008

Hi..

Could you please send me the  sample code on how to pass sqltransaction to sql helper class..bcoz as i know i need to declare sqltransaction in aspx form & then i need to pass which is not a good approach in 3-tier..so please suggest me, if u have some sample code..please send me... Thanks in AdvancedAbdul Javed Khan

View 8 Replies View Related

Replication Configuration Helper (Id Buy It!)

Sep 18, 2006

Let's face it - setting up SQL 2005 merge pull replication using HTTPS between numerous SQL Server 2005 Express clients and one or more Publishers is an overly complicated exercise.

It should be easy. Why is it so hard?

In a nutshell: The connection chain and security chain is long and when there's a problem the error messages just don't point you to the answer - You have to search for it;re-read the doco; talk to gurus; use logging tools;re-read the error message 100 times; etc. etc.

It should be possible to create a 'Replication Configuration Helper' that steps -step by step - through both the connection chain (App - to SQL Express - to local network components - to the TCP/IP network - to the web server - to the publishers/distributers) and through the security chain (App - to SQL Express authentication - local agents including certificate errors - to ISS server authentication - to Distributer authentication -to Publisher authentication to Article authentication).

Let's face it - the steps occur in sequence and each step can be tested and the appropriate error message raised - TOGETHER WITH INSTRUCTIONS ON HOW TO RESOLVE! (I mean - what's use is an error message when you have to cut and past the error message into a browser and search for ages before you get the instructions on how to resolve the problem?)

So c'mon - someone volenteer to write a 'Replication Configuration Helper'

View 1 Replies View Related

Service Fails To Start

Jul 23, 2005

Am using SQL Server2000 on WINXP. Have been using this DB since it becameavailable. Today, all of a suddent, the Service was not 'started,' even thoI had it marked as 'automatic.' Tried to manually start the service, andreceived the message that some service start and stop if there is no workfor them to do.Don't know why this has happened. I rebotted my computer, but still can notget MSSQLSERVER 'started.' Can anyone help me here?

View 1 Replies View Related

Using A Datareader In A SQL Helper Select Query

Jan 28, 2005

Hi,

I am trying to retrieve a value from a SQL Server table based on the results of a datareader.This is the string i am trying to create

Me.ViewState("Make") = SqlHelper.ExecuteScalar(MyConnectionString, "usp_GetMake", (dr("MakeID")).To String)

Im not sure of the syntax as I know that it is basically using two different ways of reading a database.Is there an equivalent for the datreader which can be used with SQL Helper?

Thank you for your help

Julie

View 1 Replies View Related

SQL 6.5 Installation Of Service Pack 5a Fails ???

Jul 11, 2001

It seems that all of a sudden my companies clients are running into problems with the installation of servicepack 5a on SQL Server 6.5 workstations. The servicepack is apparently getting to the point where it checks the master DB and then Chkmast.exe returns a value of 0 which seems to indicate that there is not enough space in the master DB for the service pack to install. I have expanded master databases well beyond the capacity where this would ever be a problem but the service pack continues to fail on chkmast.exe. What nweeds to be done to allow the service pack installation to complete?

View 3 Replies View Related

Replication Fails After Service Pack 1

May 26, 2006

We have two servers using merge replication. I have updated one with SP1 and not the other (yet). Replication fails to work after the upgrade. I get the following error message:
Date 5/26/2006 2:09:08 AM
Log Job History (BB-CM1-SRV1-CountAndCrush-New Sync for Crusher-CC-SQLSRV-6)

Step ID 2
Server BB-CM1-SRV1
Job Name BB-CM1-SRV1-CountAndCrush-New Sync for Crusher-CC-SQLSRV-6
Step Name Run agent.
Duration 00:00:00
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Message
2006-05-26 06:09:08.316 Category:NULL
Source: Merge Replication Provider
Number: -2147199417
Message: The Publisher failed to allocate a new set of identity ranges for the subscription. This can occur when a Publisher or a republishing Subscriber has run out of identity ranges to allocate to its own Subscribers or when an identity column data type does not support an additional identity range allocation. If a republishing Subscriber has run out of identity ranges, synchronize the republishing Subscriber to obtain more identity ranges before restarting the synchronization. If a Publisher runs out of identit
2006-05-26 06:09:08.316 Category:SQLSERVER
Source: BB-CM1-SRV1
Number: 20663
Message: The publisher's identity range allocation entry could not be found in MSmerge_identity_range table.

View 3 Replies View Related

SQL 2005 Service Pack 1 Fails

Jan 30, 2007

Hi all,

I know that this has been covered a few times and I have made sure that permissions are correct on all the files, however I'm still failing on SQL9_Hotfix_KB918222

I would like to post the SQL9_Hotfix_KB913090_sqlrun_sql.msp.log but either its too big for the forum to handle or the forum is having some problems.



I would be more than happy to send it to anyone interested in helping out



Thanks



Mike

View 2 Replies View Related

SQLConnection Fails From Windows Service

Nov 24, 2006

Hi,

I'm currently writing a windows service which will generate XML documents for FTP upload. When running the service the goal is to get records from a stored procedure, then generate the XML documents.

When running the service (lokal service account) the connection fails; instead of using the supplied connection string, it defaults to the LocalService account. How can this be solved?

Thanks in advance

View 6 Replies View Related

Reporting Service Authentication Fails

Apr 10, 2008



Hello,

I am trying to deploy reporting service (SQL Server 2005) report on server from visual studio.

When i click on deploy menu.

System asks for user name and password.


Exactly as below


Server : http://machinename/reports

User name :

Password :


I am providing windows user identity (same as web service identity in reporting service configuration wizard). Authentication fails.


Kindly suggest ways to solve it. I may be making mistakes as well.


Thanks & Regards,
Kalai

View 1 Replies View Related

SQL Cluster Setup Fails After Installing Service Pack 2

May 28, 2000

We have successfully been using MSCS with MSSQL7 (SP1) running under NT4 EE
(SP6a), installed in an active/active configuration using, two DELL
PowerEdge 6350 machines. Recently I installed MSSQL7 (SP2), I followed the
instructions that came with SP2, and unclustered the SQL nodes using the
Failover Cluster Wizard, and installed SP2, this was uneventful, and
appeared to install correctly. Next I tried to recluster the SQL nodes
using the Failover Cluster Wizard as directed. This failed with: "Could not
run setup on remote machine. SQL Cluster Setup failed." So I began the
usual research using the usual resources, and have found articles that
discusses this error, and the things to look for when it happens. I have
exhausted all suggestions without success. I appear to have everything
correctly configured. I have enabled Cluster Logging (level 3), following
are the two things I have found that indicate something is wrong:

1. In the SQL Error Log the following gets logged when I run the wizard:
"Attempting to initialize Distributed Transaction Coordinator."
"Failed to obtain TransactionDispenserInterface:
XACT_E_TMNOTAVAILABLE"

2. In the Cluster Log I see the following message repeatedly:
"[ClRtlCopySecurityDescriptor] MakeSelfRelativeSD failed,
0x00000551"

3. In the sqlclstr.log I see the following, without an indication of
which file is missing:
"[reghelp.h:235] : 2 (0x2): The system cannot find the file
specified."
"[clushelp.cpp:166] : 259 (0x103): No more data is available."
"[validate.cpp:147] DeleteTestGroup:OpenClusterResource: 5007
(0x138f): The cluster resource could not be found."
"~~~ XXX InstallRemote failed"

Does anyone have any ideas about what could be causing this problem?
Many thanks in advance.

Christpher Cutts
LifeMasters Supported SelfCare

View 1 Replies View Related

SQL Server 2000 Service Pack 3a Installation Fails

Jul 23, 2005

I have an installation of SQL Server 2000. Both MBSA and @@versionshow this to be the gold release. When I install Service Pack 3a, itshows no error. But after restart of the server, it's still unpatched,by both MBSA and @@version.Any idea what may be going on here?

View 3 Replies View Related

MSXML6.dll Fails To Register When Calling SSIS From Win Service

Apr 19, 2007

Has anyone encountered this error? I get it when I run the installer (c#). I have seen a few posts on google and msdn, but still can't get past the error. I have tried uninstall/resinstalling the parser, registering from the command line, setting the property of the interop to "donotregister" and others with no luck.

Any ideas?

Thanks,
Lee

View 3 Replies View Related

SQLConnect To SQL Server Fails When Connection Intialized From A Service

Mar 8, 2006

I have an
issue where SQL Server is refusing a connection that is initiated from
within a Windows service. The connection is attempted using the
SQLConnect ODBC function (yes I know there are newer and better things
out there but I'm stuck with ODBC for now ). SQLConnect returns
SQL_ERROR and the error code that is returned is:

28000

Invalid authorization specification
The value specified for the argument UserName or the value specified for the argument Authentication violated restrictions defined by the data source.

Now
it sounds like a username/password problem but when we attempt a
connection to the same server via a non-service program, everything
works fine (using the same username/password). We thought it might be
an ODBC issue at first but we can connect to a MySQL server using the
same programs/services just fine.

Checking the SQL Server setup, we do have both Windows accounts and SQL Server authentication enabled (under Security tab).

Anyone have any ideas?

thanks!
-Pete

View 10 Replies View Related

SQL Server 2000 Installation Fails On Windows XP With Service Pack 2

Nov 29, 2005

Hi,
i tried to install SQL Server 2000 Developer and MSDE the whole day on my Windows XP SP2.
MDAC is the latest, that come with WinXP SP2 (2.81). The installation fails at the end after 100% complete.

It says:
Translated: "the setup programm starts the server and installs the configuration you chose..."
("das setup-programm startet den server und installiert die von ihnen gewählte konfiguration...")

then it takes some time and the failure appears, saying:
"the setup programm could not configure the server. you can find more
information in the server-failure-log files and in
"C:windowssqlstp.log."

sqlstp.log last couple of lines:
22:42:10 C:WINDOWSTEMPSqlSetupBinscm.exe  -Silent 1 -Action 4 -Service MSSQLSERVER
22:42:10 Process Exit Code: (0)
22:42:10 StatsGenerate returned: 2
22:42:10 StatsGenerate (0x80000000,0x1,0xf000000,0x200,1031,303,0x0,0x1,0,0,0
22:42:10 StatsGenerate -1,toebens)
22:42:10 Installation Failed.



I already read several knowledge base articles on this... removed keys in the registry...and so on...nothing worked :(

this **** makes me angry. please help me.
thanks
 

View 5 Replies View Related

SQL Server Service Manger Fails To Start With Error Message

Apr 15, 2001

We have changed the Network Domain name of a SQL server and restarted before changing any of the settings in SQL server. When we now try to start the SQL server service manager we get the following error

Your SQL server is either corrupt or has been tampered with. Unknown package id please rerun setup

Any suggestions on how to get the SQL server back on line without having to take the server down and changing the Netowrk Domain Name back ??

Cheers

SR

View 1 Replies View Related

SQL 2012 :: SSIS Package Fails With Same Service Account On Different Instances?

Feb 15, 2015

I have a package on the default instance which runs and completes successfully. When that package is moved to the same SQL server, but a different instance, running under the same service account, it fails. The error is below with some specific stuff removed:

Delete Data from Level 1:Error: Executing the query "-- Variable to capture FileID's
DECLARE @DeleteFil..." failed with the following error: "The DELETE permission was denied on the object '[name removed]', database '[]', schema '[]'.". Possible failure reasons:

Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

This makes me think that the package under the non-default instance ends up running under a different security context.

View 8 Replies View Related

SQL Server Admin 2014 :: SSIS Service Fails To Start

Aug 7, 2015

i m not able to start the SSIS service on my laptop . IT gives error saying SQL server integretion service 11.0 service on local computer started and then stopped . some services stop automatically if they are not in use by other services or program

i am not able to start SSDT . it gives error

microsoft visual studio is unabble to load this document to desigen integration service package in ssdt , ssdt has to be installed by one of these edition of sql server ; std enterprise,dev,or evloution

i hav installed sql 2012 evolution verison on my local desktop.

View 1 Replies View Related

MSDE Fails To Install; Cnfgsvr Cannot Start The Instance Service.

Dec 1, 2005

Windows XP, SP2; MSDE 2000 Release A - on some installs of the XP SP2 MSDE installation fails, the section of the install log that applies is:

View 3 Replies View Related

SQL Server 2005 Embedded Edition Service: KB929665 Fails To Fix

Nov 16, 2007


Hello all,

I€™m looking for some help to get my Windows SharePoint Services 3.0 back on-line running without losing the documents stored on it..

Configuration basics: Microsoft Windows SharePoint Services 3.0 on member Server 2003 Std w/ SP2 using the Windows Internal Database (MS SQL Server 2005 Embedded Edition)

I had the SharePoint Services site operating on a member server.

I used the Manager the Server wizard to Install Active Directory on the member server. (Ouch! My Mistake)

I broke the SQL Server 2005 Embedded Edition Service. It would not restart. The System Evt code was 7024 error 3417.

I researched and found KB 929665 which describes my symptoms perfectly.

http://support.microsoft.com/kb/929665

I tried the recommended command (see Note1) and the configuration failed.
I discovered the following errors in the log file:

GetServiceUserGroup failed for MICROSOFT##SSEE, 5
Error Code: 0x80070534 (1332)
Windows Error Text: No mapping between account names and security IDs was done.
Source File Name: sqlcasqlcax.cpp
Compiler Timestamp: Mon Feb 27 02:04:14 2006
Function Name: SetInstanceProperty
Source Line Number: 1223

Error Code: 1332
MSI (s) (2C!4C) [19:08:50:678]: Product: Microsoft SQL Server 2005 Embedded Edition (Windows) -- Error 29528. The setup has encountered an unexpected error while Setting Internal Properties. The error is: Fatal error during installation.

Error 29528. The setup has encountered an unexpected error while Setting Internal Properties. The error is: Fatal error during installation.

<Failure Type='Fatal' Error='1332'>
<EndFunc Name='LaunchFunction' Return='1332' GetLastError='0'>
Action ended 19:08:50: SetInstanceProperty.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 3.
Action ended 19:08:50: INSTALL. Return value 3.

Note 1: Msiexec <MSI_File_Name> CALLERID=OCSetup.exe REINSTALL=ALL REINSTALLMODE=omus /qn REBOOT=ReallySupress /l*v <Log_File_Path>

(Note: the line is missing the switch €œ/i€? after MSIEXEC)

How can a get my SharePoint working again?
Thank you!
Mike

View 3 Replies View Related

DHCP Service Fails To Start After Installing SQL Server 2005 April CTP

Jul 18, 2005

I have a Windows 2003 Server SP1, Active Directory, Application Server and RIS installed on my computer. After installing SQL Server 2005 April CTP my DHCP Service fails to start. In the Event Viewer I see the following Events.

View 20 Replies View Related

SQL Server 2012 :: Query To Count How Many Sessions Are Active And Remain Active Per Hour

Jan 22, 2015

I have a table with the following columns employeeSessionID, OpDate, OpHour, sessionStartTime, sessionCloseTime. I need to see how many users remain active per hour. I can calculate how many logged in per hour, but I am stumped on how to count how many are active per hour. I have a single table that stores login data. I have created a query that pulls out the only the data needed from the table into a temp table using this query. Also note it is possible that the sessionCloseTime is null if the device has not been logged out this would need to be counted a active.

TABLE NAME #empSessionLog Contains the time stamp data OpDate, sessionStartTime and sessionCloseTime.
OpDatesessionStartTimesessionCloseTime
2015-01-202015-01-20 14:32:59.1302015-01-20 14:33:14.6299166
2015-01-202015-01-20 06:58:33.7302015-01-20 15:27:16.9133442
2015-01-202015-01-20 09:56:22.8402015-01-20 17:56:29.7555853
2015-01-202015-01-20 05:59:18.6132015-01-20 14:05:19.0426707

[code]....

can see how many sessions logged in per hour with the following statement:

SELECT
opDate,
FORMAT(DATEPART(HOUR, sessionStartTime), '00') AS opHour,
Count(*) AS Total
FROM #empSessionLog
Group BY opDate, FORMAT(DATEPART(HOUR, sessionStartTime), '00')
Order BY opDate, FORMAT(DATEPART(HOUR, sessionStartTime), '00') ASCResults:
opDateopHourTotal
2015-01-20041

[code]....

Where I am stuck is how do I count the sessions that remain active per hour until the session is closed with the sessionCloseTime.

View 5 Replies View Related

There Is Not Enough Disk Space Error While Installing SQL In A Active/Active/Passive Cluster

Mar 5, 2008



Hi

I am having some teething problems while installing SQL on a 3 node cluster. Within the Cluster configuration I have 3 Cluster Groups with each of them having their associated disk resources. All these disk resources physically exist on a SAN.

The actual cluster is running absolutely fine and I can access all the disks from their respective owner node. The problem only starts when I start installing SQL Server 2005 on this cluster. I specify the Cluster group from the Cluster Group Selection and choose the desired partition and then the error message pops up

"There is not enough diskspace on the destination disk for the current SQL Server data files. To proceed, free up disk space to make room for data files, or install the data files to a different drive"

But the disk I am trying to install it on is 264Gb and none of it is used. I have also tried to change it to a different disk within the same Cluster group but to no avail. I have even tried to install it in a different cluster group all together but I get the same error message.

I have googled around havent found anything so far. The disks have got full permissions for the account I am installing SQL with.

Any help will be much appreciated.


Regards

Adnan

View 5 Replies View Related

SP2 Fails On Cluster - Domain Group Cannot Be Validated For The Service Full-Text Search

Jul 10, 2007

Greetings,

I'm totally stuck on this issue and would really appreciate any advice. Here's what's going on...

I'm trying to install SP2 on a SQL 2005 Std x64 cluster and all the components upgrade except the DB Engine, which fails with this error saying the domain group (not the service account) could not be validated for the full-text search service.

I've rebooted both nodes. I've verified that the domain group exists. I even removed the full text search component and I still get the same error.

I've reviewed this: http://support.microsoft.com/kb/915846
But the ftsgroup registry value mentioned does not exists. I assume it only shows up after sp2 is installed.

Interestingly, I couldn't uninstall full-text search unless I passed the FTSCLUSTERGROUP parameter to the setup.exe command line remove command.

The OS is Windows Server 2003 Ent x64 SP2. Not a domain controller. I'm upgrading from the RTM version of SQL Server.

I've posted the relevant parts of the summary and log files below.

Thanks in advance for any ideas!

- Chris

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

Summary.txt
==========

Product : Database Services (MSSQLSERVER)
Product Version (Previous): 1399
Product Version (Final) :
Status : Failure
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB921896_sqlrun_sql.msp.log
Error Number : 28130
Error Description : MSP Error: 28130 A domain group is missing for one or more services. To install SQL Server 2005 as a failover cluster, domain groups must be specified for all the clustered services being installed .To proceed, enter the missing domain group information.
The domain group cannot be validated for the service Full-Text Search.



sqlrun_sql.msp.log
===================

<Func Name='GetServiceAccountProperty'>
<Func Name='GetServiceAccountProperty'>
<Func Name='GetServiceAccountProperty'>
Loaded DLL:
C:Program FilesMicrosoft SQL Server90Setup Bootstrapsqlsval.dll
Version:
2005.90.3042.0

Failed to validate group name for FTSCLUSTERGROUP. Error 87
Error Code: 0x80070057 (87)
Windows Error Text: The parameter is incorrect.
Source File Name: sqlcadomaingroupdialog.cpp
Compiler Timestamp: Sat Oct 7 09:43:40 2006
Function Name: validateSetDomainGroups
Source Line Number: 484

MSI (s) (A8!98) [12:17:17:610]: Transforming table Error.
MSI (s) (A8!98) [12:17:17:610]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (A8!98) [12:17:17:610]: Transforming table Error.
MSI (s) (A8!98) [12:17:17:626]: Transforming table Error.
MSI (s) (A8!98) [12:17:17:626]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (A8!98) [12:17:17:626]: Transforming table Error.
MSI (s) (A8!98) [12:17:17:626]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (A8!98) [12:17:17:626]: Transforming table Error.
MSI (s) (A8!98) [12:17:17:626]: Note: 1: 2262 2: Error 3: -2147287038
Error Code: 87
MSI (s) (A8!98) [12:17:17:626]: Transforming table Error.
MSI (s) (A8!98) [12:17:17:626]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (A8!98) [12:17:17:642]: Transforming table Error.
MSI (s) (A8!98) [12:17:17:642]: Transforming table Error.
MSI (s) (A8!98) [12:17:17:642]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (A8!98) [12:17:17:642]: Transforming table Error.
MSI (s) (A8!98) [12:17:17:642]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (A8!98) [12:17:17:642]: Transforming table Error.
MSI (s) (A8!98) [12:17:17:642]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (A8!98) [12:17:17:642]: Product: Microsoft SQL Server 2005 (64-bit) -- Error 28130. A domain group is missing for one or more services. To install SQL Server 2005 as a failover cluster, domain groups must be specified for all the clustered services being installed .To proceed, enter the missing domain group information.
The domain group cannot be validated for the service Full-Text Search.

Error 28130. A domain group is missing for one or more services. To install SQL Server 2005 as a failover cluster, domain groups must be specified for all the clustered services being installed .To proceed, enter the missing domain group information.
The domain group cannot be validated for the service Full-Text Search.
<EndFunc Name='LaunchFunction' Return='87' GetLastError='0'>
MSI (s) (A88) [12:17:17:642]: Transforming table InstallExecuteSequence.
MSI (s) (A88) [12:17:17:642]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038
MSI (s) (A88) [12:17:17:658]: Transforming table InstallExecuteSequence.
MSI (s) (A88) [12:17:17:658]: Transforming table InstallExecuteSequence.
MSI (s) (A88) [12:17:17:658]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038
MSI (s) (A88) [12:17:17:658]: Transforming table InstallExecuteSequence.
MSI (s) (A88) [12:17:17:658]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038
MSI (s) (A88) [12:17:17:658]: Transforming table InstallExecuteSequence.
MSI (s) (A88) [12:17:17:658]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038
Action ended 12:17:17: Validate_ServiceAccounts.3EA9D9BF_D9D2_4023_B2A7_9E2137B2FB1B. Return value 3.
Action ended 12:17:17: INSTALL. Return value 3.
Property(S): ProductCode = {26F1A218-3158-4107-B3A6-37FD61CEE969}
Property(S): ProductLanguage = 1033
Property(S): Manufacturer = Microsoft Corporation
Property(S): ProductVersion = 9.2.3042.00

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved