Auto-start SQL Server Agent on Windows98 
Author Message
 Auto-start SQL Server Agent on Windows98
Hi.

We are using replication. Some of our subscriber machines are running
Windows 98, this is beyond our control. The problem is getting SQL Server
Agent to start automatically after the machine is rebooted. SQL Server Books
online states that it is not possible to do this. I find this somewhat hard
to believe. Is it true, or if not, how do we do it (and why does Books
Online lie)? Is it as simple as dropping the SQL Agent exe into the startup
group?



Tue, 21 Sep 2004 10:48:39 GMT
 Auto-start SQL Server Agent on Windows98

Hi Darren,
What version of SQL server are you using?
If you are using SQL Server 7.0, the following topic in Books on Line has
the workaround:
Topic: SQL Server 7.0 on Windows 95/98
**
Section: SQL Server Desktop Edition on Windows 95/98
+++
Windows 95/98 does not have a component that corresponds to Window NT
services. The SQL Server database engine and SQL Server Agent run as
executable programs on Windows 95/98. These SQL Server components cannot be
started as services automatically. They can be started by placing a command
prompt command in the Windows 95 startup group, but then they run as a
separate MS-DOS? window.
SQL Server Service Manager is installed in the Windows 95/98 startup group
and operates with the same user interface as it does on Windows NT.
++

If you are using  SQL Server 2000

Topic: SQL Server 2000 on Windows 98
++
Section: SQL Server 2000 Server Components on Windows 98
+++
Windows 98 does not have a component that corresponds to Window NT or
Windows 2000 services. The SQL Server database engine and SQL Server Agent
run as executable programs on Windows 98. These SQL Server components
cannot be started as services automatically. They can be started by placing
a command prompt command in the Windows 98 startup group, but then they run
as a separate Microsoft MS-DOS? window.
SQL Server Service Manager is installed in the Windows 98 startup group and
operates with the same user interface as it does on Windows NT and Windows
2000.
+++

So you will be able to start the agents automatically by adding the
following command in the startup group
sqlagent -c
****
sqlagent -c [-v]

Arguments
-c
Indicates that SQL Server Agent is running from the command prompt and is
independent of the Windows NT Service Control Manager. When -c is used, SQL
Server Agent cannot be controlled from either the Services application in
Control Panel or SQL Server Service Manager.
***
Please be aware that the sqlagent process runs in a seperate command
window, and closing the window causes the agent to stop.

The explanation was referring to the fact that the sqlagent on Win9X cannot
be started automatically using the GUI.

HTH.

Thanks
Ramu

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure?  For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.



Sat, 25 Sep 2004 06:28:32 GMT
 Auto-start SQL Server Agent on Windows98
Ramu,

We are running SQL2000. Unfortunately, the Windows98 subscribers are all
desktop machines belonging to clients of ours, which their staff use in
their daily work. This means having a command window might be an issue, as
they are likely to close it, not knowing what it is. At least, I wouldn't
trust them not to, if you know what I mean.

I realise this could be dealt with through training, but your reply has
given me an idea that might work. If I use the CreateProcessA API call, with
the CREATE_NO_WINDOW creation flag inside an executable to start sqlagent,
then once the executable exits, there will be no command window and sqlagent
will run as a background process. At least, that's the theory.

Thanks,
Darren



Quote:
> Hi Darren,
> What version of SQL server are you using?
> If you are using SQL Server 7.0, the following topic in Books on Line has
> the workaround:
> Topic: SQL Server 7.0 on Windows 95/98
> **
> Section: SQL Server Desktop Edition on Windows 95/98
> +++
> Windows 95/98 does not have a component that corresponds to Window NT
> services. The SQL Server database engine and SQL Server Agent run as
> executable programs on Windows 95/98. These SQL Server components cannot
be
> started as services automatically. They can be started by placing a
command
> prompt command in the Windows 95 startup group, but then they run as a
> separate MS-DOS? window.
> SQL Server Service Manager is installed in the Windows 95/98 startup group
> and operates with the same user interface as it does on Windows NT.
> ++

> If you are using  SQL Server 2000

> Topic: SQL Server 2000 on Windows 98
> ++
> Section: SQL Server 2000 Server Components on Windows 98
> +++
> Windows 98 does not have a component that corresponds to Window NT or
> Windows 2000 services. The SQL Server database engine and SQL Server Agent
> run as executable programs on Windows 98. These SQL Server components
> cannot be started as services automatically. They can be started by
placing
> a command prompt command in the Windows 98 startup group, but then they
run
> as a separate Microsoft MS-DOS? window.
> SQL Server Service Manager is installed in the Windows 98 startup group
and
> operates with the same user interface as it does on Windows NT and Windows
> 2000.
> +++

> So you will be able to start the agents automatically by adding the
> following command in the startup group
> sqlagent -c
> ****
> sqlagent -c [-v]

> Arguments
> -c
> Indicates that SQL Server Agent is running from the command prompt and is
> independent of the Windows NT Service Control Manager. When -c is used,
SQL
> Server Agent cannot be controlled from either the Services application in
> Control Panel or SQL Server Service Manager.
> ***
> Please be aware that the sqlagent process runs in a seperate command
> window, and closing the window causes the agent to stop.

> The explanation was referring to the fact that the sqlagent on Win9X
cannot
> be started automatically using the GUI.

> HTH.

> Thanks
> Ramu

> This posting is provided "AS IS" with no warranties, and confers no
rights.

> Are you secure?  For information about the Strategic Technology Protection
> Program and to order your FREE Security Tool Kit, please visit
> http://www.microsoft.com/security.



Sat, 25 Sep 2004 06:57:03 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. SQL server Agent can not autostart when SQL server 7 start

2. Auto-Start SQL Server Agent

3. auto start sql server agent from command line

4. Auto-Starting SQL Server Agent on MSDE

5. SQL Server Agent wont auto start

6. Auto-start SQL Server Agent?

7. Auto start Server Agent

8. SQL 7 Desktop Edition Auto-Start Agent

9. Auto Start SQL Agent

10. SQL Server 2000 does Not Auto-Start when OS starts

11. Start SQL server on Windows98, please help!!!

12. SQLServer Agent NOT starting after upgr frm SQL Server 7.0 to SQL Server 2K


 
Powered by phpBB® Forum Software