Error 17827 from SQL Server 2005 Express Edition

Hi,
I'm using SQL server 2005 Express Edition in my solution and I've run into a
problem that I can't find any information about.
The application was running OK (for several days) until this happend just
out of the blue.
The application is written in C++ and we are using ADO to access the
database.
The authentication used with sql server user names and passwords.
I have not changed the password for any user
In the SQL server error log I found the following lines.
2007-03-15 01:34:01.13 Server Server resumed execution after being idle
209 seconds: user activity awakened the server. This is an informational
message only. No user action is required.
2007-03-15 02:34:01.61 Server Server resumed execution after being idle
213 seconds: user activity awakened the server. This is an informational
message only. No user action is required.
2007-03-15 03:11:00.78 Logon Error: 17827, Severity: 20, State: 1.
2007-03-15 03:11:00.78 Logon There was a failure while attempting to
encrypt a password. The connection has been closed. [CLIENT: <local machine>]
2007-03-15 03:11:00.80 Server Error: 17054, Severity: 16, State: 1.
2007-03-15 03:11:00.80 Server The current event was not reported to the
Windows Events log. Operating system error = 5(error not found). You may need
to clear the Windows Events log if it is full.
2007-03-15 03:11:02.42 Logon Error: 17827, Severity: 20, State: 1.
2007-03-15 03:11:02.42 Logon There was a failure while attempting to
encrypt a password. The connection has been closed. [CLIENT: <local machine>]
2007-03-15 03:11:05.42 Logon Error: 17827, Severity: 20, State: 1.
2007-03-15 03:11:05.42 Logon There was a failure while attempting to
encrypt a password. The connection has been closed. [CLIENT: <local machine>]
2007-03-15 03:11:11.42 Logon Error: 17827, Severity: 20, State: 1.
2007-03-15 03:11:11.42 Logon There was a failure while attempting to
encrypt a password. The connection has been closed. [CLIENT: <local machine>]
2007-03-15 03:11:23.45 Logon Error: 17827, Severity: 20, State: 1.
2007-03-15 03:11:23.45 Logon There was a failure while attempting to
encrypt a password. The connection has been closed. [CLIENT: <local machine>]
2007-03-15 03:11:48.42 Logon Error: 17827, Severity: 20, State: 1.
2007-03-15 03:11:48.42 Logon There was a failure while attempting to
encrypt a password. The connection has been closed. [CLIENT: <local machine>]
2007-03-15 03:12:38.31 Logon Error: 17827, Severity: 20, State: 1.
2007-03-15 03:12:38.31 Logon There was a failure while attempting to
encrypt a password. The connection has been closed. [CLIENT: <local machine>]
2007-03-15 03:14:16.67 Logon Error: 17827, Severity: 20, State: 1.
2007-03-15 03:14:16.67 Logon There was a failure while attempting to
encrypt a password. The connection has been closed. [CLIENT: <local machine>]
2007-03-15 03:15:55.91 Logon Error: 17827, Severity: 20, State: 1.
2007-03-15 03:15:55.91 Logon There was a failure while attempting to
encrypt a password. The connection has been closed. [CLIENT: <local machine>]
2007-03-15 03:17:35.19 Logon Error: 17827, Severity: 20, State: 1.
2007-03-15 03:17:35.19 Logon There was a failure while attempting to
encrypt a password. The connection has been closed. [CLIENT: <local machine>]
Does anyone have any ideas why i get this behavior from SQL?
After we rebooted the system everything worked OK again.
Voja Tadic
Voja,
How many connections are being made to your SQL Express instance? Although
there is no hard limit to connections, there are resource limits on memory
and once those are used up, you will have problems.
Might you have many connections that should have closed during the several
successful days, but have not? If so, you many have many unused connections
still consuming resources.
The reason I ask is because the only instance of 17827 I see in Technet is
SQL Server 2000 extended stored procedure related and means: The maximum
number of '%1!ld!' remote connections is currently in use.
Although that is not directly your error, it may be a hint as to the
underlying problem.
RLF
"vojat" <vojat@.discussions.microsoft.com> wrote in message
news:0AD8C694-B1B5-462A-9425-B8C791BE63E6@.microsoft.com...
> Hi,
> I'm using SQL server 2005 Express Edition in my solution and I've run into
> a
> problem that I can't find any information about.
> The application was running OK (for several days) until this happend just
> out of the blue.
> The application is written in C++ and we are using ADO to access the
> database.
> The authentication used with sql server user names and passwords.
> I have not changed the password for any user
>
> In the SQL server error log I found the following lines.
>
> 2007-03-15 01:34:01.13 Server Server resumed execution after being
> idle
> 209 seconds: user activity awakened the server. This is an informational
> message only. No user action is required.
> 2007-03-15 02:34:01.61 Server Server resumed execution after being
> idle
> 213 seconds: user activity awakened the server. This is an informational
> message only. No user action is required.
> 2007-03-15 03:11:00.78 Logon Error: 17827, Severity: 20, State: 1.
> 2007-03-15 03:11:00.78 Logon There was a failure while attempting to
> encrypt a password. The connection has been closed. [CLIENT: <local
> machine>]
> 2007-03-15 03:11:00.80 Server Error: 17054, Severity: 16, State: 1.
> 2007-03-15 03:11:00.80 Server The current event was not reported to
> the
> Windows Events log. Operating system error = 5(error not found). You may
> need
> to clear the Windows Events log if it is full.
> 2007-03-15 03:11:02.42 Logon Error: 17827, Severity: 20, State: 1.
> 2007-03-15 03:11:02.42 Logon There was a failure while attempting to
> encrypt a password. The connection has been closed. [CLIENT: <local
> machine>]
> 2007-03-15 03:11:05.42 Logon Error: 17827, Severity: 20, State: 1.
> 2007-03-15 03:11:05.42 Logon There was a failure while attempting to
> encrypt a password. The connection has been closed. [CLIENT: <local
> machine>]
> 2007-03-15 03:11:11.42 Logon Error: 17827, Severity: 20, State: 1.
> 2007-03-15 03:11:11.42 Logon There was a failure while attempting to
> encrypt a password. The connection has been closed. [CLIENT: <local
> machine>]
> 2007-03-15 03:11:23.45 Logon Error: 17827, Severity: 20, State: 1.
> 2007-03-15 03:11:23.45 Logon There was a failure while attempting to
> encrypt a password. The connection has been closed. [CLIENT: <local
> machine>]
> 2007-03-15 03:11:48.42 Logon Error: 17827, Severity: 20, State: 1.
> 2007-03-15 03:11:48.42 Logon There was a failure while attempting to
> encrypt a password. The connection has been closed. [CLIENT: <local
> machine>]
> 2007-03-15 03:12:38.31 Logon Error: 17827, Severity: 20, State: 1.
> 2007-03-15 03:12:38.31 Logon There was a failure while attempting to
> encrypt a password. The connection has been closed. [CLIENT: <local
> machine>]
> 2007-03-15 03:14:16.67 Logon Error: 17827, Severity: 20, State: 1.
> 2007-03-15 03:14:16.67 Logon There was a failure while attempting to
> encrypt a password. The connection has been closed. [CLIENT: <local
> machine>]
> 2007-03-15 03:15:55.91 Logon Error: 17827, Severity: 20, State: 1.
> 2007-03-15 03:15:55.91 Logon There was a failure while attempting to
> encrypt a password. The connection has been closed. [CLIENT: <local
> machine>]
> 2007-03-15 03:17:35.19 Logon Error: 17827, Severity: 20, State: 1.
> 2007-03-15 03:17:35.19 Logon There was a failure while attempting to
> encrypt a password. The connection has been closed. [CLIENT: <local
> machine>]
>
> Does anyone have any ideas why i get this behavior from SQL?
>
> After we rebooted the system everything worked OK again.
> Voja Tadic
|||Hi,
I only use one connection for this application and I'm closing the
connection after each action to the database. I'm also using the connection
pooling functionality in ADO. This application uses the database alot.
I do have one additional application that uses ADO.DET and connects,
retrives data and dissconects and then terminats. This is done ~20-30 times
each day.
"Russell Fields" wrote:

> Voja,
> How many connections are being made to your SQL Express instance? Although
> there is no hard limit to connections, there are resource limits on memory
> and once those are used up, you will have problems.
> Might you have many connections that should have closed during the several
> successful days, but have not? If so, you many have many unused connections
> still consuming resources.
> The reason I ask is because the only instance of 17827 I see in Technet is
> SQL Server 2000 extended stored procedure related and means: The maximum
> number of '%1!ld!' remote connections is currently in use.
> Although that is not directly your error, it may be a hint as to the
> underlying problem.
> RLF
> "vojat" <vojat@.discussions.microsoft.com> wrote in message
> news:0AD8C694-B1B5-462A-9425-B8C791BE63E6@.microsoft.com...
>
>
|||Voja,
I don't have any real good insight for you. You might look here for the
answer or someone to talk with:
http://blogs.msdn.com/sql_protocols/archive/2006/03/23/558651.aspx
RLF
"vojat" <vojat@.discussions.microsoft.com> wrote in message
news:0ACE3553-246E-46EC-936D-5A57E1181A02@.microsoft.com...[vbcol=seagreen]
> Hi,
> I only use one connection for this application and I'm closing the
> connection after each action to the database. I'm also using the
> connection
> pooling functionality in ADO. This application uses the database alot.
> I do have one additional application that uses ADO.DET and connects,
> retrives data and dissconects and then terminats. This is done ~20-30
> times
> each day.
>
> "Russell Fields" wrote:

Error 165 - Sql state Hy000

Hi
I have Sql 2000 Server Sp4 with two instances from some day the Sql server
agent of second instance don't start and i can't do automatically backup. In
Sql log i try Error 165, error odbc [sql state HY000]
Can help me to risolve this problem.
Tia pupo
Pupo
take a look at following article:
http://support.microsoft.com/default...b;en-us;811889
Also ,check your SQLAgent service and make sure the account is right.
"Pupo" <123star@.libero.it> wrote in message
news:%2310q9c34FHA.2548@.TK2MSFTNGP10.phx.gbl...
> Hi
> I have Sql 2000 Server Sp4 with two instances from some day the Sql server
> agent of second instance don't start and i can't do automatically backup.
> In Sql log i try Error 165, error odbc [sql state HY000]
> Can help me to risolve this problem.
> Tia pupo
>

Error 165 - Sql state Hy000

Hi
I have Sql 2000 Server Sp4 with two instances from some day the Sql server
agent of second instance don't start and i can't do automatically backup. In
Sql log i try Error 165, error odbc [sql state HY000]
Can help me to risolve this problem.
Tia pupo
Pupo
take a look at following article:
http://support.microsoft.com/default...b;en-us;811889
Also ,check your SQLAgent service and make sure the account is right.
"Pupo" <123star@.libero.it> wrote in message
news:%2310q9c34FHA.2548@.TK2MSFTNGP10.phx.gbl...
> Hi
> I have Sql 2000 Server Sp4 with two instances from some day the Sql server
> agent of second instance don't start and i can't do automatically backup.
> In Sql log i try Error 165, error odbc [sql state HY000]
> Can help me to risolve this problem.
> Tia pupo
>

Error 165 - Sql state Hy000

Hi
I have Sql 2000 Server Sp4 with two instances from some day the Sql server
agent of second instance don't start and i can't do automatically backup. In
Sql log i try Error 165, error odbc [sql state HY000]
Can help me to risolve this problem.
Tia pupo
Pupo
take a look at following article:
http://support.microsoft.com/default...b;en-us;811889
Also ,check your SQLAgent service and make sure the account is right.
"Pupo" <123star@.libero.it> wrote in message
news:%2310q9c34FHA.2548@.TK2MSFTNGP10.phx.gbl...
> Hi
> I have Sql 2000 Server Sp4 with two instances from some day the Sql server
> agent of second instance don't start and i can't do automatically backup.
> In Sql log i try Error 165, error odbc [sql state HY000]
> Can help me to risolve this problem.
> Tia pupo
>
sql

Error 1612 - can't get Express installed

I have done all I can to resolve this on my own and would really appreciate any help anyone can give me. I have run uninstall utilities, followed a few MSDN reinstall methods, but all roads lead back to this vicious cycle:

The install hangs trying to install the prereq Microsoft SQL Server 2005 Setup Support Files with Error 1612. So I try to uninstall the Support files using Add/Remove..but the Windows Installer looks for "Microsoft SQL Server Native Client" disk, which of course I don't have because I install from downloads from Microsoft.

That's the very short version. I've got a ton of hours reading help groups, MSDN, trying everything.

I have posted the error log file below. Thanks in advance.

=== Verbose logging started: 1/25/2007 21:01:41 Build type: SHIP UNICODE 3.01.4000.2435 Calling process: c:\6b4bf5519a6c349936f69599\setup.exe ===
MSI (c) (2C:64) [21:01:41:265]: Resetting cached policy values
MSI (c) (2C:64) [21:01:41:265]: Machine policy value 'Debug' is 0
MSI (c) (2C:64) [21:01:41:265]: ******* RunEngine:
******* Product: {53F5C3EE-05ED-4830-994B-50B2F0D50FCE}
******* Action:
******* CommandLine: **********
MSI (c) (2C:64) [21:01:41:265]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (2C:64) [21:01:41:265]: Grabbed execution mutex.
MSI (c) (2C:64) [21:01:41:281]: Cloaking enabled.
MSI (c) (2C:64) [21:01:41:281]: Attempting to enable all disabled priveleges before calling Install on Server
MSI (c) (2C:64) [21:01:41:281]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (98:90) [21:01:41:296]: Grabbed execution mutex.
MSI (s) (98:E4) [21:01:41:296]: Resetting cached policy values
MSI (s) (98:E4) [21:01:41:296]: Machine policy value 'Debug' is 0
MSI (s) (98:E4) [21:01:41:296]: ******* RunEngine:
******* Product: {53F5C3EE-05ED-4830-994B-50B2F0D50FCE}
******* Action:
******* CommandLine: **********
MSI (s) (98:E4) [21:01:41:296]: Machine policy value 'DisableUserInstalls' is 0
MSI (s) (98:E4) [21:01:41:296]: User policy value 'SearchOrder' is 'nmu'
MSI (s) (98:E4) [21:01:41:296]: User policy value 'DisableMedia' is 0
MSI (s) (98:E4) [21:01:41:296]: Machine policy value 'AllowLockdownMedia' is 0
MSI (s) (98:E4) [21:01:41:296]: SOURCEMGMT: Media enabled only if package is safe.
MSI (s) (98:E4) [21:01:41:296]: SOURCEMGMT: Looking for sourcelist for product {53F5C3EE-05ED-4830-994B-50B2F0D50FCE}
MSI (s) (98:E4) [21:01:41:296]: SOURCEMGMT: Adding {53F5C3EE-05ED-4830-994B-50B2F0D50FCE}; to potential sourcelist list (pcode;disk;relpath).
MSI (s) (98:E4) [21:01:41:296]: SOURCEMGMT: Now checking product {53F5C3EE-05ED-4830-994B-50B2F0D50FCE}
MSI (s) (98:E4) [21:01:41:296]: SOURCEMGMT: Media is enabled for product.
MSI (s) (98:E4) [21:01:41:296]: SOURCEMGMT: Attempting to use LastUsedSource from source list.
MSI (s) (98:E4) [21:01:41:296]: SOURCEMGMT: Source with value name '1' is blank
MSI (s) (98:E4) [21:01:41:296]: Note: 1: 1706 2: -2147483647 3: SqlSupport.msi
MSI (s) (98:E4) [21:01:41:296]: SOURCEMGMT: Processing net source list.
MSI (s) (98:E4) [21:01:41:296]: Note: 1: 1706 2: -2147483647 3: SqlSupport.msi
MSI (s) (98:E4) [21:01:41:296]: SOURCEMGMT: Processing media source list.
MSI (s) (98:E4) [21:01:41:312]: Note: 1: 2203 2: 3: -2147287037
MSI (s) (98:E4) [21:01:41:312]: SOURCEMGMT: Source is invalid due to missing/inaccessible package.
MSI (s) (98:E4) [21:01:41:312]: Note: 1: 1706 2: -2147483647 3: SqlSupport.msi
MSI (s) (98:E4) [21:01:41:312]: SOURCEMGMT: Processing URL source list.
MSI (s) (98:E4) [21:01:41:312]: Note: 1: 1402 2: UNKNOWN\URL 3: 2
MSI (s) (98:E4) [21:01:41:312]: Note: 1: 1706 2: -2147483647 3: SqlSupport.msi
MSI (s) (98:E4) [21:01:41:312]: Note: 1: 1706 2: 3: SqlSupport.msi
MSI (s) (98:E4) [21:01:41:312]: SOURCEMGMT: Failed to resolve source
MSI (s) (98:E4) [21:01:41:312]: MainEngineThread is returning 1612
MSI (c) (2C:64) [21:01:41:312]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (2C:64) [21:01:41:312]: MainEngineThread is returning 1612
=== Verbose logging stopped: 1/25/2007 21:01:41 ===

hi,

jklegseth wrote:

I have done all I can to resolve this on my own and would really appreciate any help anyone can give me. I have run uninstall utilities, followed a few MSDN reinstall methods, but all roads lead back to this vicious cycle:

The install hangs trying to install the prereq Microsoft SQL Server 2005 Setup Support Files with Error 1612. So I try to uninstall the Support files using Add/Remove..but the Windows Installer looks for "Microsoft SQL Server Native Client" disk, which of course I don't have because I install from downloads from Microsoft.

try manually installing SQL Native Client before the SQLExpress installation by running the relative package (half the page down)

regards

|||

Hi Andrea,

I tried what you suggested. Here is what happens.

- I get a warning that "A lower version of this product has been detected on your stystem. Would you like to upgrade your existing installation?"

- I click Yes

- Install seems to go fine -- it shows me what will be installed, etc., until I get a window saying, "Insert the 'Microsoft SQL Native Client' disk and click OK.

|||

Update: Using Windows Install Cleanup I was able to get past the Native error. I think there was a registry entry for Native install that was no longer valid. I got through the SQL install only to have a new problem. Now, during the installation System Configuration Check I pass 14 of 15 tests. I get a warning for Com Plus Catalog Requirement.

The warning message is: "Com Plus Catalog Requirement (Warning), Messages: If SQL Server Setup fails, Setup will roll back....For more information, see How to: Work Around Com+ Check Failure in SQL Server Setup."

I followed the steps in that KB article but when I add Component Services in the Console and click on Com+ Applications, I get an error: "ERror Code 8004E00F - COM+ was unable to talk to the Microsoft Distributed Transaction Coordinator.

So I looked that up and found various articles but none that seemed to apply directly to my problem.

If I continue the SQL Server setup and ignore the warning, I get a successful install of Setup Support Files, VSS WRiter, Backwards Compatability, but get failed warnings on all the of the SQL Express 2005 components. I'm once again stumped. Any ideas?

Thanks for your help.

|||

Update #2

I was to get past the above issue by following the steps at http://www.pcreview.co.uk/forums/thread-1596796.php. MSXML6 then failed during SQL Server install, so I removed it and reinstalled it. I am very close now. The error I now get is: "An instance with the same name is already installed on this computer. To proceed with SQL Server Setup, provide a unique instance name" I have followed the steps at http://blogs.msdn.com/astebner/archive/2005/12/08/501885.aspx but this has not resolved the. I can't believe how much time I've spent on this, but maybe this error is one you have encountered? I will keep searching and posting here so others with this issue can find help. If you have any ideas I would appreciate it.

Error 1068 Can't start SQLSERVERAGENT and MSSQLSERVER

I was rebuilding my index and my system admin rebooted the system without
shutting down the database first. After the reboot the SQLSERVERAGENT and
MSSQLSERVER services won't start and I received ERROR 1068:The dependency
service or group failed to start error while trying to start the two services.
In the Enterprise Manger screen I saw:
Connection failed, check SQL Server Registration Properties
I am not sure how to fix this problem. Can I rebuild my SQL Server
registery, and if so, how? Please advise. Thanks in advance.
Hi,
Could you please open the SQL server errorlog in program files\microsoft sql
server\log folder and investigate more on this error.
Thanks
Hari
MCDBA
"Ling" wrote:

> I was rebuilding my index and my system admin rebooted the system without
> shutting down the database first. After the reboot the SQLSERVERAGENT and
> MSSQLSERVER services won't start and I received ERROR 1068:The dependency
> service or group failed to start error while trying to start the two services.
> In the Enterprise Manger screen I saw:
> Connection failed, check SQL Server Registration Properties
> I am not sure how to fix this problem. Can I rebuild my SQL Server
> registery, and if so, how? Please advise. Thanks in advance.
|||There's only one line in the errorlog:
2004-09-22 11:28:07.03 server The system is older than SQL Server 7.0 RTM
version and is not supported by this server
"Hari Prasad" wrote:
[vbcol=seagreen]
> Hi,
> Could you please open the SQL server errorlog in program files\microsoft sql
> server\log folder and investigate more on this error.
> Thanks
> Hari
> MCDBA
>
> "Ling" wrote:
|||What exact messages do you get if you from a DOS prompt type below?
NET START MSSQLSERVER
(Adjust server name of it is a named instance.)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Ling" <Ling@.discussions.microsoft.com> wrote in message
news:F823DF33-6210-4E2D-AA98-37E2FEFD1659@.microsoft.com...
> I was rebuilding my index and my system admin rebooted the system without
> shutting down the database first. After the reboot the SQLSERVERAGENT and
> MSSQLSERVER services won't start and I received ERROR 1068:The dependency
> service or group failed to start error while trying to start the two services.
> In the Enterprise Manger screen I saw:
> Connection failed, check SQL Server Registration Properties
> I am not sure how to fix this problem. Can I rebuild my SQL Server
> registery, and if so, how? Please advise. Thanks in advance.

Error 1068 Can't start SQLSERVERAGENT and MSSQLSERVER

On manually starting SQLSERVERAGENT service, it gives the following
error:
error 1068: The depending service for group failed to start.
Can anybody tell me how to restart these SQLSERVERAGENT and MSSQLSERVER
services.
Thanks,
misecprj
Start > Run > services.msc > SLSERVERAGENT > Properties > Dependencies
See which dependant services are not running.
"misecprj@.hotmail.com" wrote:

> On manually starting SQLSERVERAGENT service, it gives the following
> error:
> error 1068: The depending service for group failed to start.
> Can anybody tell me how to restart these SQLSERVERAGENT and MSSQLSERVER
> services.
> Thanks,
> misecprj
>
|||Hi
In the services applet in control panel you can view the dependencies of a
service and start the services as well. Make sure that you are logged into an
account that has permissions to start services.
John
"misecprj@.hotmail.com" wrote:

> On manually starting SQLSERVERAGENT service, it gives the following
> error:
> error 1068: The depending service for group failed to start.
> Can anybody tell me how to restart these SQLSERVERAGENT and MSSQLSERVER
> services.
> Thanks,
> misecprj
>

Error 1068 Can't start SQLSERVERAGENT and MSSQLSERVER

On manually starting SQLSERVERAGENT service, it gives the following
error:
error 1068: The depending service for group failed to start.
Can anybody tell me how to restart these SQLSERVERAGENT and MSSQLSERVER
services.
Thanks,
misecprjStart > Run > services.msc > SLSERVERAGENT > Properties > Dependencies
See which dependant services are not running.
"misecprj@.hotmail.com" wrote:

> On manually starting SQLSERVERAGENT service, it gives the following
> error:
> error 1068: The depending service for group failed to start.
> Can anybody tell me how to restart these SQLSERVERAGENT and MSSQLSERVER
> services.
> Thanks,
> misecprj
>|||Hi
In the services applet in control panel you can view the dependencies of a
service and start the services as well. Make sure that you are logged into a
n
account that has permissions to start services.
John
"misecprj@.hotmail.com" wrote:

> On manually starting SQLSERVERAGENT service, it gives the following
> error:
> error 1068: The depending service for group failed to start.
> Can anybody tell me how to restart these SQLSERVERAGENT and MSSQLSERVER
> services.
> Thanks,
> misecprj
>

Error 1068 Can't start SQLSERVERAGENT and MSSQLSERVER

On manually starting SQLSERVERAGENT service, it gives the following
error:
error 1068: The depending service for group failed to start.
Can anybody tell me how to restart these SQLSERVERAGENT and MSSQLSERVER
services.
Thanks,
misecprjStart > Run > services.msc > SLSERVERAGENT > Properties > Dependencies
See which dependant services are not running.
"misecprj@.hotmail.com" wrote:
> On manually starting SQLSERVERAGENT service, it gives the following
> error:
> error 1068: The depending service for group failed to start.
> Can anybody tell me how to restart these SQLSERVERAGENT and MSSQLSERVER
> services.
> Thanks,
> misecprj
>|||Hi
In the services applet in control panel you can view the dependencies of a
service and start the services as well. Make sure that you are logged into an
account that has permissions to start services.
John
"misecprj@.hotmail.com" wrote:
> On manually starting SQLSERVERAGENT service, it gives the following
> error:
> error 1068: The depending service for group failed to start.
> Can anybody tell me how to restart these SQLSERVERAGENT and MSSQLSERVER
> services.
> Thanks,
> misecprj
>

error 1067

I'm using MSDE2000sp3 and I can't get the service to start. The error that I
get is, 'error 1067 The process terminated unexpectedly'. Can anyone tell me
why I get this error. Please help.
hi,
vz wrote:
> I'm using MSDE2000sp3 and I can't get the service to start. The error
> that I get is, 'error 1067 The process terminated unexpectedly'. Can
> anyone tell me why I get this error. Please help.
please verify your errorlog file for the cause of the problem..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply