instance

What is the best way to detect if an instance is available? From DMO?
I mean, I'd like to set up a kind of alert that would notify me if an
instance is down. It seems to be possible only from the OS.
Thanks,
kob uki> What is the best way to detect if an instance is available? From DMO?
Yes, you can do it from DMO - check the article at
http://support.microsoft.com/?id=287737.
Additionally, you can check Gert Draper's articles at
http://www.sqldev.net/misc.htm.
--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

Installing SQL Server Through Merge Modules and InstallShield Developer 8

Hi all,

I am having a major issue installing SQL Server 2000 through InstallShield using the three merge modules sent with it (and available on the SQL Server CD) Being:

SQLBASE
SQLSVR
SQLSVR_RES

The install builds fine and runs right upto the end of the copying, where it pauses for a few seconds and comes back with a dialog saying

Product: SQL Object Installer -- Setup failed to configure the server. Refer to the server error logs and setup error logs for more information.

SQL Object Installer being the package I created

So I do this, only to find the following error log:

2004-01-08 09:58:40.65 server Microsoft SQL Server 2000 - 8.00.534 (Intel X86)
Nov 19 2001 13:23:50
Copyright (c) 1988-2000 Microsoft Corporation
Desktop Engine on Windows NT 5.0 (Build 2195: Service Pack 2)

2004-01-08 09:58:40.67 server Copyright (C) 1988-2000 Microsoft Corporation.
2004-01-08 09:58:40.67 server All rights reserved.
2004-01-08 09:58:40.67 server Server Process ID is 1588.
2004-01-08 09:58:40.67 server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL\LOG\ERRORLOG'.
2004-01-08 09:58:40.68 server SQL Server is starting at priority class 'normal'(1 CPU detected).
2004-01-08 09:58:40.76 server SQL Server configured for thread mode processing.
2004-01-08 09:58:40.78 server Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks.
2004-01-08 09:58:40.98 spid3 Warning ******************
2004-01-08 09:58:40.98 spid3 SQL Server started in single user mode. Updates allowed to system catalogs.
2004-01-08 09:58:41.01 spid3 Starting up database 'master'.
2004-01-08 09:58:41.54 server Using 'SSNETLIB.DLL' version '8.0.534'.
2004-01-08 09:58:41.54 spid5 Starting up database 'model'.
2004-01-08 09:58:41.59 spid3 Server name is 'GROUPNETVISTA2'.
2004-01-08 09:58:41.59 spid3 Skipping startup of clean database id 5
2004-01-08 09:58:41.60 spid3 Skipping startup of clean database id 6
2004-01-08 09:58:41.60 spid3 Starting up database 'msdb'.
2004-01-08 09:58:41.84 spid5 Clearing tempdb database.
2004-01-08 09:58:42.10 server SQL server listening on 10.171.1.205: 1433.
2004-01-08 09:58:42.10 server SQL server listening on 127.0.0.1: 1433.
2004-01-08 09:58:42.60 spid5 Starting up database 'tempdb'.
2004-01-08 09:58:42.73 spid3 Recovery complete.
2004-01-08 09:58:42.73 spid3 SQL global counter collection task is created.
2004-01-08 09:58:42.74 spid3 Warning: override, autoexec procedures skipped.
2004-01-08 09:58:47.17 server SQL server listening on TCP, Shared Memory, Named Pipes.
2004-01-08 09:58:47.17 server SQL Server is ready for client connections
2004-01-08 09:58:56.67 spid3 SQL Server is terminating due to 'stop' request from Service Control Manager.

I am stumped, I am not really the greatest with SQL Server so I don't really know where to start, the SCM line at the bottom of the errorlog doesn't tell me much as I can't see what would be sending the 'stop' request?

Could this be a permissions thing. I have set myself as the administrator on the machine and do have quite a few rights. The machine does not already have SQL Server on it as it is a fresh image of Windows 2000 (also tried on XP wth same result)

Any help on this would be most appreciated as all around me are stumped too.

Thanks in advance.
Mark.Did you try to reinstall it from scratch?

installing sql 2005 standard on vista home premium

I have not been able to get iis to be seen correctly. I have turned on every service with IIS7 available and still get warning IIS in not running. I have changed computer name to all caps and I am running on admin account. I see IIS7 when I run localhost. What is wrong here. When I go on to install system I get stuck at detecting installed IIS. As I move forward with install owc, DB services,Notification, Intagrated, and workstation components all fail. I cant move onto sp2 because nothing is installed. I have worked on this for months off and on and now I have to have it running for deadline. Any help would be appreciated. I also have VS2005 and office 2007 on this system. I have worked on this the past two days solid and I have to have it now.

Jeff

when the install fails, what do you see in the files under the log folder under setup bootstrap?|||

Thanks Meher,

I had to uninstall all of the office components and then I was able to get past OWC11. Then I still failed with all the others. I then installed sp2. I then went back and did a mimimal install and it worked. Then I went back and reran sp2. Then I went back and did a complete reinstall and reran sp2. I now have DB on vista. On troublesome problem still is IIS7 I enabled everything I could restarted it and still system did not see it. Different forum and different issue I suspect.

Again Thanks for the williness to help.

Jeff

It would be nice put out updated install directions for sql 2005 standard(different flavors) on VISTA(different flavors). Maybe they did but hours of searching did not produce them.