Problem restoring database ...

Dear Newsgroup,

I am using sql server 2000 over win 2000 server with service pack 4.

I have been given a back up of a database (I have tried both from T-SQL and
Enterprise Manager)

T-SQL

RESTORE FILELISTONLY
FROM DISK = 'c:\A.bck'

RESTORE DATABASE B
FROM DISK = 'c:\A.bck'
WITH MOVE 'A_Data' TO 'c:\test\B.mdf',
MOVE 'A_Log' TO 'c:\test\B.ldf'

and as I try to restore I get the following error :

Server: Msg 3154, Level 16, State 2, Line 1
The backup set holds a backup of a database other than the existing 'B'
database.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

Would you kindly help me ?????

Thank you in advance,
YassYass (gol_e_yass@.yahoo.com) writes:
> RESTORE FILELISTONLY
> FROM DISK = 'c:\A.bck'
> RESTORE DATABASE B
> FROM DISK = 'c:\A.bck'
> WITH MOVE 'A_Data' TO 'c:\test\B.mdf',
> MOVE 'A_Log' TO 'c:\test\B.ldf'
> and as I try to restore I get the following error :
> Server: Msg 3154, Level 16, State 2, Line 1
> The backup set holds a backup of a database other than the existing 'B'
> database.
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
> Would you kindly help me ?????

I'm out on a limb here, but my interpretation is that there is already
a database B on the machine, but the backup is taken from another
database (A?). Adding ", REPLACE" at the end will get rid of the
error message - and wipe out B, so be careful that this is what you
want to do.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

Problem installing SQL Server 2005 Service Pack 2

I tried to run the new SP2 and it crashes. I get the dialog asking to send
the crash data to microsoft.
I then checked the upgrade log and found a message saying that it could not
log into the server. I know it had the right password because the service
pack checks that near the begining.
I then checked the service and noticed that is was stopped. I then tried to
manually start and stop the service during the upgrade each time I saw that
it needed to start or stop it by the messages that came up. That didn't work
.
It got to a point later that said it could not stop the service.
I then changed the login of the services themselves to be tan admin user.
That seemed to allow the service pack to start and stop the service ok, but
it still crashes near the end now. The message is again that it can't log in
.
I also must mention that after the first time this happened the small icon
on the lower right of the tray that is the sql server is gone.
Please help. I need to get the SP2 to succeed so that it will be back to
normal.Hi
Now that you changed the login from sql server service , did you try
manually start it? Is it started? Does the account that sql server run under
have an efficient permission (member of domain admins..)?
"apitman" <apitman@.discussions.microsoft.com> wrote in message
news:7BBEB5F1-3038-4BB1-BB79-5294FD84EBBD@.microsoft.com...
>I tried to run the new SP2 and it crashes. I get the dialog asking to send
> the crash data to microsoft.
> I then checked the upgrade log and found a message saying that it could
> not
> log into the server. I know it had the right password because the service
> pack checks that near the begining.
> I then checked the service and noticed that is was stopped. I then tried
> to
> manually start and stop the service during the upgrade each time I saw
> that
> it needed to start or stop it by the messages that came up. That didn't
> work.
> It got to a point later that said it could not stop the service.
> I then changed the login of the services themselves to be tan admin user.
> That seemed to allow the service pack to start and stop the service ok,
> but
> it still crashes near the end now. The message is again that it can't log
> in.
> I also must mention that after the first time this happened the small icon
> on the lower right of the tray that is the sql server is gone.
> Please help. I need to get the SP2 to succeed so that it will be back to
> normal.
>|||I did try it again without luck. It still crashes just at a later time in th
e
install.
Tony
"Uri Dimant" wrote:

> Hi
> Now that you changed the login from sql server service , did you try
> manually start it? Is it started? Does the account that sql server run und
er
> have an efficient permission (member of domain admins..)?
>
> "apitman" <apitman@.discussions.microsoft.com> wrote in message
> news:7BBEB5F1-3038-4BB1-BB79-5294FD84EBBD@.microsoft.com...
>
>

Problem installing SQL Server 2005 Service Pack 2

I tried to run the new SP2 and it crashes. I get the dialog asking to send
the crash data to microsoft.
I then checked the upgrade log and found a message saying that it could not
log into the server. I know it had the right password because the service
pack checks that near the begining.
I then checked the service and noticed that is was stopped. I then tried to
manually start and stop the service during the upgrade each time I saw that
it needed to start or stop it by the messages that came up. That didn't work.
It got to a point later that said it could not stop the service.
I then changed the login of the services themselves to be tan admin user.
That seemed to allow the service pack to start and stop the service ok, but
it still crashes near the end now. The message is again that it can't log in.
I also must mention that after the first time this happened the small icon
on the lower right of the tray that is the sql server is gone.
Please help. I need to get the SP2 to succeed so that it will be back to
normal.
Hi
Now that you changed the login from sql server service , did you try
manually start it? Is it started? Does the account that sql server run under
have an efficient permission (member of domain admins..)?
"apitman" <apitman@.discussions.microsoft.com> wrote in message
news:7BBEB5F1-3038-4BB1-BB79-5294FD84EBBD@.microsoft.com...
>I tried to run the new SP2 and it crashes. I get the dialog asking to send
> the crash data to microsoft.
> I then checked the upgrade log and found a message saying that it could
> not
> log into the server. I know it had the right password because the service
> pack checks that near the begining.
> I then checked the service and noticed that is was stopped. I then tried
> to
> manually start and stop the service during the upgrade each time I saw
> that
> it needed to start or stop it by the messages that came up. That didn't
> work.
> It got to a point later that said it could not stop the service.
> I then changed the login of the services themselves to be tan admin user.
> That seemed to allow the service pack to start and stop the service ok,
> but
> it still crashes near the end now. The message is again that it can't log
> in.
> I also must mention that after the first time this happened the small icon
> on the lower right of the tray that is the sql server is gone.
> Please help. I need to get the SP2 to succeed so that it will be back to
> normal.
>
|||I did try it again without luck. It still crashes just at a later time in the
install.
Tony
"Uri Dimant" wrote:

> Hi
> Now that you changed the login from sql server service , did you try
> manually start it? Is it started? Does the account that sql server run under
> have an efficient permission (member of domain admins..)?
>
> "apitman" <apitman@.discussions.microsoft.com> wrote in message
> news:7BBEB5F1-3038-4BB1-BB79-5294FD84EBBD@.microsoft.com...
>
>

Problem installing SQL Server 2005 Service Pack 2

I tried to run the new SP2 and it crashes. I get the dialog asking to send
the crash data to microsoft.
I then checked the upgrade log and found a message saying that it could not
log into the server. I know it had the right password because the service
pack checks that near the begining.
I then checked the service and noticed that is was stopped. I then tried to
manually start and stop the service during the upgrade each time I saw that
it needed to start or stop it by the messages that came up. That didn't work.
It got to a point later that said it could not stop the service.
I then changed the login of the services themselves to be tan admin user.
That seemed to allow the service pack to start and stop the service ok, but
it still crashes near the end now. The message is again that it can't log in.
I also must mention that after the first time this happened the small icon
on the lower right of the tray that is the sql server is gone.
Please help. I need to get the SP2 to succeed so that it will be back to
normal.Hi
Now that you changed the login from sql server service , did you try
manually start it? Is it started? Does the account that sql server run under
have an efficient permission (member of domain admins..)?
"apitman" <apitman@.discussions.microsoft.com> wrote in message
news:7BBEB5F1-3038-4BB1-BB79-5294FD84EBBD@.microsoft.com...
>I tried to run the new SP2 and it crashes. I get the dialog asking to send
> the crash data to microsoft.
> I then checked the upgrade log and found a message saying that it could
> not
> log into the server. I know it had the right password because the service
> pack checks that near the begining.
> I then checked the service and noticed that is was stopped. I then tried
> to
> manually start and stop the service during the upgrade each time I saw
> that
> it needed to start or stop it by the messages that came up. That didn't
> work.
> It got to a point later that said it could not stop the service.
> I then changed the login of the services themselves to be tan admin user.
> That seemed to allow the service pack to start and stop the service ok,
> but
> it still crashes near the end now. The message is again that it can't log
> in.
> I also must mention that after the first time this happened the small icon
> on the lower right of the tray that is the sql server is gone.
> Please help. I need to get the SP2 to succeed so that it will be back to
> normal.
>|||I did try it again without luck. It still crashes just at a later time in the
install.
Tony
"Uri Dimant" wrote:
> Hi
> Now that you changed the login from sql server service , did you try
> manually start it? Is it started? Does the account that sql server run under
> have an efficient permission (member of domain admins..)?
>
> "apitman" <apitman@.discussions.microsoft.com> wrote in message
> news:7BBEB5F1-3038-4BB1-BB79-5294FD84EBBD@.microsoft.com...
> >I tried to run the new SP2 and it crashes. I get the dialog asking to send
> > the crash data to microsoft.
> >
> > I then checked the upgrade log and found a message saying that it could
> > not
> > log into the server. I know it had the right password because the service
> > pack checks that near the begining.
> >
> > I then checked the service and noticed that is was stopped. I then tried
> > to
> > manually start and stop the service during the upgrade each time I saw
> > that
> > it needed to start or stop it by the messages that came up. That didn't
> > work.
> > It got to a point later that said it could not stop the service.
> >
> > I then changed the login of the services themselves to be tan admin user.
> > That seemed to allow the service pack to start and stop the service ok,
> > but
> > it still crashes near the end now. The message is again that it can't log
> > in.
> >
> > I also must mention that after the first time this happened the small icon
> > on the lower right of the tray that is the sql server is gone.
> >
> > Please help. I need to get the SP2 to succeed so that it will be back to
> > normal.
> >
>
>

Problem installing SQL Server 2005 express, In windows 2000

I have downloaded SQL Server 2005 express from microsoft's site and tried to install in windows 2000 service pack 4 but having an unexpected error. The screenshot and log file is attached. Please suggest.

The error log is as shown:

Microsoft SQL Server 2005 Setup beginning at Fri May 05 21:36:51 2006
Process ID : 1008
e:\469a4a9ba4bfdc9d2db501289fb676\setup.exe Version: 2005.90.2047.0
Running: LoadResourcesAction at: 2006/4/5 21:34:50
Complete: LoadResourcesAction at: 2006/4/5 21:34:50, returned true
Running: ParseBootstrapOptionsAction at: 2006/4/5 21:34:50
Loaded DLL:e:\469a4a9ba4bfdc9d2db501289fb676\xmlrw.dll Version:2.0.3609.0
Complete: ParseBootstrapOptionsAction at: 2006/4/5 21:36:51, returned false
Error: Action "ParseBootstrapOptionsAction" failed during execution. Error information reported during run:
Could not parse command line due to datastore exception.
Source File Name: utillib\persisthelpers.cpp
Compiler Timestamp: Wed Oct 26 16:38:20 2005
Function Name: writeEncryptedString
Source Line Number: 124
-
writeEncryptedString() failed
Source File Name: utillib\persisthelpers.cpp
Compiler Timestamp: Wed Oct 26 16:38:20 2005
Function Name: writeEncryptedString
Source Line Number: 123
-
Error Code: 0x800706b5 (1717)
Windows Error Text: The interface is unknown.

Source File Name: cryptohelper\cryptsameusersamemachine.cpp
Compiler Timestamp: Wed Oct 26 16:37:25 2005
Function Name: sqls::CryptSameUserSameMachine::ProtectData
Source Line Number: 50

1717
Could not skip Component update due to datastore exception.
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Wed Oct 26 16:37:20 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "InstallMediaPath" {"SetupBootstrapOptionsScope", "", "1008"} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Wed Oct 26 16:37:21 2005
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44
-
No collector registered for scope: "SetupBootstrapOptionsScope"
Running: ValidateWinNTAction at: 2006/4/5 21:36:51
Complete: ValidateWinNTAction at: 2006/4/5 21:36:51, returned true
Running: ValidateMinOSAction at: 2006/4/5 21:36:51
Complete: ValidateMinOSAction at: 2006/4/5 21:36:51, returned true
Running: PerformSCCAction at: 2006/4/5 21:36:51
Complete: PerformSCCAction at: 2006/4/5 21:36:51, returned true
Running: ActivateLoggingAction at: 2006/4/5 21:36:51
Error: Action "ActivateLoggingAction" threw an exception during execution. Error information reported during run:
Datastore exception while trying to write logging properties.
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Wed Oct 26 16:37:20 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Wed Oct 26 16:37:21 2005
Function Name: SetupStateScope.primaryLogFiles
Source Line Number: 44
-
No collector registered for scope: "SetupStateScope"
02AFCFC0Unable to proceed with setup, there was a command line parsing error. : 2
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.

Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Wed Oct 26 16:37:21 2005
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44

Class not registered.
Failed to create CAB file due to datastore exception
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Wed Oct 26 16:37:20 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "HostSetup" {"SetupBootstrapOptionsScope", "", "1008"} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Wed Oct 26 16:37:21 2005
Function Name: SetupBootstrapOptionsScope.HostSetup
Source Line Number: 44
-
No collector registered for scope: "SetupBootstrapOptionsScope"
Message pump returning: 2

I had what looks to be the same problem trying to install on three different Windows XP Pro systems. They all had the same problem which was caused by not having the AppData key in \Microsoft\Windows\CurrentVersion\Explorer\User Shell Folders. Here is the text posted by Arron Rouse on Developers dex.
After a good amount of delving with RegMon, I found out why it was not
installing on my customer's build: there was a missing Registry key.

HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\User
Shell Folders\AppData

When a user is created on a system, the AppData key is copied from the
..Default area of the registry:

HKEY_USERS\.DEFAULT\Software\Microsoft\Windows\CurrentVersion\Explorer\User
Shell Folders\AppData

It seems the key had been messed up in my customer's build. Both should be a
REG_EXPAND_SZ and both should be set to %USERPROFILE%\Application Data

Note that if the key is missing on your system, you might have problems when
you put it back in as many programs seem to failover to using the Local
AppData key if it's missing. You might have to set the AppData key to
%USERPROFILE%\Local Settings\Application Data

Problem installing SQL Server 2005 express, In windows 2000

I have downloaded SQL Server 2005 express from microsoft's site and tried to install in windows 2000 service pack 4 but having an unexpected error. The screenshot and log file is attached. Please suggest.

The error log is as shown:

Microsoft SQL Server 2005 Setup beginning at Fri May 05 21:36:51 2006
Process ID : 1008
e:\469a4a9ba4bfdc9d2db501289fb676\setup.exe Version: 2005.90.2047.0
Running: LoadResourcesAction at: 2006/4/5 21:34:50
Complete: LoadResourcesAction at: 2006/4/5 21:34:50, returned true
Running: ParseBootstrapOptionsAction at: 2006/4/5 21:34:50
Loaded DLL:e:\469a4a9ba4bfdc9d2db501289fb676\xmlrw.dll Version:2.0.3609.0
Complete: ParseBootstrapOptionsAction at: 2006/4/5 21:36:51, returned false
Error: Action "ParseBootstrapOptionsAction" failed during execution. Error information reported during run:
Could not parse command line due to datastore exception.
Source File Name: utillib\persisthelpers.cpp
Compiler Timestamp: Wed Oct 26 16:38:20 2005
Function Name: writeEncryptedString
Source Line Number: 124
-
writeEncryptedString() failed
Source File Name: utillib\persisthelpers.cpp
Compiler Timestamp: Wed Oct 26 16:38:20 2005
Function Name: writeEncryptedString
Source Line Number: 123
-
Error Code: 0x800706b5 (1717)
Windows Error Text: The interface is unknown.

Source File Name: cryptohelper\cryptsameusersamemachine.cpp
Compiler Timestamp: Wed Oct 26 16:37:25 2005
Function Name: sqls::CryptSameUserSameMachine::ProtectData
Source Line Number: 50

1717
Could not skip Component update due to datastore exception.
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Wed Oct 26 16:37:20 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "InstallMediaPath" {"SetupBootstrapOptionsScope", "", "1008"} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Wed Oct 26 16:37:21 2005
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44
-
No collector registered for scope: "SetupBootstrapOptionsScope"
Running: ValidateWinNTAction at: 2006/4/5 21:36:51
Complete: ValidateWinNTAction at: 2006/4/5 21:36:51, returned true
Running: ValidateMinOSAction at: 2006/4/5 21:36:51
Complete: ValidateMinOSAction at: 2006/4/5 21:36:51, returned true
Running: PerformSCCAction at: 2006/4/5 21:36:51
Complete: PerformSCCAction at: 2006/4/5 21:36:51, returned true
Running: ActivateLoggingAction at: 2006/4/5 21:36:51
Error: Action "ActivateLoggingAction" threw an exception during execution. Error information reported during run:
Datastore exception while trying to write logging properties.
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Wed Oct 26 16:37:20 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Wed Oct 26 16:37:21 2005
Function Name: SetupStateScope.primaryLogFiles
Source Line Number: 44
-
No collector registered for scope: "SetupStateScope"
02AFCFC0Unable to proceed with setup, there was a command line parsing error. : 2
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.

Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Wed Oct 26 16:37:21 2005
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44

Class not registered.
Failed to create CAB file due to datastore exception
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Wed Oct 26 16:37:20 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "HostSetup" {"SetupBootstrapOptionsScope", "", "1008"} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Wed Oct 26 16:37:21 2005
Function Name: SetupBootstrapOptionsScope.HostSetup
Source Line Number: 44
-
No collector registered for scope: "SetupBootstrapOptionsScope"
Message pump returning: 2

I had what looks to be the same problem trying to install on three different Windows XP Pro systems. They all had the same problem which was caused by not having the AppData key in \Microsoft\Windows\CurrentVersion\Explorer\User Shell Folders. Here is the text posted by Arron Rouse on Developers dex.
After a good amount of delving with RegMon, I found out why it was not
installing on my customer's build: there was a missing Registry key.

HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\User
Shell Folders\AppData

When a user is created on a system, the AppData key is copied from the
..Default area of the registry:

HKEY_USERS\.DEFAULT\Software\Microsoft\Windows\CurrentVersion\Explorer\User
Shell Folders\AppData

It seems the key had been messed up in my customer's build. Both should be a
REG_EXPAND_SZ and both should be set to %USERPROFILE%\Application Data

Note that if the key is missing on your system, you might have problems when
you put it back in as many programs seem to failover to using the Local
AppData key if it's missing. You might have to set the AppData key to
%USERPROFILE%\Local Settings\Application Data

Problem Installing SQL 2000 Sp4

While upgrading Sql 2000 Sp3 thge installer is starting to install the service pack. But after running the scripts he gives a very strange error.

error running: 80sp4-tools.sql (1).

after searching and living on google for 3 days for information about this error, I'am no

really desperate.

I hope someone help me or tell me more about this error.

thanks so far

See the following thread...it may help you...

http://www.ureader.com/message/647952.aspx

|||

Thanks MohammedU,

That problem looks exactly as my problem but, the sp4 is starting to install till script 80sp4-tools.sql. and then the installer stops with the same as in the given thread.

the only error that was given in the log file was "(1)"

thanks so far.

Problem installing MSDE

Hi, are days that i'm trying to install MSDE on my computer (windows XP service pack 1).
The problem is that when I run the setup program from console using SAPWD="(Some password)" SecurityMode=SQL, it fails with that error log:

--- LOG START
2003-08-15 17:56:13.12 server Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 1)

2003-08-15 17:56:13.12 server Copyright (C) 1988-2002 Microsoft Corporation.
2003-08-15 17:56:13.12 server All rights reserved.
2003-08-15 17:56:13.12 server Server Process ID is 3076.
2003-08-15 17:56:13.12 server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL\LOG\ERRORLOG'.
2003-08-15 17:56:13.14 server SQL Server is starting at priority class 'normal'(1 CPU detected).
2003-08-15 17:56:13.18 server SQL Server configured for thread mode processing.
2003-08-15 17:56:13.21 server Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks.
2003-08-15 17:56:13.29 spid3 Warning ******************
2003-08-15 17:56:13.29 spid3 SQL Server started in single user mode. Updates allowed to system catalogs.
2003-08-15 17:56:13.87 spid3 Starting up database 'master'.
2003-08-15 17:56:15.76 server Using 'SSNETLIB.DLL' version '8.0.766'.
2003-08-15 17:56:15.76 spid5 Starting up database 'model'.
2003-08-15 17:56:15.87 spid3 Server name is 'ALEX'.
2003-08-15 17:56:15.87 spid3 Skipping startup of clean database id 5
2003-08-15 17:56:15.87 spid3 Skipping startup of clean database id 6
2003-08-15 17:56:15.87 spid3 Starting up database 'msdb'.
2003-08-15 17:56:17.18 spid5 Clearing tempdb database.
2003-08-15 17:56:18.70 server SQL server listening on Shared Memory.
2003-08-15 17:56:18.70 server SQL Server is ready for client connections
2003-08-15 17:56:21.43 spid5 Starting up database 'tempdb'.
2003-08-15 17:56:22.56 spid3 Recovery complete.
2003-08-15 17:56:22.56 spid3 SQL global counter collection task is created.
2003-08-15 17:56:22.93 spid3 Warning: override, autoexec procedures skipped.
2003-08-15 17:56:36.48 spid3 SQL Server is terminating due to 'stop' request from Service Control Manager.
--- LOG END

if anybody can help, I would really appreciate!
Alex.http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/q185/8/06.asp&NoWebContent=1

you should have googled that last line.

This article was previously published under Q185806
BUG #: Windows NT: 17812 (6.50)
SYMPTOMS
A SQL Server computer that is enabled for clustering with Microsoft Cluster Server (MSCS), may experience sudden stops of the SQL Server service and subsequent restarts of the service. The last error log terminates with the following message:

SQL Server terminating due to 'stop' request from Service Control Manager
CAUSE
The Resource DLL for the SQL Server service exports two functions used by the MSCS Cluster Manager to check for availability of the SQL Server resource at predefined intervals. There is a simple check, LooksAlive, that queries the service status through the Windows NT Service Control Manager, and a more stringent check, IsAlive, that connects to SQL Server as user "probe" and performs a simple query to the system catalog. By default, LooksAlive is fired every 5 seconds and IsAlive is fired every 60 seconds.

IsAlive uses a fixed login time-out of 15 seconds to connect to SQL Server. In situations where the server is very busy, SQL Server may fail to respond to the IsAlive login request within this interval. Thus IsAlive returns FALSE to the Cluster Manager, which issues a Terminate request and a subsequent Online request to SQL Server and the SQL Executive Resource DLL which causes both services to be stopped and restarted.
WORKAROUND
Increase the polling interval for SQL Server's IsAlive test in MSCS Cluster Administrator to decrease the chance for this to happen.
STATUS
Microsoft has confirmed this to be a problem in SQL Server 6.5. This problem has been corrected in U.S. Service Pack 5a for Microsoft SQL Server 6.5. For information about how to download and install the latest SQL Server Service Pack, see the following Microsoft Web site:
http://support.microsoft.com/highlights/sql.asp

For more information, contact your primary support provider.
MORE INFORMATION
If you experience sudden SQL Server restarts in a cluster environment and are unsure of the cause, enable MSCS logging by restarting the MSCS service with the system environment variable "Clusterlog=<path>". MSCS will now log all activity in the specified log file. There you will find, among others, all calls to LooksAlive and IsAlive and their outcome. In a situation where the login fails you'll find the following message in the log:

[sql65res] CheckQueryProcessorAlive: dbopen failed|||I just upgraded to XP pro, was able to get IIS running and figured out how to browse to the server on my home network from another computer.

The goal is simply to follow the instructions when setting up the ASP CSK.

I downloaded and installed MSDE receiving the same error log as shown above.

How do I...

Increase the polling interval for SQL Server's IsAlive test in MSCS Cluster Administrator to decrease the chance for this to happen.

if the only thing I have is MSDE through the ASP.net link? And according to the error log, it isn't installed, because it was 'stop'ped.

Thanks,
Chris

Problem installing Feature Pack for SQL Server 2005 SP2 CTP

Some of the individual installs on the "Feature Pack for Microsoft SQL Server 2005 Service Pack 2 - Community Technology Preview (CTP) November 2006" page available here:

http://www.microsoft.com/downloads/details.aspx?familyid=7a9ad90f-7f95-4369-a206-e84053d63fd3&displaylang=en

say "requires Microsoft Core XML Services (MSXML) 6.0, also available on this page". However, there is not an XML Services install on the page.

Is it included in one of the installs or not needed if you're already running SP1?

Thanks,

Terry

MSXML6 is installed during SQL 2005 RTM install, thus it should be there already for these installs.

Thanks,
Sam Lester (MSFT)