Problem of MS SQL -ntwdblib.lib NOT found

Dear all,

I want to use C program to connect MS SQL server.
I copied some sample file to install on my computer.
When I run the program, an error occurred, which is about ntwdblib.dll
not find in some paths.
But when I check the paths again, they have ntwdblib.dll.
When I run my C program in another computer, it works...

so , I feel very frustrated.

In my C program, I include the following libraries.
#defineDBNTWIN32
#include "windows.h"
#include <sqlfront.h>
#include <sqldb.h>
#include <stdio.h
Also, I don't know the meaning of "#defineDBNTWIN32".
I haven't installed SQL Client on my computer. Is it the main
problem??

Pls help!!

Cheers,
Alanalan (cheung_yuklun@.i-cable.com) writes:
> I want to use C program to connect MS SQL server.
> I copied some sample file to install on my computer.
> When I run the program, an error occurred, which is about ntwdblib.dll
> not find in some paths.
> But when I check the paths again, they have ntwdblib.dll.
> When I run my C program in another computer, it works...
> so , I feel very frustrated.
> In my C program, I include the following libraries.
> #define DBNTWIN32
> #include "windows.h"
> #include <sqlfront.h>
> #include <sqldb.h>
> #include <stdio.h>
> Also, I don't know the meaning of "#define DBNTWIN32".
> I haven't installed SQL Client on my computer. Is it the main
> problem??

Yes, that is the problem. NTWDBLIB.DLL is the DLL for DB-Library, which
is not part of MDAC, so SQL connectivity is about the only way to install
it.

DB-Library is a very good client library, but unfortunately Microsoft
does not agree, so they stopped developmet of DB-Lib many years ago.
As a consequence, you have restricted support for new features in
SQL Server with DB-Library.

Unless you have some legacy software you are working with, I'd recommend
you to use ODBC or OLE DB instead.

--
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 making backup of an SQL Server database

I want to make backup of an SQL Server database located on computer LAB3B-NT05 and I want the backup to be stored on another computer. Can that be done?

The commands bellow works fine if I store the database on a local disk.

exec sp_addumpdevice @.devtype = 'disk' , @.logicalname = 'Event_1' , @.physicalname = '\\kbg2863\BackupTest\EventBACKUP.bak'
GO

BACKUP DATABASE Event TO Event_1 WITH FORMAT
GO

exec sp_dropdevice @.logicalname = 'Event_1'
GO

When I execute BACKUP DATABASE Event TO Event_1 WITH FORMAT, I get the followin error:
Server: Msg 3201, Level 16, State 1, Line 1
Cannot open backup device 'Event_1'. Device error or device off-line. See the SQL Server error log for more details.
Server: Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.

The error log says:
BackupDiskFile::CreateMedia: Backup device '\\kbg2863\BackupTest\EventBACKUP.bak' failed to create. Operating system error = 5(Access is denied.).

I have granted the user full access to '\\kbg2863\BackupTest' but still it does not work.

Any ideas?

Regards
Kjell Arne Johansen

Map a drive on the server, and reference this in yoursp_adddumpdevice.|||Thank You for your answer.

So SQL Server does not support UNC?

Regards
Kjell Arne|||

It supports but you need to make sure that the service account for SQL Server has the necessary permissions to access the network share. Generally, it is best to backup locally and then move the file.

|||

Hi all,

I want to backup folders in myserver to a tape using Windows Backup application. The problem is that I cannot see the tape drive when I tried to create the destination of the backup to it. I can see the CD-ROM, diskette drive and HDDs but I cannot see the tape drive. Why is this so? When I go to my computer windows I cannot see the tape drive, even though it is visible at the Device manager window and indicates that it is working perfectly. How do I see it?

Pls assist.

Rufus

Kjell Arne wrote:

I want to make backup of an SQL Server database located on computer LAB3B-NT05 and I want the backup to be stored on another computer. Can that be done?

The commands bellow works fine if I store the database on a local disk.

exec sp_addumpdevice @.devtype = 'disk' , @.logicalname = 'Event_1' , @.physicalname = '\\kbg2863\BackupTest\EventBACKUP.bak'
GO

BACKUP DATABASE Event TO Event_1 WITH FORMAT
GO

exec sp_dropdevice @.logicalname = 'Event_1'
GO

When I execute BACKUP DATABASE Event TO Event_1 WITH FORMAT, I get the followin error:
Server: Msg 3201, Level 16, State 1, Line 1
Cannot open backup device 'Event_1'. Device error or device off-line. See the SQL Server error log for more details.
Server: Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.

The error log says:
BackupDiskFile::CreateMedia: Backup device '\\kbg2863\BackupTest\EventBACKUP.bak' failed to create. Operating system error = 5(Access is denied.).

I have granted the user full access to '\\kbg2863\BackupTest' but still it does not work.

Any ideas?

Regards
Kjell Arne Johansen

Problem making backup of an SQL Server database

I want to make backup of an SQL Server database located on computer LAB3B-NT05 and I want the backup to be stored on another computer. Can that be done?

The commands bellow works fine if I store the database on a local disk.

exec sp_addumpdevice @.devtype = 'disk' , @.logicalname = 'Event_1' , @.physicalname = '\\kbg2863\BackupTest\EventBACKUP.bak'
GO

BACKUP DATABASE Event TO Event_1 WITH FORMAT
GO

exec sp_dropdevice @.logicalname = 'Event_1'
GO

When I execute BACKUP DATABASE Event TO Event_1 WITH FORMAT, I get the followin error:
Server: Msg 3201, Level 16, State 1, Line 1
Cannot open backup device 'Event_1'. Device error or device off-line. See the SQL Server error log for more details.
Server: Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.

The error log says:
BackupDiskFile::CreateMedia: Backup device '\\kbg2863\BackupTest\EventBACKUP.bak' failed to create. Operating system error = 5(Access is denied.).

I have granted the user full access to '\\kbg2863\BackupTest' but still it does not work.

Any ideas?

Regards
Kjell Arne Johansen

Map a drive on the server, and reference this in yoursp_adddumpdevice.|||Thank You for your answer.

So SQL Server does not support UNC?

Regards
Kjell Arne|||

It supports but you need to make sure that the service account for SQL Server has the necessary permissions to access the network share. Generally, it is best to backup locally and then move the file.

|||

Hi all,

I want to backup folders in myserver to a tape using Windows Backup application. The problem is that I cannot see the tape drive when I tried to create the destination of the backup to it. I can see the CD-ROM, diskette drive and HDDs but I cannot see the tape drive. Why is this so? When I go to my computer windows I cannot see the tape drive, even though it is visible at the Device manager window and indicates that it is working perfectly. How do I see it?

Pls assist.

Rufus

Kjell Arne wrote:

I want to make backup of an SQL Server database located on computer LAB3B-NT05 and I want the backup to be stored on another computer. Can that be done?

The commands bellow works fine if I store the database on a local disk.

exec sp_addumpdevice @.devtype = 'disk' , @.logicalname = 'Event_1' , @.physicalname = '\\kbg2863\BackupTest\EventBACKUP.bak'
GO

BACKUP DATABASE Event TO Event_1 WITH FORMAT
GO

exec sp_dropdevice @.logicalname = 'Event_1'
GO

When I execute BACKUP DATABASE Event TO Event_1 WITH FORMAT, I get the followin error:
Server: Msg 3201, Level 16, State 1, Line 1
Cannot open backup device 'Event_1'. Device error or device off-line. See the SQL Server error log for more details.
Server: Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.

The error log says:
BackupDiskFile::CreateMedia: Backup device '\\kbg2863\BackupTest\EventBACKUP.bak' failed to create. Operating system error = 5(Access is denied.).

I have granted the user full access to '\\kbg2863\BackupTest' but still it does not work.

Any ideas?

Regards
Kjell Arne Johansen

Problem Installing SQl express

hi, Im trying to install SQL express 2005 on my Desktop Computer and I keep running into the error "Setup has detected a problem with Microsoft .Net Framework installation and cannot proceed .Net Framework 2.0 is either not installed on this system or is corrupt"
when infact it is installed.. any sugestions?

By the way im Running Windows X64 Pro with a AMD athlon X2 3800+ CPU and 2GB of Corsair DDr2 ram

I would try removing and then re-installing .NET Framework 2.0, the error would seem to suggest that there is a problem with your installation. I would assume that the .NET Framework 2.0 installer would tell you if you tried to install the 32-bit version on your x64 computer, but just the same, make sure you're installing the right bit level version of the framework.

Mike

|||Thanks for oyur Reply mike, I have solved the problem :] It turns out i was using the Beta 2 build of the .net framework.. after Some searching i found the Final build of the framework and the installation succeded|||

That would do it.

Mike

Problem Installing MS-SQLSERVER on Laptop

Hello Friends at dBForum !!

:confused: I have a strange problem, and I need to know what would be the source of this. I have a laptop computer with the following configuration:

Pentium III
Brand : Toshiba
Speed : 500 Mhz
RAM : 192 MB
Hard Disk : 6 GB
Space Available : 4 GB
O.S. : Windows 98

The computer works pretty good and run different applications. I was trying to install MS-SQLSERVER 2000 and I checked out the software and hardware requierements for that and everything seems to be fine. The reason that I need it its because of my trips, and its incredible I have a desktop computer with almost the same configuration and runs pretty good.

When you have a problem installing SQL-SERVER 2000 you have a file called cnfgsvr with all the explanation. I got this at hand so you can see better the problem:

Iniciando servicio ...

Conectando con el servidor ...

driver={sql server};server=3110CT;UID=sa;PWD=;database=master

[Microsoft][ODBC SQL Server Driver][Shared Memory]No existe el servidor SQL Server o se ha denegado el acceso al mismo.

[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()).

driver={sql server};server=3110CT;UID=sa;PWD=;database=master

[Microsoft][ODBC SQL Server Driver][Shared Memory]No existe el servidor SQL Server o se ha denegado el acceso al mismo.

[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()).

driver={sql server};server=.;UID=sa;PWD=;database=master

[Microsoft][ODBC SQL Server Driver][Named Pipes]No existe el servidor SQL Server o se ha denegado el acceso al mismo.

[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionOpen (Connect()).

Error de configuracin del servidor SQL Server.

This is what I got after the installation fails: Here is the log sequence, and I got this from a file called sqlstp2000:

14:37:28 CoreCOM
14:37:28 CoreCOM\Res1033
14:37:28 CoreCOM\ResIntl
14:37:28 CoreTool
14:37:28 CoreTool\Res1033
14:37:28 CoreTool\ResOther
14:37:28 DBLibCli
14:37:28 SFExt
14:37:28 SFExt\ActiveX
14:37:28 SFExt\ActiveX\Res1033
14:37:28 SFExt\ActiveX\ResIntl
14:37:28 SFExt\Res1033
14:37:28 SFExt\ResIntl
14:37:28 Trace
14:37:28 Trace\Res1033
14:37:28 Trace\ResOther
14:37:28 MiscCore
14:37:28 MC
14:37:28 MC\MC1033
14:37:28 MC\MCIntl
14:37:28 MC\Help
14:37:28 SQLMgr
14:37:28 SQLMgr\Res1033
14:37:28 SQLMgr\ResIntl
14:37:28 SvrTool
14:37:28 SvrTool\Res1033
14:37:28 SvrTool\ResIntl
14:37:28 DTSUI
14:37:28 DTSUI\Res1033
14:37:28 DTSUI\ResIntl
14:37:28 MSOlap
14:37:28 MSOlap\Res1033
14:37:28 MSOlap\ResIntl
14:37:28 ATL
14:37:28 ATL\winnt
14:37:28 ATL\win9x
14:37:28 MFC42U
14:37:28 VC
14:37:28 VB
14:37:28 SQLAdHlp
14:37:28 SQLAdHlp\Res1033
14:37:28 SQLAdHlp\ResOther
14:37:28 {E07FDDC8-5A21-11d2-9DAD-00C04F79D434}
14:37:28 {E07FDDBE-5A21-11d2-9DAD-00C04F79D434}
14:37:28 {E07FDDC7-5A21-11d2-9DAD-00C04F79D434}
14:37:28 {E07FDDC0-5A21-11d2-9DAD-00C04F79D434}
14:37:28 {E07FDDBF-5A21-11d2-9DAD-00C04F79D434}
14:37:28 End Action LogSelectedComponents
14:37:28 Begin Action InstallPkgs:
14:37:28 Begin Action: Locked Connectivity Files Check
14:37:29 ConnectivityLocked returned: 0
14:37:29 The operation completed successfully.

14:37:29 End Action: Locked Connectivity Files Check
14:37:29 El programa de instalacin est instalando Microsoft Data Access Components (MDAC)...
14:37:29 E:\X86\Other\sqlredis.exe /q:a /C:"setupre.exe WARN=1 -s -SMS"
14:38:10 ExitCode: 0
14:38:10 El programa de instalacin est instalando Microsoft Management Console (MMC) ...
14:38:10 E:\X86\Other\instmmc.exe /Q
14:38:36 Process Exit Code: (0)
14:38:36 Se est instalando el Coordinador de transacciones distribuidas de Microsoft (MSDTC)...
14:38:36 E:\X86\Other\dtcsetup.exe /q:a /r:n
14:38:53 Process Exit Code: (0)
14:38:53 /Q:A /T:C:\WINDOWS\TEMP\ixp001.tmp
14:38:53 El programa de instalacin est instalando la Ayuda HTML...
14:38:55 HTML Help installer exit code: 0
14:39:18 End Action InstallPkgs
14:39:18 Begin Action MoveFileData:
14:39:18 Enabled SELFREGISTERBATCH
14:39:18 Enabled CORECOMPONENTHANDLING
14:42:27 ComponentMoveData exit code: -117
14:42:27 ComponentMoveData: -117
14:42:51 No se puede leer el archivo especificado. Puede ser a causa de una conexin de red de bajo rendimiento. Corrija el problema y reinicie el programa de instalacin. ( This message says that the computer can not read the specified file or its a problem related to a network connection of low performance. According to the message here shown, I have to fix the problem and reinstall. ) I did it, even I deleted the entries related to this on the windows registry and after restarting the problem stills...

Archivo: E:\X86\SETUP\..\..\Install\replmerg.sql

14:42:51 Begin Action: MoveFileDataSpecial
14:42:52 End Action: MoveFileDataSpecial
14:42:52 Action CleanUpInstall:
14:42:52 StatsGenerate returned: 2
14:42:52 StatsGenerate (0x0,0x1,0xf0000,0x0,1034,303,0x0,0x1,0,0,0
14:42:52 StatsGenerate -1,Alessandro)
14:42:52 Installation Failed.

On the other hand, I tried to install MS-SQLSERVER 7.0 ( you know if I can get do it with MS-SQLSERVER 2000 ) and this is what I got :

2005-02-17 13:08:26.77 kernel Microsoft SQL Server 7.00 - 7.00.623 (Intel X86)
Nov 27 1998 22:20:07
Copyright (c) 1988-1998 Microsoft Corporation
Desktop Edition on Windows 4.10 (Build 2222: A )

2005-02-17 13:08:26.84 kernel Copyright 1987-1998 Microsoft Corporation.
2005-02-17 13:08:26.84 kernel Reservados todos los derechos.
2005-02-17 13:08:26.84 kernel Registrando los mensajes de SQL Server en el archivo 'C:\MSSQL7\log\ERRORLOG'.
2005-02-17 13:08:27.00 kernel initconfig: nmero de conexiones de usuario limitado a 32767.
2005-02-17 13:08:27.01 kernel SQL Server se iniciar con clase de prioridad 'normal'( se detect 1 CPU).
2005-02-17 13:08:27.21 kernel User Mode Scheduler configured for thread processing
2005-02-17 13:08:28.61 server Directory Size: 8087
2005-02-17 13:08:28.68 spid1 Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks
2005-02-17 13:08:28.74 spid1 failed to get sqlservr image range
2005-02-17 13:08:28.78 spid1 Advertencia ******************
2005-02-17 13:08:28.79 spid1 SQL Server iniciado en modo de usuario nico. Se permiten las actualizaciones en los catlogos del sistema.
2005-02-17 13:08:28.79 spid1 Advertencia ******************
2005-02-17 13:08:28.79 spid1 Recovering only master database
2005-02-17 13:08:28.85 spid1 Iniciando la base de datos 'master'.
2005-02-17 13:08:28.85 spid1 Opening file C:\MSSQL7\data\master.mdf.
2005-02-17 13:08:28.97 spid1 Opening file C:\MSSQL7\data\mastlog.ldf.
2005-02-17 13:08:29.06 spid1 Cargando el mtodo de intercalacin Unicode de SQL Server.
2005-02-17 13:08:29.16 spid1 Cargando el orden y conjunto de caracteres no Unicode de SQL Server.
2005-02-17 13:08:29.41 spid1 4 transacciones confirmadas en la base de datos 'master' (1).
2005-02-17 13:08:29.41 spid1 0 transacciones deshechas en la base de datos 'master' (1).
2005-02-17 13:08:29.65 spid1 El servidor no tiene nombre.
2005-02-17 13:08:29.65 kernel Se utiliza 'SQLEVN70.DLL' versin '7.00.623'.
2005-02-17 13:08:29.72 kernel Se utiliza 'OPENDS60.DLL' versin '7.00.00.0623'.
2005-02-17 13:08:29.83 ods Utilizando 'SSMSSH70.DLL' versin '7.0.623' para escuchar en ''.
2005-02-17 13:08:29.89 ods Utilizando 'SSMSSO70.DLL' versin '7.0.623' para escuchar en '1433'.
2005-02-17 13:08:30.09 ods Utilizando 'SSMSRP70.DLL' versin '7.0.623' para escuchar en '3110CT'.
2005-02-17 13:08:31.11 spid1 El mtodo de intercalacin Unicode de SQL Server es:
2005-02-17 13:08:31.11 spid1 'English' (Id. = 1033).
2005-02-17 13:08:31.11 spid1 estilo de comparacin = 196609.
2005-02-17 13:08:31.11 spid1 El orden no Unicode de SQL Server es:
2005-02-17 13:08:31.11 spid1 'nocase_iso' (Id. = 52).
2005-02-17 13:08:31.11 spid1 El juego de caracteres no Unicode de SQL Server es:
2005-02-17 13:08:31.11 spid1 'iso_1' (Id. = 1).
2005-02-17 13:08:31.19 kernel Warning: override, autoexec procedures skipped.
2005-02-17 13:10:23.67 kernel SQL Server terminar debido a una peticin de 'detencin' del Administrador de control de servicios.

Accordiing to the message shown in the bottom line, we may see its like the installation were stopped because of a request of the Control Service Manager. I never stop the installation or something like that but I dont have a clue why or where is the problem here.

My desktop computer is standalone and works without problems. Of course I read that if you have PWS ( Personal Web Server ) running you may need to stop that first, and then proceed. I did it and it never worked.

If you have any suggestion about it, this would be greatly appreciated.

Thank you so much,

Cordially,

Alessandro Barbieri - PeruHi

Remove SQL Server and use MSDE insted.|||I will try it. Thanks

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 install SQL Server Desktop Engine

I'm in the process of attempting to install Microsoft SQL Server Desktop Engine on my computer in support of an email program call Mailloop6. I've tried going through their tech support but they haven't been able to figure it out.

I'm running Windows XP with SP1 upgrade on a DSL connection.

When I installed the program the first time, I got the following error:

"Setup failed to configure the server. Refer to the server error logs and
setup error logs for more information."

The program obviously wouldn't install. I contacted the vendor and they sent a version with a batch file. Same result. I removed all the appropriate registry entries between installs and removed all the data files as well.

I've tried installing the program using the free MDSE download from the MS site with the following result:

"A Strong SA password is required for security reasons. Please use SAPWD switch to supply the same. Refer to readme for more details. Setup will now exit."

Here's the error log that I got after attempting to install:

2004-02-25 19:31:42.55 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)

2004-02-25 19:31:42.55 server Copyright (C) 1988-2002 Microsoft Corporation.
2004-02-25 19:31:42.55 server All rights reserved.
2004-02-25 19:31:42.55 server Server Process ID is 3404.
2004-02-25 19:31:42.55 server Logging SQL Server messages in file 'C:Program FilesMicrosoft SQL ServerMSSQL$MAILLOOP6LOGERRORLOG'.
2004-02-25 19:31:42.56 server SQL Server is starting at priority class 'normal'(1 CPU detected).
2004-02-25 19:31:42.60 server SQL Server configured for thread mode processing.
2004-02-25 19:31:42.60 server Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks.
2004-02-25 19:31:42.63 spid3 Warning ******************
2004-02-25 19:31:42.63 spid3 SQL Server started in single user mode. Updates allowed to system catalogs.
2004-02-25 19:31:42.63 spid3 Starting up database 'master'.
2004-02-25 19:31:42.91 server Using 'SSNETLIB.DLL' version '8.0.766'.
2004-02-25 19:31:42.94 spid5 Starting up database 'model'.
2004-02-25 19:31:43.24 server SQL server listening on 152.163.0.0: 4113.
2004-02-25 19:31:43.24 server SQL server listening on 172.16.1.33: 4113.
2004-02-25 19:31:43.24 server SQL server listening on 127.0.0.1: 4113.
2004-02-25 19:31:43.25 spid3 Server name is 'MONSTERMAILLOOP6'.
2004-02-25 19:31:43.25 spid3 Skipping startup of clean database id 5
2004-02-25 19:31:43.25 spid3 Skipping startup of clean database id 6
2004-02-25 19:31:43.25 spid3 Starting up database 'msdb'.
2004-02-25 19:31:43.56 spid5 Clearing tempdb database.
2004-02-25 19:31:44.13 spid5 Starting up database 'tempdb'.
2004-02-25 19:31:44.17 spid3 Recovery complete.
2004-02-25 19:31:44.17 spid3 SQL global counter collection task is created.
2004-02-25 19:31:44.19 spid3 Warning: override, autoexec procedures skipped.
2004-02-25 19:31:47.75 server SQL server listening on TCP, Shared Memory, Named Pipes.
2004-02-25 19:31:47.75 server SQL Server is ready for client connections
2004-02-25 19:31:57.97 spid3 SQL Server is terminating due to 'stop' request from Service Control Manager.

Any thoughts on this would be very much appreciated!Originally posted by betteru
I'm in the process of attempting to install Microsoft SQL Server Desktop Engine on my computer in support of an email program call Mailloop6. I've tried going through their tech support but they haven't been able to figure it out.

I'm running Windows XP with SP1 upgrade on a DSL connection.

When I installed the program the first time, I got the following error:

"Setup failed to configure the server. Refer to the server error logs and
setup error logs for more information."

The program obviously wouldn't install. I contacted the vendor and they sent a version with a batch file. Same result. I removed all the appropriate registry entries between installs and removed all the data files as well.

I've tried installing the program using the free MDSE download from the MS site with the following result:

"A Strong SA password is required for security reasons. Please use SAPWD switch to supply the same. Refer to readme for more details. Setup will now exit."

Here's the error log that I got after attempting to install:

2004-02-25 19:31:42.55 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)

2004-02-25 19:31:42.55 server Copyright (C) 1988-2002 Microsoft Corporation.
2004-02-25 19:31:42.55 server All rights reserved.
2004-02-25 19:31:42.55 server Server Process ID is 3404.
2004-02-25 19:31:42.55 server Logging SQL Server messages in file 'C:Program FilesMicrosoft SQL ServerMSSQL$MAILLOOP6LOGERRORLOG'.
2004-02-25 19:31:42.56 server SQL Server is starting at priority class 'normal'(1 CPU detected).
2004-02-25 19:31:42.60 server SQL Server configured for thread mode processing.
2004-02-25 19:31:42.60 server Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks.
2004-02-25 19:31:42.63 spid3 Warning ******************
2004-02-25 19:31:42.63 spid3 SQL Server started in single user mode. Updates allowed to system catalogs.
2004-02-25 19:31:42.63 spid3 Starting up database 'master'.
2004-02-25 19:31:42.91 server Using 'SSNETLIB.DLL' version '8.0.766'.
2004-02-25 19:31:42.94 spid5 Starting up database 'model'.
2004-02-25 19:31:43.24 server SQL server listening on 152.163.0.0: 4113.
2004-02-25 19:31:43.24 server SQL server listening on 172.16.1.33: 4113.
2004-02-25 19:31:43.24 server SQL server listening on 127.0.0.1: 4113.
2004-02-25 19:31:43.25 spid3 Server name is 'MONSTERMAILLOOP6'.
2004-02-25 19:31:43.25 spid3 Skipping startup of clean database id 5
2004-02-25 19:31:43.25 spid3 Skipping startup of clean database id 6
2004-02-25 19:31:43.25 spid3 Starting up database 'msdb'.
2004-02-25 19:31:43.56 spid5 Clearing tempdb database.
2004-02-25 19:31:44.13 spid5 Starting up database 'tempdb'.
2004-02-25 19:31:44.17 spid3 Recovery complete.
2004-02-25 19:31:44.17 spid3 SQL global counter collection task is created.
2004-02-25 19:31:44.19 spid3 Warning: override, autoexec procedures skipped.
2004-02-25 19:31:47.75 server SQL server listening on TCP, Shared Memory, Named Pipes.
2004-02-25 19:31:47.75 server SQL Server is ready for client connections
2004-02-25 19:31:57.97 spid3 SQL Server is terminating due to 'stop' request from Service Control Manager.

Any thoughts on this would be very much appreciated!

with the desktop edition the setup does not work in windows! you must exit to dos and on the directory where you've installed msde you must write:
setup.exe /qb+ instancename= something sapwd=your password|||I did not know that - the tech support for the software didn't mention a single thing about exiting to DOS. I will definitely give that a try.

Thanks!

Problem install on FrameWork 2.0.40607.0

Hi,
I have problem to set up RS on a computer with Whidbey installed. (ASP.NET
2.0.40607.0)
The setup claims that ASP.NET is not installed "ASP.NET version 1.1 is not
installed or is not registered on your Web server".
But is installed and registered.
The installation procedure halts on the System Prerequisites.
Anyone who have expirence of this problem? Is there a way around this
problem?
Best Regards
ThomasI've tried working with this as well. I got them both installed by
installed .NET 1.1, then RS, then 2.0.. however, this caused its own mess of
problems... which Ifinally just stopped on... Apparently this should work
better in SQL 2005... Which I'm sure everyone is just dying to jump
into... Yeah... ever DBA I know is going to...
and by that I mean they are not... in case you didn't pick up the massive
amount of sarcasm to that. =)
"Thomas Eriksson" <thomas.eriksson@.intress.se> wrote in message
news:ed1zFCbuEHA.376@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I have problem to set up RS on a computer with Whidbey installed. (ASP.NET
> 2.0.40607.0)
> The setup claims that ASP.NET is not installed "ASP.NET version 1.1 is not
> installed or is not registered on your Web server".
> But is installed and registered.
> The installation procedure halts on the System Prerequisites.
> Anyone who have expirence of this problem? Is there a way around this
> problem?
> Best Regards
> Thomas
>