In our project we are using reporting service web service calls to get report
paramaeters and report data.
We are passing an array of parameter values to webservice method
GetReportData() as an input parameter to render the output bytes.This
parameter values array consists of each controls's selected value.
Now in case of multivalue parameters, how to pass these multivalues to
webservice method GetReportData()?
Suppose for the control if we select the multiple values, how to send them
to array along with the other control's values to parametervalues collection.
please give suggestions on these.
Thanx
sriramI got the answer for this multivalue parameter
We have to send the multivalue parmaeters with same parameter name but with
different selected values in to parameter values array as below:
Here Foo is a multivalue parameter
<ParameterValues>
<ParameterValue>
<Name>Foo</Name>
<Value>1</Value>
</ParameterValue>
<ParameterValue>
<Name>Foo</Name>
<Value>2</Value>
</ParameterValue>
<ParameterValue>
<Name>Bar</Name>
<Value>NorthWest</Value>
</ParameterValue>
</ParameterValues>
"SRIRAM" wrote:
> In our project we are using reporting service web service calls to get report
> paramaeters and report data.
> We are passing an array of parameter values to webservice method
> GetReportData() as an input parameter to render the output bytes.This
> parameter values array consists of each controls's selected value.
> Now in case of multivalue parameters, how to pass these multivalues to
> webservice method GetReportData()?
> Suppose for the control if we select the multiple values, how to send them
> to array along with the other control's values to parametervalues collection.
> please give suggestions on these.
> Thanx
> sriramsql
Showing posts with label service. Show all posts
Showing posts with label service. Show all posts
Friday, March 30, 2012
Wednesday, March 28, 2012
multi parameters problem in CTP June
In CTP June Reporting Service and try the multi-value,
use Adventure Work DB and the SQL as follow..
SELECT Name, CountryRegionCode
FROM Person.CountryRegion
WHERE (CountryRegionCode = @.code)
When I checked the multi-value then browse,
I keyin the multi value AF, AL and the textbox show as AF, AL
click " View Report " then response the error message:
An error has occurred during report processing.
Query execution failed for data set 'Adventure'.
Incorrect syntax near ','.
What's happen?
How could I use multi-value in reporting services?
The multi-value dose work on AS Cube Report, but dosen't work on relational
DB?
Thanks for any advice!
AngiYou have to use the IN keyword in the query:
SELECT Name, CountryRegionCode
FROM Person.CountryRegion
WHERE CountryRegionCode (IN @.code)
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Angi" <enchiw@.msn.com> wrote in message
news:%23ndxNNduFHA.3660@.tk2msftngp13.phx.gbl...
> In CTP June Reporting Service and try the multi-value,
> use Adventure Work DB and the SQL as follow..
> SELECT Name, CountryRegionCode
> FROM Person.CountryRegion
> WHERE (CountryRegionCode = @.code)
> When I checked the multi-value then browse,
> I keyin the multi value AF, AL and the textbox show as AF, AL
> click " View Report " then response the error message:
> An error has occurred during report processing.
> Query execution failed for data set 'Adventure'.
> Incorrect syntax near ','.
> What's happen?
> How could I use multi-value in reporting services?
> The multi-value dose work on AS Cube Report, but dosen't work on
> relational DB?
> Thanks for any advice!
> Angi
>
use Adventure Work DB and the SQL as follow..
SELECT Name, CountryRegionCode
FROM Person.CountryRegion
WHERE (CountryRegionCode = @.code)
When I checked the multi-value then browse,
I keyin the multi value AF, AL and the textbox show as AF, AL
click " View Report " then response the error message:
An error has occurred during report processing.
Query execution failed for data set 'Adventure'.
Incorrect syntax near ','.
What's happen?
How could I use multi-value in reporting services?
The multi-value dose work on AS Cube Report, but dosen't work on relational
DB?
Thanks for any advice!
AngiYou have to use the IN keyword in the query:
SELECT Name, CountryRegionCode
FROM Person.CountryRegion
WHERE CountryRegionCode (IN @.code)
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Angi" <enchiw@.msn.com> wrote in message
news:%23ndxNNduFHA.3660@.tk2msftngp13.phx.gbl...
> In CTP June Reporting Service and try the multi-value,
> use Adventure Work DB and the SQL as follow..
> SELECT Name, CountryRegionCode
> FROM Person.CountryRegion
> WHERE (CountryRegionCode = @.code)
> When I checked the multi-value then browse,
> I keyin the multi value AF, AL and the textbox show as AF, AL
> click " View Report " then response the error message:
> An error has occurred during report processing.
> Query execution failed for data set 'Adventure'.
> Incorrect syntax near ','.
> What's happen?
> How could I use multi-value in reporting services?
> The multi-value dose work on AS Cube Report, but dosen't work on
> relational DB?
> Thanks for any advice!
> Angi
>
Wednesday, March 21, 2012
MSXML6.dll fails to register when calling SSIS from win service
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,
LeeOK got past the installation - but the package shows to fire but doesn't. Might be permissions; I am going to try and point the SSIS package to a local set of folders.
I think the problem was the "donotregister" property of the .dll. The SSIS tools, as you know, must be installed on your local workstation as well.
Lee|||Where are all of the 'experts' out here? I've posted five times out here and haven't received a response that remotely touches anything that I've ever come up with. 
Oh well.
Still at the same place. I created another ssis package and pointed it to the local folders and ran via a console app and it works fine. Most likely permissions. Someone suggested turning logging on the package. Not sure which logging they were referring to.
Thanks,
Lee|||
Lee Everest wrote:
Where are all of the 'experts' out here? I've posted five times out here and haven't received a response that remotely touches anything that I've ever come up with. Oh well.
Still at the same place. I created another ssis package and pointed it to the local folders and ran via a console app and it works fine. Most likely permissions. Someone suggested turning logging on the package. Not sure which logging they were referring to.
Thanks,
Lee
Package configurations. Right click on the control flow, select logging.
MSTDC and windows domain
Hi,
i have this scenario :
a have web application (NT4) that use a MSTDC service on my application
server (NT4) and DB and MSDTC on my cluster windows (2000/SQL2000)
The service MSTDC on application server and db server start with the same
domain administration account (administrator)
Now i have install a new domain windwos 2003 and a new cluster SQL2000/MSTDC
on 2 windows 2003 server and try to modify my application to point to new
windows 2003 cluster but when i try to test it a error appared :
Server: Msg 7391, Level 16, State 1, Line 2
The operation could not be performed because the OLE DB provider 'SQLOLEDB'
was unable to begin a distributed transaction. OLE/DB provider returned
message: New transaction cannot enlist in the specified transaction
coordinator.
and found a kb article and make the modify adding a network service into
MSDTC service on cluster 2003 but the problem is not resoleved! :-(
This is because are 2 different domain and network service on 2003 isn't any
account on NT4 domain ?
If i try to trust a windows 2003 and NT4 domain i resolved it ?
The trust is only one solution or exist other solution ?
Thanks in advance.
make sure you are ussing the cluster version of DTC. On each node you
should have run comclust.exe.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
<io.com> wrote in message news:%23NqzJ1I5EHA.2624@.TK2MSFTNGP11.phx.gbl...
> Hi,
> i have this scenario :
> a have web application (NT4) that use a MSTDC service on my application
> server (NT4) and DB and MSDTC on my cluster windows (2000/SQL2000)
> The service MSTDC on application server and db server start with the same
> domain administration account (administrator)
> Now i have install a new domain windwos 2003 and a new cluster
SQL2000/MSTDC
> on 2 windows 2003 server and try to modify my application to point to new
> windows 2003 cluster but when i try to test it a error appared :
> Server: Msg 7391, Level 16, State 1, Line 2
> The operation could not be performed because the OLE DB provider
'SQLOLEDB'
> was unable to begin a distributed transaction. OLE/DB provider returned
> message: New transaction cannot enlist in the specified transaction
> coordinator.
> and found a kb article and make the modify adding a network service into
> MSDTC service on cluster 2003 but the problem is not resoleved! :-(
> This is because are 2 different domain and network service on 2003 isn't
any
> account on NT4 domain ?
> If i try to trust a windows 2003 and NT4 domain i resolved it ?
> The trust is only one solution or exist other solution ?
> Thanks in advance.
>
|||Hi,
yes ai use DTC cluster .
But on windows2003 for clustering DTC i don't type comclust but i must
create it manuallty ,
are you sure ?
Thanks.
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:%23C7I0Pp5EHA.2572@.tk2msftngp13.phx.gbl...
> make sure you are ussing the cluster version of DTC. On each node you
> should have run comclust.exe.
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> <io.com> wrote in message news:%23NqzJ1I5EHA.2624@.TK2MSFTNGP11.phx.gbl...
> SQL2000/MSTDC
> 'SQLOLEDB'
> any
>
|||Hi,
i foun a solutiontoi my problem , the solution is :
- Trust 2 way from NT4 and 2K3
- Modify lmhost/host file for all server that are involved (i try for 2
hour first found the the optimal configuration of this file)
I habve used dctping.exe and dctester.exe for troubleshooting
And now work
Other solution instead trust is :
http://support.microsoft.com/default...b;en-us;827805
Thanks !
this is happy day!
:-)
<io.com> wrote in message news:%23NqzJ1I5EHA.2624@.TK2MSFTNGP11.phx.gbl...
> Hi,
> i have this scenario :
> a have web application (NT4) that use a MSTDC service on my application
> server (NT4) and DB and MSDTC on my cluster windows (2000/SQL2000)
> The service MSTDC on application server and db server start with the same
> domain administration account (administrator)
> Now i have install a new domain windwos 2003 and a new cluster
> SQL2000/MSTDC on 2 windows 2003 server and try to modify my application to
> point to new windows 2003 cluster but when i try to test it a error
> appared :
> Server: Msg 7391, Level 16, State 1, Line 2
> The operation could not be performed because the OLE DB provider
> 'SQLOLEDB'
> was unable to begin a distributed transaction. OLE/DB provider returned
> message: New transaction cannot enlist in the specified transaction
> coordinator.
> and found a kb article and make the modify adding a network service into
> MSDTC service on cluster 2003 but the problem is not resoleved! :-(
> This is because are 2 different domain and network service on 2003 isn't
> any account on NT4 domain ?
> If i try to trust a windows 2003 and NT4 domain i resolved it ?
> The trust is only one solution or exist other solution ?
> Thanks in advance.
>
i have this scenario :
a have web application (NT4) that use a MSTDC service on my application
server (NT4) and DB and MSDTC on my cluster windows (2000/SQL2000)
The service MSTDC on application server and db server start with the same
domain administration account (administrator)
Now i have install a new domain windwos 2003 and a new cluster SQL2000/MSTDC
on 2 windows 2003 server and try to modify my application to point to new
windows 2003 cluster but when i try to test it a error appared :
Server: Msg 7391, Level 16, State 1, Line 2
The operation could not be performed because the OLE DB provider 'SQLOLEDB'
was unable to begin a distributed transaction. OLE/DB provider returned
message: New transaction cannot enlist in the specified transaction
coordinator.
and found a kb article and make the modify adding a network service into
MSDTC service on cluster 2003 but the problem is not resoleved! :-(
This is because are 2 different domain and network service on 2003 isn't any
account on NT4 domain ?
If i try to trust a windows 2003 and NT4 domain i resolved it ?
The trust is only one solution or exist other solution ?
Thanks in advance.
make sure you are ussing the cluster version of DTC. On each node you
should have run comclust.exe.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
<io.com> wrote in message news:%23NqzJ1I5EHA.2624@.TK2MSFTNGP11.phx.gbl...
> Hi,
> i have this scenario :
> a have web application (NT4) that use a MSTDC service on my application
> server (NT4) and DB and MSDTC on my cluster windows (2000/SQL2000)
> The service MSTDC on application server and db server start with the same
> domain administration account (administrator)
> Now i have install a new domain windwos 2003 and a new cluster
SQL2000/MSTDC
> on 2 windows 2003 server and try to modify my application to point to new
> windows 2003 cluster but when i try to test it a error appared :
> Server: Msg 7391, Level 16, State 1, Line 2
> The operation could not be performed because the OLE DB provider
'SQLOLEDB'
> was unable to begin a distributed transaction. OLE/DB provider returned
> message: New transaction cannot enlist in the specified transaction
> coordinator.
> and found a kb article and make the modify adding a network service into
> MSDTC service on cluster 2003 but the problem is not resoleved! :-(
> This is because are 2 different domain and network service on 2003 isn't
any
> account on NT4 domain ?
> If i try to trust a windows 2003 and NT4 domain i resolved it ?
> The trust is only one solution or exist other solution ?
> Thanks in advance.
>
|||Hi,
yes ai use DTC cluster .
But on windows2003 for clustering DTC i don't type comclust but i must
create it manuallty ,
are you sure ?
Thanks.
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:%23C7I0Pp5EHA.2572@.tk2msftngp13.phx.gbl...
> make sure you are ussing the cluster version of DTC. On each node you
> should have run comclust.exe.
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> <io.com> wrote in message news:%23NqzJ1I5EHA.2624@.TK2MSFTNGP11.phx.gbl...
> SQL2000/MSTDC
> 'SQLOLEDB'
> any
>
|||Hi,
i foun a solutiontoi my problem , the solution is :
- Trust 2 way from NT4 and 2K3
- Modify lmhost/host file for all server that are involved (i try for 2
hour first found the the optimal configuration of this file)
I habve used dctping.exe and dctester.exe for troubleshooting
And now work
Other solution instead trust is :
http://support.microsoft.com/default...b;en-us;827805
Thanks !
this is happy day!
:-)
<io.com> wrote in message news:%23NqzJ1I5EHA.2624@.TK2MSFTNGP11.phx.gbl...
> Hi,
> i have this scenario :
> a have web application (NT4) that use a MSTDC service on my application
> server (NT4) and DB and MSDTC on my cluster windows (2000/SQL2000)
> The service MSTDC on application server and db server start with the same
> domain administration account (administrator)
> Now i have install a new domain windwos 2003 and a new cluster
> SQL2000/MSTDC on 2 windows 2003 server and try to modify my application to
> point to new windows 2003 cluster but when i try to test it a error
> appared :
> Server: Msg 7391, Level 16, State 1, Line 2
> The operation could not be performed because the OLE DB provider
> 'SQLOLEDB'
> was unable to begin a distributed transaction. OLE/DB provider returned
> message: New transaction cannot enlist in the specified transaction
> coordinator.
> and found a kb article and make the modify adding a network service into
> MSDTC service on cluster 2003 but the problem is not resoleved! :-(
> This is because are 2 different domain and network service on 2003 isn't
> any account on NT4 domain ?
> If i try to trust a windows 2003 and NT4 domain i resolved it ?
> The trust is only one solution or exist other solution ?
> Thanks in advance.
>
MSTDC and windows domain
Hi,
i have this scenario :
a have web application (NT4) that use a MSTDC service on my application
server (NT4) and DB and MSDTC on my cluster windows (2000/SQL2000)
The service MSTDC on application server and db server start with the same
domain administration account (administrator)
Now i have install a new domain windwos 2003 and a new cluster SQL2000/MSTDC
on 2 windows 2003 server and try to modify my application to point to new
windows 2003 cluster but when i try to test it a error appared :
Server: Msg 7391, Level 16, State 1, Line 2
The operation could not be performed because the OLE DB provider 'SQLOLEDB'
was unable to begin a distributed transaction. OLE/DB provider returned
message: New transaction cannot enlist in the specified transaction
coordinator.
and found a kb article and make the modify adding a network service into
MSDTC service on cluster 2003 but the problem is not resoleved! :-(
This is because are 2 different domain and network service on 2003 isn't any
account on NT4 domain ?
If i try to trust a windows 2003 and NT4 domain i resolved it ?
The trust is only one solution or exist other solution ?
Thanks in advance.make sure you are ussing the cluster version of DTC. On each node you
should have run comclust.exe.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
<io.com> wrote in message news:%23NqzJ1I5EHA.2624@.TK2MSFTNGP11.phx.gbl...
> Hi,
> i have this scenario :
> a have web application (NT4) that use a MSTDC service on my application
> server (NT4) and DB and MSDTC on my cluster windows (2000/SQL2000)
> The service MSTDC on application server and db server start with the same
> domain administration account (administrator)
> Now i have install a new domain windwos 2003 and a new cluster
SQL2000/MSTDC
> on 2 windows 2003 server and try to modify my application to point to new
> windows 2003 cluster but when i try to test it a error appared :
> Server: Msg 7391, Level 16, State 1, Line 2
> The operation could not be performed because the OLE DB provider
'SQLOLEDB'
> was unable to begin a distributed transaction. OLE/DB provider returned
> message: New transaction cannot enlist in the specified transaction
> coordinator.
> and found a kb article and make the modify adding a network service into
> MSDTC service on cluster 2003 but the problem is not resoleved! :-(
> This is because are 2 different domain and network service on 2003 isn't
any
> account on NT4 domain ?
> If i try to trust a windows 2003 and NT4 domain i resolved it ?
> The trust is only one solution or exist other solution ?
> Thanks in advance.
>|||Hi,
yes ai use DTC cluster .
But on windows2003 for clustering DTC i don't type comclust but i must
create it manuallty ,
are you sure ?
Thanks.
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:%23C7I0Pp5EHA.2572@.tk2msftngp13.phx.gbl...
> make sure you are ussing the cluster version of DTC. On each node you
> should have run comclust.exe.
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> <io.com> wrote in message news:%23NqzJ1I5EHA.2624@.TK2MSFTNGP11.phx.gbl...
>> Hi,
>> i have this scenario :
>> a have web application (NT4) that use a MSTDC service on my application
>> server (NT4) and DB and MSDTC on my cluster windows (2000/SQL2000)
>> The service MSTDC on application server and db server start with the same
>> domain administration account (administrator)
>> Now i have install a new domain windwos 2003 and a new cluster
> SQL2000/MSTDC
>> on 2 windows 2003 server and try to modify my application to point to new
>> windows 2003 cluster but when i try to test it a error appared :
>> Server: Msg 7391, Level 16, State 1, Line 2
>> The operation could not be performed because the OLE DB provider
> 'SQLOLEDB'
>> was unable to begin a distributed transaction. OLE/DB provider returned
>> message: New transaction cannot enlist in the specified transaction
>> coordinator.
>> and found a kb article and make the modify adding a network service into
>> MSDTC service on cluster 2003 but the problem is not resoleved! :-(
>> This is because are 2 different domain and network service on 2003 isn't
> any
>> account on NT4 domain ?
>> If i try to trust a windows 2003 and NT4 domain i resolved it ?
>> The trust is only one solution or exist other solution ?
>> Thanks in advance.
>>
>|||Hi,
i foun a solutiontoi my problem , the solution is :
- Trust 2 way from NT4 and 2K3
- Modify lmhost/host file for all server that are involved (i try for 2
hour first found the the optimal configuration of this file)
I habve used dctping.exe and dctester.exe for troubleshooting
And now work
Other solution instead trust is :
http://support.microsoft.com/default.aspx?scid=kb;en-us;827805http://support.microsoft.com/default.aspx?scid=kb;en-us;827805
Thanks !
this is happy day!
:-)
<io.com> wrote in message news:%23NqzJ1I5EHA.2624@.TK2MSFTNGP11.phx.gbl...
> Hi,
> i have this scenario :
> a have web application (NT4) that use a MSTDC service on my application
> server (NT4) and DB and MSDTC on my cluster windows (2000/SQL2000)
> The service MSTDC on application server and db server start with the same
> domain administration account (administrator)
> Now i have install a new domain windwos 2003 and a new cluster
> SQL2000/MSTDC on 2 windows 2003 server and try to modify my application to
> point to new windows 2003 cluster but when i try to test it a error
> appared :
> Server: Msg 7391, Level 16, State 1, Line 2
> The operation could not be performed because the OLE DB provider
> 'SQLOLEDB'
> was unable to begin a distributed transaction. OLE/DB provider returned
> message: New transaction cannot enlist in the specified transaction
> coordinator.
> and found a kb article and make the modify adding a network service into
> MSDTC service on cluster 2003 but the problem is not resoleved! :-(
> This is because are 2 different domain and network service on 2003 isn't
> any account on NT4 domain ?
> If i try to trust a windows 2003 and NT4 domain i resolved it ?
> The trust is only one solution or exist other solution ?
> Thanks in advance.
>
i have this scenario :
a have web application (NT4) that use a MSTDC service on my application
server (NT4) and DB and MSDTC on my cluster windows (2000/SQL2000)
The service MSTDC on application server and db server start with the same
domain administration account (administrator)
Now i have install a new domain windwos 2003 and a new cluster SQL2000/MSTDC
on 2 windows 2003 server and try to modify my application to point to new
windows 2003 cluster but when i try to test it a error appared :
Server: Msg 7391, Level 16, State 1, Line 2
The operation could not be performed because the OLE DB provider 'SQLOLEDB'
was unable to begin a distributed transaction. OLE/DB provider returned
message: New transaction cannot enlist in the specified transaction
coordinator.
and found a kb article and make the modify adding a network service into
MSDTC service on cluster 2003 but the problem is not resoleved! :-(
This is because are 2 different domain and network service on 2003 isn't any
account on NT4 domain ?
If i try to trust a windows 2003 and NT4 domain i resolved it ?
The trust is only one solution or exist other solution ?
Thanks in advance.make sure you are ussing the cluster version of DTC. On each node you
should have run comclust.exe.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
<io.com> wrote in message news:%23NqzJ1I5EHA.2624@.TK2MSFTNGP11.phx.gbl...
> Hi,
> i have this scenario :
> a have web application (NT4) that use a MSTDC service on my application
> server (NT4) and DB and MSDTC on my cluster windows (2000/SQL2000)
> The service MSTDC on application server and db server start with the same
> domain administration account (administrator)
> Now i have install a new domain windwos 2003 and a new cluster
SQL2000/MSTDC
> on 2 windows 2003 server and try to modify my application to point to new
> windows 2003 cluster but when i try to test it a error appared :
> Server: Msg 7391, Level 16, State 1, Line 2
> The operation could not be performed because the OLE DB provider
'SQLOLEDB'
> was unable to begin a distributed transaction. OLE/DB provider returned
> message: New transaction cannot enlist in the specified transaction
> coordinator.
> and found a kb article and make the modify adding a network service into
> MSDTC service on cluster 2003 but the problem is not resoleved! :-(
> This is because are 2 different domain and network service on 2003 isn't
any
> account on NT4 domain ?
> If i try to trust a windows 2003 and NT4 domain i resolved it ?
> The trust is only one solution or exist other solution ?
> Thanks in advance.
>|||Hi,
yes ai use DTC cluster .
But on windows2003 for clustering DTC i don't type comclust but i must
create it manuallty ,
are you sure ?
Thanks.
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:%23C7I0Pp5EHA.2572@.tk2msftngp13.phx.gbl...
> make sure you are ussing the cluster version of DTC. On each node you
> should have run comclust.exe.
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> <io.com> wrote in message news:%23NqzJ1I5EHA.2624@.TK2MSFTNGP11.phx.gbl...
>> Hi,
>> i have this scenario :
>> a have web application (NT4) that use a MSTDC service on my application
>> server (NT4) and DB and MSDTC on my cluster windows (2000/SQL2000)
>> The service MSTDC on application server and db server start with the same
>> domain administration account (administrator)
>> Now i have install a new domain windwos 2003 and a new cluster
> SQL2000/MSTDC
>> on 2 windows 2003 server and try to modify my application to point to new
>> windows 2003 cluster but when i try to test it a error appared :
>> Server: Msg 7391, Level 16, State 1, Line 2
>> The operation could not be performed because the OLE DB provider
> 'SQLOLEDB'
>> was unable to begin a distributed transaction. OLE/DB provider returned
>> message: New transaction cannot enlist in the specified transaction
>> coordinator.
>> and found a kb article and make the modify adding a network service into
>> MSDTC service on cluster 2003 but the problem is not resoleved! :-(
>> This is because are 2 different domain and network service on 2003 isn't
> any
>> account on NT4 domain ?
>> If i try to trust a windows 2003 and NT4 domain i resolved it ?
>> The trust is only one solution or exist other solution ?
>> Thanks in advance.
>>
>|||Hi,
i foun a solutiontoi my problem , the solution is :
- Trust 2 way from NT4 and 2K3
- Modify lmhost/host file for all server that are involved (i try for 2
hour first found the the optimal configuration of this file)
I habve used dctping.exe and dctester.exe for troubleshooting
And now work
Other solution instead trust is :
http://support.microsoft.com/default.aspx?scid=kb;en-us;827805http://support.microsoft.com/default.aspx?scid=kb;en-us;827805
Thanks !
this is happy day!
:-)
<io.com> wrote in message news:%23NqzJ1I5EHA.2624@.TK2MSFTNGP11.phx.gbl...
> Hi,
> i have this scenario :
> a have web application (NT4) that use a MSTDC service on my application
> server (NT4) and DB and MSDTC on my cluster windows (2000/SQL2000)
> The service MSTDC on application server and db server start with the same
> domain administration account (administrator)
> Now i have install a new domain windwos 2003 and a new cluster
> SQL2000/MSTDC on 2 windows 2003 server and try to modify my application to
> point to new windows 2003 cluster but when i try to test it a error
> appared :
> Server: Msg 7391, Level 16, State 1, Line 2
> The operation could not be performed because the OLE DB provider
> 'SQLOLEDB'
> was unable to begin a distributed transaction. OLE/DB provider returned
> message: New transaction cannot enlist in the specified transaction
> coordinator.
> and found a kb article and make the modify adding a network service into
> MSDTC service on cluster 2003 but the problem is not resoleved! :-(
> This is because are 2 different domain and network service on 2003 isn't
> any account on NT4 domain ?
> If i try to trust a windows 2003 and NT4 domain i resolved it ?
> The trust is only one solution or exist other solution ?
> Thanks in advance.
>
MSSQLService (MSDE) Not Re-Configured correctly
Hi all,
I have a question regarding restarting MS SQL Service under a different user, in other words, re-starting MSSQLService as a "Log on as" user instead of "Local System" account. By default MSSQLService starts as a local system account.
Now my problem is, that I install MSDE 2000 for my application. And I install it as a seperate instance with name "MyInstance". So after Install my service is called MSSQL$MyInstance.
so my process basically creates an NT user on the machine with administartors rights, stops the service, change the service configuration to my NT user account credentials and then starts it using scm. The whole process works fine on my machine running Win XP Pro v.2002 SP1. But it fails to work on Win XP Pro v2002 SP2.
on SP2 machine, service gets reconfigured because I can see the Log on as account being changed from Local System to MyNTUser. But when I try to start it every time error is "Log on failure". But when I go to service properties and change the Password to my NT users password service starts properly.
So i'm not sure what exactly is going on, because if reconfiguration process works for my machine, typically it should work on SP2 machine as well, as the notes on ChangeServiceConfig winapi method(requires Advapi32.dll) suggests that it will work for XP, NT and win 2002.
Does anyone has any idea why is that.
Code Snippets:
Create User:
DirectoryEntry AD = new DirectoryEntry("WinNT://" + machineName + ", computer");
DirectoryEntry newUser;
try {
newUser = AD.Children.Find(userName, "user");
DeleteNTUserAccount(userName);
newUser = AD.Children.Add(userName, "user");
}
catch (Exception) {
newUser = AD.Children.Add(userName, "user");
}
newUser.Invoke("Put", new object[] {"Description", userDescription});
newUser.Invoke("SetPassword", new object[] {userPWD});
newUser.CommitChanges();
DirectoryEntry group;
group = AD.Children.Find("Administrators", "group");
if (group != null)
group.Invoke("Add", new object[] {newUser.Path.ToString()});
group.Close();
newUser.Close();
AD.Close();
Code to Stop Service:
ServiceController sc;
TimeSpan timeout = new TimeSpan(0, 0, 60);
OperatingSystem os;
os = Environment.OSVersion;
if (os.Platform != PlatformID.Win32NT) {
txtInstallInfo.Text += "\r\n\tApplication is built only for NT, 2000, XP or Later";
this.Refresh();
retVal = false;
}
os = null;
sc = new ServiceController(serviceName);
if (sc.Status == ServiceControllerStatus.Running) {
if (sc.CanStop) {
txtInstallInfo.Text += "\r\n\tRestarting the " + serviceName + " service";
this.Refresh();
sc.Stop();
try {
sc.WaitForStatus(ServiceControllerStatus.Stopped, timeout);
txtInstallInfo.Text += "\r\n\t" + serviceName + " service stopped successfully";
this.Refresh();
}
catch(TimeoutException) {
txtInstallInfo.Text += "\r\n\t" + serviceName + " service did not respond to the stop command in a timely fashion. Please Restart Installer at later time.";
this.Refresh();
retVal = false;
}
}
else {
txtInstallInfo.Text += "\r\n\t" + serviceName + " service cannot be stopped. Please Wait make sure no application is running.";
this.Refresh();
retVal = false;
}
}
else {
txtInstallInfo.Text += "\r\n\t" + serviceName + " service was not running.";
this.Refresh();
}
sc.Close();
sc = null;
Code to Re-Configure Service:
string UserName = "MyNTUser";
string UserPwd = "abc123";
int HandleToScm = OpenSCManager( null, null, ServiceControlAccessRights.AllAccess );
int HandleToSvc = OpenService( HandleToScm, ServiceName, ServiceSpecificAccessType.ChangeConfig );
if ( ChangeServiceConfig(
HandleToSvc,
ServiceControlType.OwnProcess,
ServiceStartType.AutoStart,
ServiceNoChange,
null,
null,
IntPtr.Zero,
null,
@.".\" + UserName,
UserPwd,
ServiceName ) ) {
CloseServiceHandle( HandleToSvc );
CloseServiceHandle( HandleToScm );
}
Code to Start Service:
scm -Action 1 -Service MSSQL$MyInstance -Silent 1 -SvcAccount .\MYNTUserAccount -SvcPwd MYNTAccountPassword
I've never seen this post before, yet it is dated May 2005. Bumping message...sqlMSSQLServerOLAPSevice
all of a sudden my MSSQLServerOLAPSevice are stopped, rest all services are
working excelp OLAP services, i even restarted the server. In service manager
it shows 'Starting' on status bar. when i try to connect server through MSA
it gives me error 'cannot open connection to Analysis server the server is
either not started or is too busy', Can anyone help me, it's very urgent
This sounds like it could be related to KB 883656. I have seen this at a client site, where AS would restart itself every 20-30 seconds, and you will see the state cycle in Service Manager.
There is a hotfix for this bug, and it is also included in the new SP4. In order to recover from the corrupted state to allow you to apply the service pack, you'll need to do the following:
1) Using the SQL Server Service Manager, select the MSSQLServerOLAPService in the second (Services) drop-down list. Uncheck the “Auto-start service when OS starts” box.
2) Close the Service Manger. Reboot the server to get the restart process to stop looping.
3) Rename the data folder where Analysis Services stores its databases. By default, this is c:\Program Files\Microsoft Analysis Services\Data but it may be different on your system, particularly if there are alternate drives. The folder in question will have subfolders along this structure:
… Data
MyASDatabase
MyCube1
MyCube2
MyCube3
and these lowest level folders will have the many data and aggregate files for each cube inside them.
4) Create a new folder in the same directory called Data
5) Restart Analysis Services through the SQL Server Service Manager by selecting the MSSQLServerOLAPService in the second (Services) drop-down list and clicking the Start icon. Also, check the “Auto-start service when OS starts” box. Close the Service Manager.
This should get your instance back to normal, the cubes will rebuild from the stored metadata next time that you use them. You will need to reprocess.
"Pravin" <Pravin@.discussions.microsoft.com> wrote in message news:64D82324-1604-4627-8A9E-67186A547AA2@.microsoft.com...
> all of a sudden my MSSQLServerOLAPSevice are stopped, rest all services are
> working excelp OLAP services, i even restarted the server. In service manager
> it shows 'Starting' on status bar. when i try to connect server through MSA
> it gives me error 'cannot open connection to Analysis server the server is
> either not started or is too busy', Can anyone help me, it's very urgent
working excelp OLAP services, i even restarted the server. In service manager
it shows 'Starting' on status bar. when i try to connect server through MSA
it gives me error 'cannot open connection to Analysis server the server is
either not started or is too busy', Can anyone help me, it's very urgent
This sounds like it could be related to KB 883656. I have seen this at a client site, where AS would restart itself every 20-30 seconds, and you will see the state cycle in Service Manager.
There is a hotfix for this bug, and it is also included in the new SP4. In order to recover from the corrupted state to allow you to apply the service pack, you'll need to do the following:
1) Using the SQL Server Service Manager, select the MSSQLServerOLAPService in the second (Services) drop-down list. Uncheck the “Auto-start service when OS starts” box.
2) Close the Service Manger. Reboot the server to get the restart process to stop looping.
3) Rename the data folder where Analysis Services stores its databases. By default, this is c:\Program Files\Microsoft Analysis Services\Data but it may be different on your system, particularly if there are alternate drives. The folder in question will have subfolders along this structure:
… Data
MyASDatabase
MyCube1
MyCube2
MyCube3
and these lowest level folders will have the many data and aggregate files for each cube inside them.
4) Create a new folder in the same directory called Data
5) Restart Analysis Services through the SQL Server Service Manager by selecting the MSSQLServerOLAPService in the second (Services) drop-down list and clicking the Start icon. Also, check the “Auto-start service when OS starts” box. Close the Service Manager.
This should get your instance back to normal, the cubes will rebuild from the stored metadata next time that you use them. You will need to reprocess.
"Pravin" <Pravin@.discussions.microsoft.com> wrote in message news:64D82324-1604-4627-8A9E-67186A547AA2@.microsoft.com...
> all of a sudden my MSSQLServerOLAPSevice are stopped, rest all services are
> working excelp OLAP services, i even restarted the server. In service manager
> it shows 'Starting' on status bar. when i try to connect server through MSA
> it gives me error 'cannot open connection to Analysis server the server is
> either not started or is too busy', Can anyone help me, it's very urgent
MSSQLServerOLAPSevice
all of a sudden my MSSQLServerOLAPSevice are stopped, rest all services are
working excelp OLAP services, i even restarted the server. In service manage
r
it shows 'Starting' on status bar. when i try to connect server through MSA
it gives me error 'cannot open connection to Analysis server the server is
either not started or is too busy', Can anyone help me, it's very urgentThis sounds like it could be related to KB 883656. I have seen this at a cl
ient site, where AS would restart itself every 20-30 seconds, and you will s
ee the state cycle in Service Manager.
There is a hotfix for this bug, and it is also included in the new SP4. In
order to recover from the corrupted state to allow you to apply the service
pack, you'll need to do the following:
1) Using the SQL Server Service Manager, select the MSSQLServerOLAPSer
vice in the second (Services) drop-down list. Uncheck the “Auto-start ser
vice when OS starts” box.
2) Close the Service Manger. Reboot the server to get the restart pro
cess to stop looping.
3) Rename the data folder where Analysis Services stores its databases
. By default, this is c:\Program Files\Microsoft Analysis Services\Data but
it may be different on your system, particularly if there are alternate dri
ves. The folder in question will have subfolders along this structure:
… Data
MyASDatabase
MyCube1
MyCube2
MyCube3
and these lowest level folders will have the many data and aggregate files f
or each cube inside them.
4) Create a new folder in the same directory called Data
5) Restart Analysis Services through the SQL Server Service Manager by
selecting the MSSQLServerOLAPService in the second (Services) drop-down lis
t and clicking the Start icon. Also, check the “Auto-start service when O
S starts” box. Close the Service Manager.
This should get your instance back to normal, the cubes will rebuild from th
e stored metadata next time that you use them. You will need to reprocess.
"Pravin" <Pravin@.discussions.microsoft.com> wrote in message news:64D82324-1604-4627-8A9E-67
186A547AA2@.microsoft.com...
> all of a sudden my MSSQLServerOLAPSevice are stopped, rest all services ar
e
> working excelp OLAP services, i even restarted the server. In service mana
ger
> it shows 'Starting' on status bar. when i try to connect server through M
SA
> it gives me error 'cannot open connection to Analysis server the server is
> either not started or is too busy', Can anyone help me, it's very urgent
working excelp OLAP services, i even restarted the server. In service manage
r
it shows 'Starting' on status bar. when i try to connect server through MSA
it gives me error 'cannot open connection to Analysis server the server is
either not started or is too busy', Can anyone help me, it's very urgentThis sounds like it could be related to KB 883656. I have seen this at a cl
ient site, where AS would restart itself every 20-30 seconds, and you will s
ee the state cycle in Service Manager.
There is a hotfix for this bug, and it is also included in the new SP4. In
order to recover from the corrupted state to allow you to apply the service
pack, you'll need to do the following:
1) Using the SQL Server Service Manager, select the MSSQLServerOLAPSer
vice in the second (Services) drop-down list. Uncheck the “Auto-start ser
vice when OS starts” box.
2) Close the Service Manger. Reboot the server to get the restart pro
cess to stop looping.
3) Rename the data folder where Analysis Services stores its databases
. By default, this is c:\Program Files\Microsoft Analysis Services\Data but
it may be different on your system, particularly if there are alternate dri
ves. The folder in question will have subfolders along this structure:
… Data
MyASDatabase
MyCube1
MyCube2
MyCube3
and these lowest level folders will have the many data and aggregate files f
or each cube inside them.
4) Create a new folder in the same directory called Data
5) Restart Analysis Services through the SQL Server Service Manager by
selecting the MSSQLServerOLAPService in the second (Services) drop-down lis
t and clicking the Start icon. Also, check the “Auto-start service when O
S starts” box. Close the Service Manager.
This should get your instance back to normal, the cubes will rebuild from th
e stored metadata next time that you use them. You will need to reprocess.
"Pravin" <Pravin@.discussions.microsoft.com> wrote in message news:64D82324-1604-4627-8A9E-67
186A547AA2@.microsoft.com...
> all of a sudden my MSSQLServerOLAPSevice are stopped, rest all services ar
e
> working excelp OLAP services, i even restarted the server. In service mana
ger
> it shows 'Starting' on status bar. when i try to connect server through M
SA
> it gives me error 'cannot open connection to Analysis server the server is
> either not started or is too busy', Can anyone help me, it's very urgent
MSSQLServerOLAPService Stops
MSSQLServerOLAPService Service seems to crash rather sporadically during our nightly ETL with the error of:
The description for Event ID ( 22 ) in Source ( MSSQLServerOLAPService ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Internal error: An unexpected exception occured. Internal error: An unexpected exception occured..
The time of the error in the event viewer seems to correspond with the step in the ETL that processes our AS 2005 database (Analysis Services Command Task). The job step reports success, and the data is refreshed so I don't understand why it is reporting an error in Event Viewer.
The server is x86 with SQL 2005 sp2 installed.
Has anyone else run across this?
I'm getting the same issue when I run a particular MDX query. I'm also on x86 with SQL 2005 sp2 installed. Please post if you find anything out.
Thanks,
Craig
MSSQLServerADHelper Service?
Hi,
while going through the service I noticed that the MSSQLServerADHelper Service is set to run manually.
I wanted to know what this service does and should it set it to run automatically?
Thanks.Hey Joozh, did the answer on SQLTeam get you covered for this?|||Yes..almost :)
Thanks ;)sql
while going through the service I noticed that the MSSQLServerADHelper Service is set to run manually.
I wanted to know what this service does and should it set it to run automatically?
Thanks.Hey Joozh, did the answer on SQLTeam get you covered for this?|||Yes..almost :)
Thanks ;)sql
mssqlserverADhelper service terminated, Access Denied when trying to connect
This problem just started recently. This computer connected to the database
when it was first installed. All computer are new Compaq running Windows xp
pro.
This is a problem with MSDE. We are running MS Retail Management system.
One Point of Sale station won't connect to the server. I am running MSDE on
4 computers. One is the peer server it is named "serverxp" the one that
won't connect is "POS2". Other computers are POS1 and notebook. Below is
the case notes so far.
This one POS station is having a problem connection to the server database.
It has no problem connecting to the local database. What I see is on the SQL
Service Manager, When I select the network server "ServerXP" there is
nothing in the dropdown for services. When I select the local server then
three options are listed Dist. Tran, SQL Server and SQL Server agent.
This POS2 computer can connect to ServerXP and see shared folders etc. So I
haven't found any problem with the LAN or hardware.
Can you tell by this description what is wrong or what to try to do to fix
this?
Thanks
----
6/9/2004 1:28:00 PM CDT -- Allison Haaland
Steven,
I have a few more questions for you in order to further troubleshoot this
issue:
1. When you look at the SQL Server Service Manager and choose the "ServerXP"
option, does it say Not Connected at the bottom? yes
2. When you select the local server option in SQL Server Service Manager,
can you then connect to the database in Administrator? (You would choose
local as your server in Administrator as well.) yes
3. If you go to Start | Control | Administrative Tools | Services, do you
see your MSSQL and SQLAgent options there? If so, is the Status showing as
'Started'? If not, you should make sure that the Services are started if
you're trying to use them.
.MSSQLServer is started
MSSQLServerADhelper is set to manual and will not start "could not start
access denied"
4. Is there anything else that is different about this workstation from the
others? This might help us find out why it is not working, but all of the
others are. no
Thanks,
Allison
----
6/9/2004 3:51:00 PM CDT -- Steven
Allison:
More Info. An error in the System error log shows.
The mssqlserverADhelper service terminated with service specific error
3221225572 error 2270 refer to Knowledge base 314094. ID 7024
this is talking about the computer name. The name of this PC is POS2 it is
unique on this network.
----
6/9/2004 4:43:00 PM CDT -- Allison Haaland
Steven,
It looks like the error you are running into now is a network related issue
related to your computer name. I see that you have already referenced
Knowledge base article #314094 - have you tried the steps that it gives to
resolve this error? YES.
POS2 was working correctly at the time it was installed. No name have been
changed.
Can anyone with more experience working with SQL server give me some help
correcting this problem? Thank you.Hi Steve,
What error is generated with the connection fails?
Create an ODBC Test DSN and post the entire message here.
The ADHelper servers is not required for machines to connect to one
another. It's used to publish objects to Active Directory.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
when it was first installed. All computer are new Compaq running Windows xp
pro.
This is a problem with MSDE. We are running MS Retail Management system.
One Point of Sale station won't connect to the server. I am running MSDE on
4 computers. One is the peer server it is named "serverxp" the one that
won't connect is "POS2". Other computers are POS1 and notebook. Below is
the case notes so far.
This one POS station is having a problem connection to the server database.
It has no problem connecting to the local database. What I see is on the SQL
Service Manager, When I select the network server "ServerXP" there is
nothing in the dropdown for services. When I select the local server then
three options are listed Dist. Tran, SQL Server and SQL Server agent.
This POS2 computer can connect to ServerXP and see shared folders etc. So I
haven't found any problem with the LAN or hardware.
Can you tell by this description what is wrong or what to try to do to fix
this?
Thanks
----
6/9/2004 1:28:00 PM CDT -- Allison Haaland
Steven,
I have a few more questions for you in order to further troubleshoot this
issue:
1. When you look at the SQL Server Service Manager and choose the "ServerXP"
option, does it say Not Connected at the bottom? yes
2. When you select the local server option in SQL Server Service Manager,
can you then connect to the database in Administrator? (You would choose
local as your server in Administrator as well.) yes
3. If you go to Start | Control | Administrative Tools | Services, do you
see your MSSQL and SQLAgent options there? If so, is the Status showing as
'Started'? If not, you should make sure that the Services are started if
you're trying to use them.
.MSSQLServer is started
MSSQLServerADhelper is set to manual and will not start "could not start
access denied"
4. Is there anything else that is different about this workstation from the
others? This might help us find out why it is not working, but all of the
others are. no
Thanks,
Allison
----
6/9/2004 3:51:00 PM CDT -- Steven
Allison:
More Info. An error in the System error log shows.
The mssqlserverADhelper service terminated with service specific error
3221225572 error 2270 refer to Knowledge base 314094. ID 7024
this is talking about the computer name. The name of this PC is POS2 it is
unique on this network.
----
6/9/2004 4:43:00 PM CDT -- Allison Haaland
Steven,
It looks like the error you are running into now is a network related issue
related to your computer name. I see that you have already referenced
Knowledge base article #314094 - have you tried the steps that it gives to
resolve this error? YES.
POS2 was working correctly at the time it was installed. No name have been
changed.
Can anyone with more experience working with SQL server give me some help
correcting this problem? Thank you.Hi Steve,
What error is generated with the connection fails?
Create an ODBC Test DSN and post the entire message here.
The ADHelper servers is not required for machines to connect to one
another. It's used to publish objects to Active Directory.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
mssqlserverADhelper service terminated, Access Denied when trying to connect
This problem just started recently. This computer connected to the database
when it was first installed. All computer are new Compaq running Windows xp
pro.
This is a problem with MSDE. We are running MS Retail Management system.
One Point of Sale station won't connect to the server. I am running MSDE on
4 computers. One is the peer server it is named "serverxp" the one that
won't connect is "POS2". Other computers are POS1 and notebook. Below is
the case notes so far.
This one POS station is having a problem connection to the server database.
It has no problem connecting to the local database. What I see is on the SQL
Service Manager, When I select the network server "ServerXP" there is
nothing in the dropdown for services. When I select the local server then
three options are listed Dist. Tran, SQL Server and SQL Server agent.
This POS2 computer can connect to ServerXP and see shared folders etc. So I
haven't found any problem with the LAN or hardware.
Can you tell by this description what is wrong or what to try to do to fix
this?
Thanks
6/9/2004 1:28:00 PM CDT -- Allison Haaland
Steven,
I have a few more questions for you in order to further troubleshoot this
issue:
1. When you look at the SQL Server Service Manager and choose the "ServerXP"
option, does it say Not Connected at the bottom? yes
2. When you select the local server option in SQL Server Service Manager,
can you then connect to the database in Administrator? (You would choose
local as your server in Administrator as well.) yes
3. If you go to Start | Control | Administrative Tools | Services, do you
see your MSSQL and SQLAgent options there? If so, is the Status showing as
'Started'? If not, you should make sure that the Services are started if
you're trying to use them.
..MSSQLServer is started
MSSQLServerADhelper is set to manual and will not start "could not start
access denied"
4. Is there anything else that is different about this workstation from the
others? This might help us find out why it is not working, but all of the
others are. no
Thanks,
Allison
6/9/2004 3:51:00 PM CDT -- Steven
Allison:
More Info. An error in the System error log shows.
The mssqlserverADhelper service terminated with service specific error
3221225572 error 2270 refer to Knowledge base 314094. ID 7024
this is talking about the computer name. The name of this PC is POS2 it is
unique on this network.
6/9/2004 4:43:00 PM CDT -- Allison Haaland
Steven,
It looks like the error you are running into now is a network related issue
related to your computer name. I see that you have already referenced
Knowledge base article #314094 - have you tried the steps that it gives to
resolve this error? YES.
POS2 was working correctly at the time it was installed. No name have been
changed.
Can anyone with more experience working with SQL server give me some help
correcting this problem? Thank you.
Hi Steve,
What error is generated with the connection fails?
Create an ODBC Test DSN and post the entire message here.
The ADHelper servers is not required for machines to connect to one
another. It's used to publish objects to Active Directory.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
when it was first installed. All computer are new Compaq running Windows xp
pro.
This is a problem with MSDE. We are running MS Retail Management system.
One Point of Sale station won't connect to the server. I am running MSDE on
4 computers. One is the peer server it is named "serverxp" the one that
won't connect is "POS2". Other computers are POS1 and notebook. Below is
the case notes so far.
This one POS station is having a problem connection to the server database.
It has no problem connecting to the local database. What I see is on the SQL
Service Manager, When I select the network server "ServerXP" there is
nothing in the dropdown for services. When I select the local server then
three options are listed Dist. Tran, SQL Server and SQL Server agent.
This POS2 computer can connect to ServerXP and see shared folders etc. So I
haven't found any problem with the LAN or hardware.
Can you tell by this description what is wrong or what to try to do to fix
this?
Thanks
6/9/2004 1:28:00 PM CDT -- Allison Haaland
Steven,
I have a few more questions for you in order to further troubleshoot this
issue:
1. When you look at the SQL Server Service Manager and choose the "ServerXP"
option, does it say Not Connected at the bottom? yes
2. When you select the local server option in SQL Server Service Manager,
can you then connect to the database in Administrator? (You would choose
local as your server in Administrator as well.) yes
3. If you go to Start | Control | Administrative Tools | Services, do you
see your MSSQL and SQLAgent options there? If so, is the Status showing as
'Started'? If not, you should make sure that the Services are started if
you're trying to use them.
..MSSQLServer is started
MSSQLServerADhelper is set to manual and will not start "could not start
access denied"
4. Is there anything else that is different about this workstation from the
others? This might help us find out why it is not working, but all of the
others are. no
Thanks,
Allison
6/9/2004 3:51:00 PM CDT -- Steven
Allison:
More Info. An error in the System error log shows.
The mssqlserverADhelper service terminated with service specific error
3221225572 error 2270 refer to Knowledge base 314094. ID 7024
this is talking about the computer name. The name of this PC is POS2 it is
unique on this network.
6/9/2004 4:43:00 PM CDT -- Allison Haaland
Steven,
It looks like the error you are running into now is a network related issue
related to your computer name. I see that you have already referenced
Knowledge base article #314094 - have you tried the steps that it gives to
resolve this error? YES.
POS2 was working correctly at the time it was installed. No name have been
changed.
Can anyone with more experience working with SQL server give me some help
correcting this problem? Thank you.
Hi Steve,
What error is generated with the connection fails?
Create an ODBC Test DSN and post the entire message here.
The ADHelper servers is not required for machines to connect to one
another. It's used to publish objects to Active Directory.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
MSSQLServerADHelper Service Error on Reboot
I am running SQL Server 2000 sp 4 on Win2K Server sp 4.
Recently, I started getting an MSSQLServerADHelper service error. I can't
rely pin it on anything, other than I had a big database with 2 tables (7 and
20 million records respectively). I ran out of disk space trying to index
one of the tables.
Ultimately, I detached the database, because it was too much for my system.
Since then I have completely removed then reinstalled SQL Server and I still
get the following errors. The MSSQLServerADHelper is set to automatic, which
I believe is the correct state since is supposedly launched as needed. I
have done some research and cannot track down an answer. Any ideas?
Event Type:Error
Event Source:Service Control Manager
Event Category:None
Event ID:7024
Date:6/26/2005
Time:1:54:11 AM
User:N/A
Computer:MERLOT
Description:
The MSSQLServerADHelper service terminated with service-specific error
3221225572.
Event Type:Error
Event Source:MSSQLServerADHelper
Event Category:None
Event ID:100
Date:6/26/2005
Time:1:54:11 AM
User:N/A
Computer:MERLOT
Description:
'0' is an invalid number of start up parameters. This service takes two
start up parameters.
Event Type:Error
Event Source:MSSQLSERVER
Event Category:(2)
Event ID:17055
Date:6/26/2005
Time:2:33:04 PM
User:N/A
Computer:MERLOT
Description:
19012 :
SuperSocket Info: Bind failed on TCP port 1433.
Data:
0000: 44 4a 00 00 10 00 00 00 DJ.....
0008: 07 00 00 00 4d 00 45 00 ...M.E.
0010: 52 00 4c 00 4f 00 54 00 R.L.O.T.
0018: 00 00 00 00 00 00 .....
The MSSQLServerADHelper service should be set to manual. SQL
Server will start and stop the service itself when needed.
-Sue
On Sun, 26 Jun 2005 20:06:01 -0700, Jed
<Jed@.discussions.microsoft.com> wrote:
>I am running SQL Server 2000 sp 4 on Win2K Server sp 4.
>Recently, I started getting an MSSQLServerADHelper service error. I can't
>rely pin it on anything, other than I had a big database with 2 tables (7 and
>20 million records respectively). I ran out of disk space trying to index
>one of the tables.
>Ultimately, I detached the database, because it was too much for my system.
>Since then I have completely removed then reinstalled SQL Server and I still
>get the following errors. The MSSQLServerADHelper is set to automatic, which
>I believe is the correct state since is supposedly launched as needed. I
>have done some research and cannot track down an answer. Any ideas?
>Event Type:Error
>Event Source:Service Control Manager
>Event Category:None
>Event ID:7024
>Date:6/26/2005
>Time:1:54:11 AM
>User:N/A
>Computer:MERLOT
>Description:
>The MSSQLServerADHelper service terminated with service-specific error
>3221225572.
>Event Type:Error
>Event Source:MSSQLServerADHelper
>Event Category:None
>Event ID:100
>Date:6/26/2005
>Time:1:54:11 AM
>User:N/A
>Computer:MERLOT
>Description:
>'0' is an invalid number of start up parameters. This service takes two
>start up parameters.
>Event Type:Error
>Event Source:MSSQLSERVER
>Event Category:(2)
>Event ID:17055
>Date:6/26/2005
>Time:2:33:04 PM
>User:N/A
>Computer:MERLOT
>Description:
>19012 :
>SuperSocket Info: Bind failed on TCP port 1433.
>Data:
>0000: 44 4a 00 00 10 00 00 00 DJ.....
>0008: 07 00 00 00 4d 00 45 00 ...M.E.
>0010: 52 00 4c 00 4f 00 54 00 R.L.O.T.
>0018: 00 00 00 00 00 00 .....
Recently, I started getting an MSSQLServerADHelper service error. I can't
rely pin it on anything, other than I had a big database with 2 tables (7 and
20 million records respectively). I ran out of disk space trying to index
one of the tables.
Ultimately, I detached the database, because it was too much for my system.
Since then I have completely removed then reinstalled SQL Server and I still
get the following errors. The MSSQLServerADHelper is set to automatic, which
I believe is the correct state since is supposedly launched as needed. I
have done some research and cannot track down an answer. Any ideas?
Event Type:Error
Event Source:Service Control Manager
Event Category:None
Event ID:7024
Date:6/26/2005
Time:1:54:11 AM
User:N/A
Computer:MERLOT
Description:
The MSSQLServerADHelper service terminated with service-specific error
3221225572.
Event Type:Error
Event Source:MSSQLServerADHelper
Event Category:None
Event ID:100
Date:6/26/2005
Time:1:54:11 AM
User:N/A
Computer:MERLOT
Description:
'0' is an invalid number of start up parameters. This service takes two
start up parameters.
Event Type:Error
Event Source:MSSQLSERVER
Event Category:(2)
Event ID:17055
Date:6/26/2005
Time:2:33:04 PM
User:N/A
Computer:MERLOT
Description:
19012 :
SuperSocket Info: Bind failed on TCP port 1433.
Data:
0000: 44 4a 00 00 10 00 00 00 DJ.....
0008: 07 00 00 00 4d 00 45 00 ...M.E.
0010: 52 00 4c 00 4f 00 54 00 R.L.O.T.
0018: 00 00 00 00 00 00 .....
The MSSQLServerADHelper service should be set to manual. SQL
Server will start and stop the service itself when needed.
-Sue
On Sun, 26 Jun 2005 20:06:01 -0700, Jed
<Jed@.discussions.microsoft.com> wrote:
>I am running SQL Server 2000 sp 4 on Win2K Server sp 4.
>Recently, I started getting an MSSQLServerADHelper service error. I can't
>rely pin it on anything, other than I had a big database with 2 tables (7 and
>20 million records respectively). I ran out of disk space trying to index
>one of the tables.
>Ultimately, I detached the database, because it was too much for my system.
>Since then I have completely removed then reinstalled SQL Server and I still
>get the following errors. The MSSQLServerADHelper is set to automatic, which
>I believe is the correct state since is supposedly launched as needed. I
>have done some research and cannot track down an answer. Any ideas?
>Event Type:Error
>Event Source:Service Control Manager
>Event Category:None
>Event ID:7024
>Date:6/26/2005
>Time:1:54:11 AM
>User:N/A
>Computer:MERLOT
>Description:
>The MSSQLServerADHelper service terminated with service-specific error
>3221225572.
>Event Type:Error
>Event Source:MSSQLServerADHelper
>Event Category:None
>Event ID:100
>Date:6/26/2005
>Time:1:54:11 AM
>User:N/A
>Computer:MERLOT
>Description:
>'0' is an invalid number of start up parameters. This service takes two
>start up parameters.
>Event Type:Error
>Event Source:MSSQLSERVER
>Event Category:(2)
>Event ID:17055
>Date:6/26/2005
>Time:2:33:04 PM
>User:N/A
>Computer:MERLOT
>Description:
>19012 :
>SuperSocket Info: Bind failed on TCP port 1433.
>Data:
>0000: 44 4a 00 00 10 00 00 00 DJ.....
>0008: 07 00 00 00 4d 00 45 00 ...M.E.
>0010: 52 00 4c 00 4f 00 54 00 R.L.O.T.
>0018: 00 00 00 00 00 00 .....
Monday, March 19, 2012
MSSQLServerADHelper Service Error on Reboot
I am running SQL Server 2000 sp 4 on Win2K Server sp 4.
Recently, I started getting an MSSQLServerADHelper service error. I can't
rely pin it on anything, other than I had a big database with 2 tables (7 an
d
20 million records respectively). I ran out of disk space trying to index
one of the tables.
Ultimately, I detached the database, because it was too much for my system.
Since then I have completely removed then reinstalled SQL Server and I still
get the following errors. The MSSQLServerADHelper is set to automatic, whic
h
I believe is the correct state since is supposedly launched as needed. I
have done some research and cannot track down an answer. Any ideas?
Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7024
Date: 6/26/2005
Time: 1:54:11 AM
User: N/A
Computer: MERLOT
Description:
The MSSQLServerADHelper service terminated with service-specific error
3221225572.
Event Type: Error
Event Source: MSSQLServerADHelper
Event Category: None
Event ID: 100
Date: 6/26/2005
Time: 1:54:11 AM
User: N/A
Computer: MERLOT
Description:
'0' is an invalid number of start up parameters. This service takes two
start up parameters.
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 6/26/2005
Time: 2:33:04 PM
User: N/A
Computer: MERLOT
Description:
19012 :
SuperSocket Info: Bind failed on TCP port 1433.
Data:
0000: 44 4a 00 00 10 00 00 00 DJ.....
0008: 07 00 00 00 4d 00 45 00 ...M.E.
0010: 52 00 4c 00 4f 00 54 00 R.L.O.T.
0018: 00 00 00 00 00 00 .....The MSSQLServerADHelper service should be set to manual. SQL
Server will start and stop the service itself when needed.
-Sue
On Sun, 26 Jun 2005 20:06:01 -0700, Jed
<Jed@.discussions.microsoft.com> wrote:
>I am running SQL Server 2000 sp 4 on Win2K Server sp 4.
>Recently, I started getting an MSSQLServerADHelper service error. I can't
>rely pin it on anything, other than I had a big database with 2 tables (7 a
nd
>20 million records respectively). I ran out of disk space trying to index
>one of the tables.
>Ultimately, I detached the database, because it was too much for my system.
>Since then I have completely removed then reinstalled SQL Server and I stil
l
>get the following errors. The MSSQLServerADHelper is set to automatic, whi
ch
>I believe is the correct state since is supposedly launched as needed. I
>have done some research and cannot track down an answer. Any ideas?
>Event Type: Error
>Event Source: Service Control Manager
>Event Category: None
>Event ID: 7024
>Date: 6/26/2005
>Time: 1:54:11 AM
>User: N/A
>Computer: MERLOT
>Description:
>The MSSQLServerADHelper service terminated with service-specific error
>3221225572.
>Event Type: Error
>Event Source: MSSQLServerADHelper
>Event Category: None
>Event ID: 100
>Date: 6/26/2005
>Time: 1:54:11 AM
>User: N/A
>Computer: MERLOT
>Description:
>'0' is an invalid number of start up parameters. This service takes two
>start up parameters.
>Event Type: Error
>Event Source: MSSQLSERVER
>Event Category: (2)
>Event ID: 17055
>Date: 6/26/2005
>Time: 2:33:04 PM
>User: N/A
>Computer: MERLOT
>Description:
>19012 :
>SuperSocket Info: Bind failed on TCP port 1433.
>Data:
>0000: 44 4a 00 00 10 00 00 00 DJ.....
>0008: 07 00 00 00 4d 00 45 00 ...M.E.
>0010: 52 00 4c 00 4f 00 54 00 R.L.O.T.
>0018: 00 00 00 00 00 00 .....
Recently, I started getting an MSSQLServerADHelper service error. I can't
rely pin it on anything, other than I had a big database with 2 tables (7 an
d
20 million records respectively). I ran out of disk space trying to index
one of the tables.
Ultimately, I detached the database, because it was too much for my system.
Since then I have completely removed then reinstalled SQL Server and I still
get the following errors. The MSSQLServerADHelper is set to automatic, whic
h
I believe is the correct state since is supposedly launched as needed. I
have done some research and cannot track down an answer. Any ideas?
Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7024
Date: 6/26/2005
Time: 1:54:11 AM
User: N/A
Computer: MERLOT
Description:
The MSSQLServerADHelper service terminated with service-specific error
3221225572.
Event Type: Error
Event Source: MSSQLServerADHelper
Event Category: None
Event ID: 100
Date: 6/26/2005
Time: 1:54:11 AM
User: N/A
Computer: MERLOT
Description:
'0' is an invalid number of start up parameters. This service takes two
start up parameters.
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 6/26/2005
Time: 2:33:04 PM
User: N/A
Computer: MERLOT
Description:
19012 :
SuperSocket Info: Bind failed on TCP port 1433.
Data:
0000: 44 4a 00 00 10 00 00 00 DJ.....
0008: 07 00 00 00 4d 00 45 00 ...M.E.
0010: 52 00 4c 00 4f 00 54 00 R.L.O.T.
0018: 00 00 00 00 00 00 .....The MSSQLServerADHelper service should be set to manual. SQL
Server will start and stop the service itself when needed.
-Sue
On Sun, 26 Jun 2005 20:06:01 -0700, Jed
<Jed@.discussions.microsoft.com> wrote:
>I am running SQL Server 2000 sp 4 on Win2K Server sp 4.
>Recently, I started getting an MSSQLServerADHelper service error. I can't
>rely pin it on anything, other than I had a big database with 2 tables (7 a
nd
>20 million records respectively). I ran out of disk space trying to index
>one of the tables.
>Ultimately, I detached the database, because it was too much for my system.
>Since then I have completely removed then reinstalled SQL Server and I stil
l
>get the following errors. The MSSQLServerADHelper is set to automatic, whi
ch
>I believe is the correct state since is supposedly launched as needed. I
>have done some research and cannot track down an answer. Any ideas?
>Event Type: Error
>Event Source: Service Control Manager
>Event Category: None
>Event ID: 7024
>Date: 6/26/2005
>Time: 1:54:11 AM
>User: N/A
>Computer: MERLOT
>Description:
>The MSSQLServerADHelper service terminated with service-specific error
>3221225572.
>Event Type: Error
>Event Source: MSSQLServerADHelper
>Event Category: None
>Event ID: 100
>Date: 6/26/2005
>Time: 1:54:11 AM
>User: N/A
>Computer: MERLOT
>Description:
>'0' is an invalid number of start up parameters. This service takes two
>start up parameters.
>Event Type: Error
>Event Source: MSSQLSERVER
>Event Category: (2)
>Event ID: 17055
>Date: 6/26/2005
>Time: 2:33:04 PM
>User: N/A
>Computer: MERLOT
>Description:
>19012 :
>SuperSocket Info: Bind failed on TCP port 1433.
>Data:
>0000: 44 4a 00 00 10 00 00 00 DJ.....
>0008: 07 00 00 00 4d 00 45 00 ...M.E.
>0010: 52 00 4c 00 4f 00 54 00 R.L.O.T.
>0018: 00 00 00 00 00 00 .....
MSSQLServerADHelper Service Error on Reboot
I am running SQL Server 2000 sp 4 on Win2K Server sp 4.
Recently, I started getting an MSSQLServerADHelper service error. I can't
rely pin it on anything, other than I had a big database with 2 tables (7 and
20 million records respectively). I ran out of disk space trying to index
one of the tables.
Ultimately, I detached the database, because it was too much for my system.
Since then I have completely removed then reinstalled SQL Server and I still
get the following errors. The MSSQLServerADHelper is set to automatic, which
I believe is the correct state since is supposedly launched as needed. I
have done some research and cannot track down an answer. Any ideas?
Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7024
Date: 6/26/2005
Time: 1:54:11 AM
User: N/A
Computer: MERLOT
Description:
The MSSQLServerADHelper service terminated with service-specific error
3221225572.
Event Type: Error
Event Source: MSSQLServerADHelper
Event Category: None
Event ID: 100
Date: 6/26/2005
Time: 1:54:11 AM
User: N/A
Computer: MERLOT
Description:
'0' is an invalid number of start up parameters. This service takes two
start up parameters.
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 6/26/2005
Time: 2:33:04 PM
User: N/A
Computer: MERLOT
Description:
19012 :
SuperSocket Info: Bind failed on TCP port 1433.
Data:
0000: 44 4a 00 00 10 00 00 00 DJ.....
0008: 07 00 00 00 4d 00 45 00 ...M.E.
0010: 52 00 4c 00 4f 00 54 00 R.L.O.T.
0018: 00 00 00 00 00 00 .....The MSSQLServerADHelper service should be set to manual. SQL
Server will start and stop the service itself when needed.
-Sue
On Sun, 26 Jun 2005 20:06:01 -0700, Jed
<Jed@.discussions.microsoft.com> wrote:
>I am running SQL Server 2000 sp 4 on Win2K Server sp 4.
>Recently, I started getting an MSSQLServerADHelper service error. I can't
>rely pin it on anything, other than I had a big database with 2 tables (7 and
>20 million records respectively). I ran out of disk space trying to index
>one of the tables.
>Ultimately, I detached the database, because it was too much for my system.
>Since then I have completely removed then reinstalled SQL Server and I still
>get the following errors. The MSSQLServerADHelper is set to automatic, which
>I believe is the correct state since is supposedly launched as needed. I
>have done some research and cannot track down an answer. Any ideas?
>Event Type: Error
>Event Source: Service Control Manager
>Event Category: None
>Event ID: 7024
>Date: 6/26/2005
>Time: 1:54:11 AM
>User: N/A
>Computer: MERLOT
>Description:
>The MSSQLServerADHelper service terminated with service-specific error
>3221225572.
>Event Type: Error
>Event Source: MSSQLServerADHelper
>Event Category: None
>Event ID: 100
>Date: 6/26/2005
>Time: 1:54:11 AM
>User: N/A
>Computer: MERLOT
>Description:
>'0' is an invalid number of start up parameters. This service takes two
>start up parameters.
>Event Type: Error
>Event Source: MSSQLSERVER
>Event Category: (2)
>Event ID: 17055
>Date: 6/26/2005
>Time: 2:33:04 PM
>User: N/A
>Computer: MERLOT
>Description:
>19012 :
>SuperSocket Info: Bind failed on TCP port 1433.
>Data:
>0000: 44 4a 00 00 10 00 00 00 DJ.....
>0008: 07 00 00 00 4d 00 45 00 ...M.E.
>0010: 52 00 4c 00 4f 00 54 00 R.L.O.T.
>0018: 00 00 00 00 00 00 .....
Recently, I started getting an MSSQLServerADHelper service error. I can't
rely pin it on anything, other than I had a big database with 2 tables (7 and
20 million records respectively). I ran out of disk space trying to index
one of the tables.
Ultimately, I detached the database, because it was too much for my system.
Since then I have completely removed then reinstalled SQL Server and I still
get the following errors. The MSSQLServerADHelper is set to automatic, which
I believe is the correct state since is supposedly launched as needed. I
have done some research and cannot track down an answer. Any ideas?
Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7024
Date: 6/26/2005
Time: 1:54:11 AM
User: N/A
Computer: MERLOT
Description:
The MSSQLServerADHelper service terminated with service-specific error
3221225572.
Event Type: Error
Event Source: MSSQLServerADHelper
Event Category: None
Event ID: 100
Date: 6/26/2005
Time: 1:54:11 AM
User: N/A
Computer: MERLOT
Description:
'0' is an invalid number of start up parameters. This service takes two
start up parameters.
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 6/26/2005
Time: 2:33:04 PM
User: N/A
Computer: MERLOT
Description:
19012 :
SuperSocket Info: Bind failed on TCP port 1433.
Data:
0000: 44 4a 00 00 10 00 00 00 DJ.....
0008: 07 00 00 00 4d 00 45 00 ...M.E.
0010: 52 00 4c 00 4f 00 54 00 R.L.O.T.
0018: 00 00 00 00 00 00 .....The MSSQLServerADHelper service should be set to manual. SQL
Server will start and stop the service itself when needed.
-Sue
On Sun, 26 Jun 2005 20:06:01 -0700, Jed
<Jed@.discussions.microsoft.com> wrote:
>I am running SQL Server 2000 sp 4 on Win2K Server sp 4.
>Recently, I started getting an MSSQLServerADHelper service error. I can't
>rely pin it on anything, other than I had a big database with 2 tables (7 and
>20 million records respectively). I ran out of disk space trying to index
>one of the tables.
>Ultimately, I detached the database, because it was too much for my system.
>Since then I have completely removed then reinstalled SQL Server and I still
>get the following errors. The MSSQLServerADHelper is set to automatic, which
>I believe is the correct state since is supposedly launched as needed. I
>have done some research and cannot track down an answer. Any ideas?
>Event Type: Error
>Event Source: Service Control Manager
>Event Category: None
>Event ID: 7024
>Date: 6/26/2005
>Time: 1:54:11 AM
>User: N/A
>Computer: MERLOT
>Description:
>The MSSQLServerADHelper service terminated with service-specific error
>3221225572.
>Event Type: Error
>Event Source: MSSQLServerADHelper
>Event Category: None
>Event ID: 100
>Date: 6/26/2005
>Time: 1:54:11 AM
>User: N/A
>Computer: MERLOT
>Description:
>'0' is an invalid number of start up parameters. This service takes two
>start up parameters.
>Event Type: Error
>Event Source: MSSQLSERVER
>Event Category: (2)
>Event ID: 17055
>Date: 6/26/2005
>Time: 2:33:04 PM
>User: N/A
>Computer: MERLOT
>Description:
>19012 :
>SuperSocket Info: Bind failed on TCP port 1433.
>Data:
>0000: 44 4a 00 00 10 00 00 00 DJ.....
>0008: 07 00 00 00 4d 00 45 00 ...M.E.
>0010: 52 00 4c 00 4f 00 54 00 R.L.O.T.
>0018: 00 00 00 00 00 00 .....
MSSQLServerADHelper Service
I noticed on both nodes in my 2 node cluster the MSSQLServerADHelper service
was not started and set to manual. Is there a reason why this isnt started?
Is it safe to start and set to Automatic on both nodes?
Thanks,
JBaileyHere you can read about MSSQLServerADHelper here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_cs_9mhx.asp
Regards
---
All information provided below AS IS.
"JBailey" <abc@.123.com> wrote in message
news:uWZv$$8nDHA.488@.tk2msftngp13.phx.gbl...
> I noticed on both nodes in my 2 node cluster the MSSQLServerADHelper
service
> was not started and set to manual. Is there a reason why this isnt
started?
> Is it safe to start and set to Automatic on both nodes?
> Thanks,
> JBailey
>|||"JBailey" <abc@.123.com> wrote in message
news:uWZv$$8nDHA.488@.tk2msftngp13.phx.gbl...
> I noticed on both nodes in my 2 node cluster the MSSQLServerADHelper
service
> was not started and set to manual. Is there a reason why this isnt
started?
> Is it safe to start and set to Automatic on both nodes?
>
My understanding is this is only needed if you want to register your SQL
Server instance in Active Directory. It's not needed for your cluster...
from books online (see BOL for more information0:
The MSSQLServerADHelper service performs two functions:
a.. It adds and removes the objects used to register instances of
Microsoft® SQL ServerT 2000 relational database engine or Analysis server in
the Microsoft Windows® 2000 Active DirectoryT.
b.. It ensures that the Windows account under which a SQL Server service
is running has permissions to update all of the Active Directory objects for
the instance, as well as any replication publications and databases for that
instance.
Steve
was not started and set to manual. Is there a reason why this isnt started?
Is it safe to start and set to Automatic on both nodes?
Thanks,
JBaileyHere you can read about MSSQLServerADHelper here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_cs_9mhx.asp
Regards
---
All information provided below AS IS.
"JBailey" <abc@.123.com> wrote in message
news:uWZv$$8nDHA.488@.tk2msftngp13.phx.gbl...
> I noticed on both nodes in my 2 node cluster the MSSQLServerADHelper
service
> was not started and set to manual. Is there a reason why this isnt
started?
> Is it safe to start and set to Automatic on both nodes?
> Thanks,
> JBailey
>|||"JBailey" <abc@.123.com> wrote in message
news:uWZv$$8nDHA.488@.tk2msftngp13.phx.gbl...
> I noticed on both nodes in my 2 node cluster the MSSQLServerADHelper
service
> was not started and set to manual. Is there a reason why this isnt
started?
> Is it safe to start and set to Automatic on both nodes?
>
My understanding is this is only needed if you want to register your SQL
Server instance in Active Directory. It's not needed for your cluster...
from books online (see BOL for more information0:
The MSSQLServerADHelper service performs two functions:
a.. It adds and removes the objects used to register instances of
Microsoft® SQL ServerT 2000 relational database engine or Analysis server in
the Microsoft Windows® 2000 Active DirectoryT.
b.. It ensures that the Windows account under which a SQL Server service
is running has permissions to update all of the Active Directory objects for
the instance, as well as any replication publications and databases for that
instance.
Steve
MSSQLServerADHelper
Hi
I am getting the following error (given at the end) in the event log and the
MSSQLServerADHelper service does not start. What can I do?
Thanks
Regards
Event Type: Error
Event Source: MSSQLServerADHelper
Event Category: None
Event ID: 100
Date: 09/07/2004
Time: 18:41:36
User: N/A
Computer: MYSERVER
Description:
'0' is an invalid number of start up parameters. This service takes two
start up parameters.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.This also comes up.
Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7024
Date: 09/07/2004
Time: 19:15:36
User: N/A
Computer: MYSERVER
Description:
The MSSQLServerADHelper service terminated with service-specific error
3221225572 (0xC0000064).
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
"John" <john@.nospam.infovis.co.uk> wrote in message
news:ei8G85dZEHA.3092@.tk2msftngp13.phx.gbl...
> Hi
> I am getting the following error (given at the end) in the event log and
the
> MSSQLServerADHelper service does not start. What can I do?
> Thanks
> Regards
>
> Event Type: Error
> Event Source: MSSQLServerADHelper
> Event Category: None
> Event ID: 100
> Date: 09/07/2004
> Time: 18:41:36
> User: N/A
> Computer: MYSERVER
> Description:
> '0' is an invalid number of start up parameters. This service takes two
> start up parameters.
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
>
I am getting the following error (given at the end) in the event log and the
MSSQLServerADHelper service does not start. What can I do?
Thanks
Regards
Event Type: Error
Event Source: MSSQLServerADHelper
Event Category: None
Event ID: 100
Date: 09/07/2004
Time: 18:41:36
User: N/A
Computer: MYSERVER
Description:
'0' is an invalid number of start up parameters. This service takes two
start up parameters.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.This also comes up.
Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7024
Date: 09/07/2004
Time: 19:15:36
User: N/A
Computer: MYSERVER
Description:
The MSSQLServerADHelper service terminated with service-specific error
3221225572 (0xC0000064).
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
"John" <john@.nospam.infovis.co.uk> wrote in message
news:ei8G85dZEHA.3092@.tk2msftngp13.phx.gbl...
> Hi
> I am getting the following error (given at the end) in the event log and
the
> MSSQLServerADHelper service does not start. What can I do?
> Thanks
> Regards
>
> Event Type: Error
> Event Source: MSSQLServerADHelper
> Event Category: None
> Event ID: 100
> Date: 09/07/2004
> Time: 18:41:36
> User: N/A
> Computer: MYSERVER
> Description:
> '0' is an invalid number of start up parameters. This service takes two
> start up parameters.
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
>
MSSQLServerADHelper
Hi
I am getting the following error (given at the end) in the event log and the
MSSQLServerADHelper service does not start. What can I do?
Thanks
Regards
Event Type: Error
Event Source: MSSQLServerADHelper
Event Category: None
Event ID: 100
Date: 09/07/2004
Time: 18:41:36
User: N/A
Computer: MYSERVER
Description:
'0' is an invalid number of start up parameters. This service takes two
start up parameters.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
This also comes up.
Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7024
Date: 09/07/2004
Time: 19:15:36
User: N/A
Computer: MYSERVER
Description:
The MSSQLServerADHelper service terminated with service-specific error
3221225572 (0xC0000064).
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
"John" <john@.nospam.infovis.co.uk> wrote in message
news:ei8G85dZEHA.3092@.tk2msftngp13.phx.gbl...
> Hi
> I am getting the following error (given at the end) in the event log and
the
> MSSQLServerADHelper service does not start. What can I do?
> Thanks
> Regards
>
> Event Type: Error
> Event Source: MSSQLServerADHelper
> Event Category: None
> Event ID: 100
> Date: 09/07/2004
> Time: 18:41:36
> User: N/A
> Computer: MYSERVER
> Description:
> '0' is an invalid number of start up parameters. This service takes two
> start up parameters.
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
>
I am getting the following error (given at the end) in the event log and the
MSSQLServerADHelper service does not start. What can I do?
Thanks
Regards
Event Type: Error
Event Source: MSSQLServerADHelper
Event Category: None
Event ID: 100
Date: 09/07/2004
Time: 18:41:36
User: N/A
Computer: MYSERVER
Description:
'0' is an invalid number of start up parameters. This service takes two
start up parameters.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
This also comes up.
Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7024
Date: 09/07/2004
Time: 19:15:36
User: N/A
Computer: MYSERVER
Description:
The MSSQLServerADHelper service terminated with service-specific error
3221225572 (0xC0000064).
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
"John" <john@.nospam.infovis.co.uk> wrote in message
news:ei8G85dZEHA.3092@.tk2msftngp13.phx.gbl...
> Hi
> I am getting the following error (given at the end) in the event log and
the
> MSSQLServerADHelper service does not start. What can I do?
> Thanks
> Regards
>
> Event Type: Error
> Event Source: MSSQLServerADHelper
> Event Category: None
> Event ID: 100
> Date: 09/07/2004
> Time: 18:41:36
> User: N/A
> Computer: MYSERVER
> Description:
> '0' is an invalid number of start up parameters. This service takes two
> start up parameters.
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
>
MSSQLServerADHelper
Hi all,
I have a service installed on my Win2KAdvancedServer called
'MSSQLServerADHelper'. I cannot find any reference to this. Anyone know
what it is?
Thx in advance..
-BB
According to Books Online: Search for MSSQLServerADHelper
MSSQLServerADHelper Service
The MSSQLServerADHelper service performs two functions:
a.. It adds and removes the objects used to register instances of Microsoft SQL ServerT 2000 relational database engine or Analysis server in the Microsoft Windows 2000 Active DirectoryT.
b.. It ensures that the Windows account under which a SQL Server service is running has permissions to update all of the Active Directory objects for the instance, as well as any replication publications and databases for that instance.
The service is dynamically started by an instance of SQL Server or the Analysis Manager when needed. The service is stopped as soon as it has completed its work.
Active Directory objects in a computer container can be created or removed only by programs that have been assigned either domain administration rights or that are running under the localsystem Windows account. Few sites run their SQL Server service under either of these types of accounts. A service application that does not perform network administration, such as SQL Server, is rarely granted full domain administration rights. The localsystem account cannot be given any privileges on remote computers; therefore, running SQL Server under this account would prevent much of the SQL Server distributed functionality from working. The MSSQLServerADHelper service is run under the localsystem account so that it can add and remove objects registering SQL Server entities in the Active Directory.
There is only one MSSQLServerADHelper service on a computer. The single service handles the Active Directory objects for all instances of the SQL Server relational database engine and all Analysis Manager applications running on the computer.
"Brian Burgess" <bburgess66@.hotmail.com> wrote in message news:O$JIN2poEHA.3392@.TK2MSFTNGP15.phx.gbl...
Hi all,
I have a service installed on my Win2KAdvancedServer called
'MSSQLServerADHelper'. I cannot find any reference to this. Anyone know
what it is?
Thx in advance..
-BB
|||ah thks .. I thought it might have been something that did not belong ....
-BB
"TJ" <tunj@.hotmail.com> wrote in message news:eLJLfiroEHA.2684@.TK2MSFTNGP11.phx.gbl...
According to Books Online: Search for MSSQLServerADHelper
MSSQLServerADHelper Service
The MSSQLServerADHelper service performs two functions:
a.. It adds and removes the objects used to register instances of Microsoft SQL ServerT 2000 relational database engine or Analysis server in the Microsoft Windows 2000 Active DirectoryT.
b.. It ensures that the Windows account under which a SQL Server service is running has permissions to update all of the Active Directory objects for the instance, as well as any replication publications and databases for that instance.
The service is dynamically started by an instance of SQL Server or the Analysis Manager when needed. The service is stopped as soon as it has completed its work.
Active Directory objects in a computer container can be created or removed only by programs that have been assigned either domain administration rights or that are running under the localsystem Windows account. Few sites run their SQL Server service under either of these types of accounts. A service application that does not perform network administration, such as SQL Server, is rarely granted full domain administration rights. The localsystem account cannot be given any privileges on remote computers; therefore, running SQL Server under this account would prevent much of the SQL Server distributed functionality from working. The MSSQLServerADHelper service is run under the localsystem account so that it can add and remove objects registering SQL Server entities in the Active Directory.
There is only one MSSQLServerADHelper service on a computer. The single service handles the Active Directory objects for all instances of the SQL Server relational database engine and all Analysis Manager applications running on the computer.
"Brian Burgess" <bburgess66@.hotmail.com> wrote in message news:O$JIN2poEHA.3392@.TK2MSFTNGP15.phx.gbl...
Hi all,
I have a service installed on my Win2KAdvancedServer called
'MSSQLServerADHelper'. I cannot find any reference to this. Anyone know
what it is?
Thx in advance..
-BB
I have a service installed on my Win2KAdvancedServer called
'MSSQLServerADHelper'. I cannot find any reference to this. Anyone know
what it is?
Thx in advance..
-BB
According to Books Online: Search for MSSQLServerADHelper
MSSQLServerADHelper Service
The MSSQLServerADHelper service performs two functions:
a.. It adds and removes the objects used to register instances of Microsoft SQL ServerT 2000 relational database engine or Analysis server in the Microsoft Windows 2000 Active DirectoryT.
b.. It ensures that the Windows account under which a SQL Server service is running has permissions to update all of the Active Directory objects for the instance, as well as any replication publications and databases for that instance.
The service is dynamically started by an instance of SQL Server or the Analysis Manager when needed. The service is stopped as soon as it has completed its work.
Active Directory objects in a computer container can be created or removed only by programs that have been assigned either domain administration rights or that are running under the localsystem Windows account. Few sites run their SQL Server service under either of these types of accounts. A service application that does not perform network administration, such as SQL Server, is rarely granted full domain administration rights. The localsystem account cannot be given any privileges on remote computers; therefore, running SQL Server under this account would prevent much of the SQL Server distributed functionality from working. The MSSQLServerADHelper service is run under the localsystem account so that it can add and remove objects registering SQL Server entities in the Active Directory.
There is only one MSSQLServerADHelper service on a computer. The single service handles the Active Directory objects for all instances of the SQL Server relational database engine and all Analysis Manager applications running on the computer.
"Brian Burgess" <bburgess66@.hotmail.com> wrote in message news:O$JIN2poEHA.3392@.TK2MSFTNGP15.phx.gbl...
Hi all,
I have a service installed on my Win2KAdvancedServer called
'MSSQLServerADHelper'. I cannot find any reference to this. Anyone know
what it is?
Thx in advance..
-BB
|||ah thks .. I thought it might have been something that did not belong ....
-BB
"TJ" <tunj@.hotmail.com> wrote in message news:eLJLfiroEHA.2684@.TK2MSFTNGP11.phx.gbl...
According to Books Online: Search for MSSQLServerADHelper
MSSQLServerADHelper Service
The MSSQLServerADHelper service performs two functions:
a.. It adds and removes the objects used to register instances of Microsoft SQL ServerT 2000 relational database engine or Analysis server in the Microsoft Windows 2000 Active DirectoryT.
b.. It ensures that the Windows account under which a SQL Server service is running has permissions to update all of the Active Directory objects for the instance, as well as any replication publications and databases for that instance.
The service is dynamically started by an instance of SQL Server or the Analysis Manager when needed. The service is stopped as soon as it has completed its work.
Active Directory objects in a computer container can be created or removed only by programs that have been assigned either domain administration rights or that are running under the localsystem Windows account. Few sites run their SQL Server service under either of these types of accounts. A service application that does not perform network administration, such as SQL Server, is rarely granted full domain administration rights. The localsystem account cannot be given any privileges on remote computers; therefore, running SQL Server under this account would prevent much of the SQL Server distributed functionality from working. The MSSQLServerADHelper service is run under the localsystem account so that it can add and remove objects registering SQL Server entities in the Active Directory.
There is only one MSSQLServerADHelper service on a computer. The single service handles the Active Directory objects for all instances of the SQL Server relational database engine and all Analysis Manager applications running on the computer.
"Brian Burgess" <bburgess66@.hotmail.com> wrote in message news:O$JIN2poEHA.3392@.TK2MSFTNGP15.phx.gbl...
Hi all,
I have a service installed on my Win2KAdvancedServer called
'MSSQLServerADHelper'. I cannot find any reference to this. Anyone know
what it is?
Thx in advance..
-BB
MSSQLServerADHelper
Hi
I am getting the following error (given at the end) in the event log and the
MSSQLServerADHelper service does not start. What can I do?
Thanks
Regards
Event Type: Error
Event Source: MSSQLServerADHelper
Event Category: None
Event ID: 100
Date: 09/07/2004
Time: 18:41:36
User: N/A
Computer: MYSERVER
Description:
'0' is an invalid number of start up parameters. This service takes two
start up parameters.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.This also comes up.
Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7024
Date: 09/07/2004
Time: 19:15:36
User: N/A
Computer: MYSERVER
Description:
The MSSQLServerADHelper service terminated with service-specific error
3221225572 (0xC0000064).
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
"John" <john@.nospam.infovis.co.uk> wrote in message
news:ei8G85dZEHA.3092@.tk2msftngp13.phx.gbl...
> Hi
> I am getting the following error (given at the end) in the event log and
the
> MSSQLServerADHelper service does not start. What can I do?
> Thanks
> Regards
>
> Event Type: Error
> Event Source: MSSQLServerADHelper
> Event Category: None
> Event ID: 100
> Date: 09/07/2004
> Time: 18:41:36
> User: N/A
> Computer: MYSERVER
> Description:
> '0' is an invalid number of start up parameters. This service takes two
> start up parameters.
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
>
I am getting the following error (given at the end) in the event log and the
MSSQLServerADHelper service does not start. What can I do?
Thanks
Regards
Event Type: Error
Event Source: MSSQLServerADHelper
Event Category: None
Event ID: 100
Date: 09/07/2004
Time: 18:41:36
User: N/A
Computer: MYSERVER
Description:
'0' is an invalid number of start up parameters. This service takes two
start up parameters.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.This also comes up.
Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7024
Date: 09/07/2004
Time: 19:15:36
User: N/A
Computer: MYSERVER
Description:
The MSSQLServerADHelper service terminated with service-specific error
3221225572 (0xC0000064).
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
"John" <john@.nospam.infovis.co.uk> wrote in message
news:ei8G85dZEHA.3092@.tk2msftngp13.phx.gbl...
> Hi
> I am getting the following error (given at the end) in the event log and
the
> MSSQLServerADHelper service does not start. What can I do?
> Thanks
> Regards
>
> Event Type: Error
> Event Source: MSSQLServerADHelper
> Event Category: None
> Event ID: 100
> Date: 09/07/2004
> Time: 18:41:36
> User: N/A
> Computer: MYSERVER
> Description:
> '0' is an invalid number of start up parameters. This service takes two
> start up parameters.
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
>
Subscribe to:
Posts (Atom)