Could not start the MSSQLServer Service on local computer. Error: 1068: the dependency ser

We installed SQL Server 2000 on a Win2000 server (call it serverA). This
Win2000 server used to be a member server of a Domain Controller (call it
serverDC with domain name DCName). We had a problem with that Domain
Controller today, so we took out serverA from the domain controller. Now, we
cannot start the SQL Server Service Manager. It gave us an error that says
"Dependency service or group failed to start. Error 1068 (Dependency service
or group failed to start) occured while performing this service operation on
the MSSQLServer Service.".
When I tried to srtart the MSSQLServer Service, it gave me an error "Could
not start the MSSQLServer Service on local computer. Error: 1068: the
dependency service or group failed to start". When I clicked on the tab
"Dependencies", there is no dependency for this service.
On the "Log On" tab of MSSQLServer Service, the user name used to say
"DCName\Administrator", and after we took out serverA from the domain
controller, we changed the user name to "\Administrator".
How can I fix this problem ? Thank you.Try changing the services (SQL Server, SQL Agent, etc) to
run under Local System - from the Log On tab of the service.
You wouldn't necessarily want to keep it set to this but you
can see if it's starts up with the services running under
local system.
-Sue
On Tue, 7 Sep 2004 14:49:06 -0500, "Fie Fie Niles"
<fniles@.wincitesystems.com> wrote:
>We installed SQL Server 2000 on a Win2000 server (call it serverA). This
>Win2000 server used to be a member server of a Domain Controller (call it
>serverDC with domain name DCName). We had a problem with that Domain
>Controller today, so we took out serverA from the domain controller. Now, we
>cannot start the SQL Server Service Manager. It gave us an error that says
>"Dependency service or group failed to start. Error 1068 (Dependency service
>or group failed to start) occured while performing this service operation on
>the MSSQLServer Service.".
>When I tried to srtart the MSSQLServer Service, it gave me an error "Could
>not start the MSSQLServer Service on local computer. Error: 1068: the
>dependency service or group failed to start". When I clicked on the tab
>"Dependencies", there is no dependency for this service.
>On the "Log On" tab of MSSQLServer Service, the user name used to say
>"DCName\Administrator", and after we took out serverA from the domain
>controller, we changed the user name to "\Administrator".
>How can I fix this problem ? Thank you.
>

Could not find stored procedure 'master..xp_jdbc_open'

Hi All,

I am using WebSphere 5.1 and try to setup Datasoruce connection in WebSphere

I have selected "Microsoft JDBC driver for MSSQLServer 2000" from the picklist in WebSphere Admin Console.

The 3 jar files below are referenced correctly as well:

${MSSQLSERVER_JDBC_DRIVER_PATH}/msbase.jar
${MSSQLSERVER_JDBC_DRIVER_PATH}/mssqlserver.jar
${MSSQLSERVER_JDBC_DRIVER_PATH}/msutil.jar

However when I run a testconnection, it fails with this error:

Test Connection failed for datasource celio on server server1 at node workstation_50 with the following exception: java.lang.Exception: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Could not find stored procedure 'master..xp_jdbc_open'.. View JVM logs for further details. Null

My Datbase is MS SQL 2000 !

Is it a bug?

Any help is appreciated.

Thank you

Ramin

Hi there,

Perhaps this article could help with your problem:

http://www-1.ibm.com/support/docview.wss?uid=swg21168355

Hope that helps a bit, but sorry if it doesn't

Could not find stored procedure 'master..xp_jdbc_open'

Hi All,

I am using WebSphere 5.1 and try to setup Datasoruce connection in WebSphere

I have selected "Microsoft JDBC driver for MSSQLServer 2000" from the picklist in WebSphere Admin Console.

The 3 jar files below are referenced correctly as well:

${MSSQLSERVER_JDBC_DRIVER_PATH}/msbase.jar
${MSSQLSERVER_JDBC_DRIVER_PATH}/mssqlserver.jar
${MSSQLSERVER_JDBC_DRIVER_PATH}/msutil.jar

However when I run a testconnection, it fails with this error:

Test Connection failed for datasource celio on server server1 at node workstation_50 with the following exception: java.lang.Exception: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Could not find stored procedure 'master..xp_jdbc_open'.. View JVM logs for further details. Null

My Datbase is MS SQL 2000 !

Is it a bug?

Any help is appreciated.

Thank you

Ramin

Hi there,

Perhaps this article could help with your problem:

http://www-1.ibm.com/support/docview.wss?uid=swg21168355

Hope that helps a bit, but sorry if it doesn't|||

Thank you

I have followed that reference, after applying the sqljdbc.dll and running th script, I have got this error when run the testconnection: I restarted WS and MSSQL Server both

Test Connection failed for datasource celio on server server1 at node RBONAKDA03 with the following exception: java.lang.Exception: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Cannot load the DLL sqljdbc.dll, or one of the DLLs it references. Reason: 193(error not found).. View JVM logs for further details. null

|||Hi there,

Apologies for my late response.

Is the DLL registered on the database server? From things I have read, the DLL needs to be placed and registered on the server on which SQL Server runs.

Other than that, I can't think of anything. Sorry.
|||

There seems to be a slight confusion here.

It sounds like you are trying to configure Sql Server to use the Microsoft 2000 JDBC driver but then you are referencing the 2005 JDBC driver.

For a new application I would recommend that you use the 2005 Jdbc driver:

http://msdn.microsoft.com/data/ref/jdbc/

We have just shipped the June community tech preview of this driver if you want to play with the latest and greatest:

http://www.microsoft.com/downloads/details.aspx?familyid=f914793a-6fb4-475f-9537-b8fcb776befd&displaylang=en

To set up distributed transaction support follow the instructions on the xa_install.sql file found ont the Microsoft SQL Server 2005 JDBC Driver\sqljdbc_1.1\enu\xa directory (or sqljdbc_1.0\ directory for the RTW driver). To set up Websphere to work with the 2005 driver you can:

1) Add a new provider from the Providers menu under JDBC Providers
2) For path specify the path to your sqljdbc.jar
example : C:\Microsoft SQL Server 2005 JDBC
Driver\sqljdbc_1.1\enu\sqljdbc.jar
3) For implementation class name use the following.
com.microsoft.sqlserver.jdbc.SQLServerXADataSource

4) One you saved the provider choose the datasources menu and create a new
data source
5) You can use the generic data store helper class provided by Websphere AS
(com.ibm.websphere.rsadapter.GenericDataStoreHelper)

Could not find stored procedure 'master..xp_jdbc_open'

Hi All,

I am using WebSphere 5.1 and try to setup Datasoruce connection in WebSphere

I have selected "Microsoft JDBC driver for MSSQLServer 2000" from the picklist in WebSphere Admin Console.

The 3 jar files below are referenced correctly as well:

${MSSQLSERVER_JDBC_DRIVER_PATH}/msbase.jar
${MSSQLSERVER_JDBC_DRIVER_PATH}/mssqlserver.jar
${MSSQLSERVER_JDBC_DRIVER_PATH}/msutil.jar

However when I run a testconnection, it fails with this error:

Test Connection failed for datasource celio on server server1 at node workstation_50 with the following exception: java.lang.Exception: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Could not find stored procedure 'master..xp_jdbc_open'.. View JVM logs for further details. Null

My Datbase is MS SQL 2000 !

Is it a bug?

Any help is appreciated.

Thank you

Ramin

Hi there,

Perhaps this article could help with your problem:

http://www-1.ibm.com/support/docview.wss?uid=swg21168355

Hope that helps a bit, but sorry if it doesn't|||

Thank you

I have followed that reference, after applying the sqljdbc.dll and running th script, I have got this error when run the testconnection: I restarted WS and MSSQL Server both

Test Connection failed for datasource celio on server server1 at node RBONAKDA03 with the following exception: java.lang.Exception: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Cannot load the DLL sqljdbc.dll, or one of the DLLs it references. Reason: 193(error not found).. View JVM logs for further details. null

|||Hi there,

Apologies for my late response.

Is the DLL registered on the database server? From things I have read, the DLL needs to be placed and registered on the server on which SQL Server runs.

Other than that, I can't think of anything. Sorry.
|||

There seems to be a slight confusion here.

It sounds like you are trying to configure Sql Server to use the Microsoft 2000 JDBC driver but then you are referencing the 2005 JDBC driver.

For a new application I would recommend that you use the 2005 Jdbc driver:

http://msdn.microsoft.com/data/ref/jdbc/

We have just shipped the June community tech preview of this driver if you want to play with the latest and greatest:

http://www.microsoft.com/downloads/details.aspx?familyid=f914793a-6fb4-475f-9537-b8fcb776befd&displaylang=en

To set up distributed transaction support follow the instructions on the xa_install.sql file found ont the Microsoft SQL Server 2005 JDBC Driver\sqljdbc_1.1\enu\xa directory (or sqljdbc_1.0\ directory for the RTW driver). To set up Websphere to work with the 2005 driver you can:

1) Add a new provider from the Providers menu under JDBC Providers
2) For path specify the path to your sqljdbc.jar
example : C:\Microsoft SQL Server 2005 JDBC
Driver\sqljdbc_1.1\enu\sqljdbc.jar
3) For implementation class name use the following.
com.microsoft.sqlserver.jdbc.SQLServerXADataSource

4) One you saved the provider choose the datasources menu and create a new
data source
5) You can use the generic data store helper class provided by Websphere AS
(com.ibm.websphere.rsadapter.GenericDataStoreHelper)

Could not adjust the space allocation message

Hi all -
Recieve the message
Event Type: Information
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 09/08/2005
Time: 10:13:47 AM
User: N/A
Computer: JackBox
Description:
17052 :
Could not adjust the space allocation for file 'Jack_Data_1'.
The machine is win2K sp4 running sql2K sp3. Could not find this error on
support.microsoft.com - could anyone explain the meaning?
Thanks.
TitoHi
Maybe something like:
http://support.microsoft.com/default.aspx?scid=kb;en-us;254253
What maintainance are you carrying out?
You may want to stop autoshrink if it is on!
John
"Tito Madrid" <tito_madrid@.yahoo.com> wrote in message
news:uRupdzJtFHA.3328@.TK2MSFTNGP11.phx.gbl...
> Hi all -
> Recieve the message
> Event Type: Information
> Event Source: MSSQLSERVER
> Event Category: (2)
> Event ID: 17055
> Date: 09/08/2005
> Time: 10:13:47 AM
> User: N/A
> Computer: JackBox
> Description:
> 17052 :
> Could not adjust the space allocation for file 'Jack_Data_1'.
>
> The machine is win2K sp4 running sql2K sp3. Could not find this error on
> support.microsoft.com - could anyone explain the meaning?
> Thanks.
> Tito
>|||John - Thanks for the link - I really did try the site first, but only got
off-point results.
I did have autoshrink turned on - it is now off - thanks. I also re-index
and integrity check it nightly.
Dave
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:%23W2cPtKtFHA.3548@.TK2MSFTNGP11.phx.gbl...
> Hi
> Maybe something like:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;254253
> What maintainance are you carrying out?
> You may want to stop autoshrink if it is on!
> John
> "Tito Madrid" <tito_madrid@.yahoo.com> wrote in message
> news:uRupdzJtFHA.3328@.TK2MSFTNGP11.phx.gbl...
> > Hi all -
> >
> > Recieve the message
> >
> > Event Type: Information
> > Event Source: MSSQLSERVER
> > Event Category: (2)
> > Event ID: 17055
> > Date: 09/08/2005
> > Time: 10:13:47 AM
> > User: N/A
> > Computer: JackBox
> > Description:
> > 17052 :
> > Could not adjust the space allocation for file 'Jack_Data_1'.
> >
> >
> >
> > The machine is win2K sp4 running sql2K sp3. Could not find this error
on
> > support.microsoft.com - could anyone explain the meaning?
> >
> > Thanks.
> >
> > Tito
> >
> >
>|||Hi
I think the message would probably appear whilst an activity was happening
therefore that is why I think it may be autoshink. You don't say how
reguarly this occurred but if you monitor the event file for this you may
see if it happens again.
John
"Tito Madrid" <tito_madrid@.yahoo.com> wrote in message
news:OK%23qYrLtFHA.1136@.TK2MSFTNGP12.phx.gbl...
> John - Thanks for the link - I really did try the site first, but only got
> off-point results.
> I did have autoshrink turned on - it is now off - thanks. I also re-index
> and integrity check it nightly.
> Dave
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:%23W2cPtKtFHA.3548@.TK2MSFTNGP11.phx.gbl...
>> Hi
>> Maybe something like:
>> http://support.microsoft.com/default.aspx?scid=kb;en-us;254253
>> What maintainance are you carrying out?
>> You may want to stop autoshrink if it is on!
>> John
>> "Tito Madrid" <tito_madrid@.yahoo.com> wrote in message
>> news:uRupdzJtFHA.3328@.TK2MSFTNGP11.phx.gbl...
>> > Hi all -
>> >
>> > Recieve the message
>> >
>> > Event Type: Information
>> > Event Source: MSSQLSERVER
>> > Event Category: (2)
>> > Event ID: 17055
>> > Date: 09/08/2005
>> > Time: 10:13:47 AM
>> > User: N/A
>> > Computer: JackBox
>> > Description:
>> > 17052 :
>> > Could not adjust the space allocation for file 'Jack_Data_1'.
>> >
>> >
>> >
>> > The machine is win2K sp4 running sql2K sp3. Could not find this error
> on
>> > support.microsoft.com - could anyone explain the meaning?
>> >
>> > Thanks.
>> >
>> > Tito
>> >
>> >
>>
>