Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Can't start SQL Server as a service using AT scheduling service

4 posts in Windows NT Last posting was on 1999-12-16 00:15:39.0Z
Grant Heryet Posted on 1999-12-13 15:33:33.0Z
Reply-To: "Grant Heryet" <cfretsg3@bconex.net>
From: "Grant Heryet" <cfretsg3@bconex.net>
Subject: Can't start SQL Server as a service using AT scheduling service
Date: Mon, 13 Dec 1999 10:33:33 -0500
Lines: 39
Organization: Dept. of National Defence (Canada)
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
Message-ID: <oyGbk9XR$GA.50@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: pro1-135.barrie.connex.net 205.189.200.135
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2829
Article PK: 1090266

Here are the details of the server;

COMPAQ Proliant 4500, Quad Pentium-100, 256MB RAM, 12GB drive space
MS Windows NT 4.0 Enterprise with Service Pack 6
Adaptive Server Enterprise 11.5 for Windows NT

Here is what I have attempted so far;

1) starts using Sybase Central.

2) from the command line issued the net start command (i.e. net start
"Sybase SQLServer _ data_5rd_nt") and this works. Also starts Sybase
BCKServer this way as well.

3) created a batch file containing the net start command, executed from the
command line, and this works as well. (Again, this works for Sybase
BCKServer as well)

But, here is the problem;

When I attempt to execute the batch file using the AT command, the SQL
server will not start up, but the Sybase BCKServer will start up.

There are no errors reported in the log file either, it just doesn't start.

So my questions is this, does anyone know what I need to configure or change
so that I can start the SQLServer using the AT command/scheduling service.

Has anyone else been able to do this?

Thanks in advance

Grant Heryet
ITMIS Sytem Administrator
Canadian Forces Base Borden
E-mail: cfretsg3@bconnex.net


Tony Imbierski Posted on 1999-12-13 16:42:30.0Z
Message-ID: <385521F6.9025AD4C@sybase.com>
Date: Mon, 13 Dec 1999 16:42:30 +0000
From: Tony Imbierski <tonyi@sybase.com>
X-Mailer: Mozilla 4.61 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Can't start SQL Server as a service using AT scheduling service
References: <oyGbk9XR$GA.50@forums.sybase.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 36
NNTP-Posting-Host: chirico.sybase.com 158.76.102.96
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2827
Article PK: 1090265

Try altering the user account for the schedule service. The AT system often
suffers from security permission problems.
cheers,
tonyi

Grant Heryet wrote:

> Here are the details of the server;
>
> COMPAQ Proliant 4500, Quad Pentium-100, 256MB RAM, 12GB drive space
> MS Windows NT 4.0 Enterprise with Service Pack 6
> Adaptive Server Enterprise 11.5 for Windows NT
>
> Here is what I have attempted so far;
>
> 1) starts using Sybase Central.
>
> 2) from the command line issued the net start command (i.e. net start
> "Sybase SQLServer _ data_5rd_nt") and this works. Also starts Sybase
> BCKServer this way as well.
>
> 3) created a batch file containing the net start command, executed from the
> command line, and this works as well. (Again, this works for Sybase
> BCKServer as well)
>
> But, here is the problem;
>
> When I attempt to execute the batch file using the AT command, the SQL
> server will not start up, but the Sybase BCKServer will start up.
>
> There are no errors reported in the log file either, it just doesn't start.
>
> So my questions is this, does anyone know what I need to configure or change
> so that I can start the SQLServer using the AT command/scheduling service.
>
> Has anyone else been able to do this?
>
> Thanks in advance
>
> Grant Heryet
> ITMIS Sytem Administrator
> Canadian Forces Base Borden
> E-mail: cfretsg3@bconnex.net


Grant Heryet Posted on 1999-12-15 15:41:22.0Z
Reply-To: "Grant Heryet" <cfretsg3@bconex.net>
From: "Grant Heryet" <cfretsg3@bconex.net>
References: <oyGbk9XR$GA.50@forums.sybase.com> <385521F6.9025AD4C@sybase.com>
Subject: Re: Can't start SQL Server as a service using AT scheduling service
Date: Wed, 15 Dec 1999 10:41:22 -0500
Lines: 71
Organization: Dept. of National Defence (Canada)
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
Message-ID: <XRTWQLxR$GA.50@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: pro3-253.barrie.connex.net 205.189.200.253
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2814
Article PK: 1090253

Thanks Tony, that has solved the problem, BUT it has introduced a 2nd
problem.

I can now use the AT service to start up the SQLServer, but I can't get the
AT service to start it after the first time without re-booting the server.

What I am attempting to do is use the AT service to stop all SYBASE
services, so that I can do a complete file system backup, and then re-start
all the SYBASE services. The new problem is that on the 2nd day I can't
start the SYBASE service using the AT command/service.

Any ideas?

Thanks

Grant

"Tony Imbierski" <tonyi@sybase.com> wrote in message
news:385521F6.9025AD4C@sybase.com...
>
> Try altering the user account for the schedule service. The AT system
often
> suffers from security permission problems.
> cheers,
> tonyi
>
> Grant Heryet wrote:
>
> > Here are the details of the server;
> >
> > COMPAQ Proliant 4500, Quad Pentium-100, 256MB RAM, 12GB drive space
> > MS Windows NT 4.0 Enterprise with Service Pack 6
> > Adaptive Server Enterprise 11.5 for Windows NT
> >
> > Here is what I have attempted so far;
> >
> > 1) starts using Sybase Central.
> >
> > 2) from the command line issued the net start command (i.e. net start
> > "Sybase SQLServer _ data_5rd_nt") and this works. Also starts Sybase
> > BCKServer this way as well.
> >
> > 3) created a batch file containing the net start command, executed from
the
> > command line, and this works as well. (Again, this works for Sybase
> > BCKServer as well)
> >
> > But, here is the problem;
> >
> > When I attempt to execute the batch file using the AT command, the SQL
> > server will not start up, but the Sybase BCKServer will start up.
> >
> > There are no errors reported in the log file either, it just doesn't
start.
> >
> > So my questions is this, does anyone know what I need to configure or
change
> > so that I can start the SQLServer using the AT command/scheduling
service.
> >
> > Has anyone else been able to do this?
> >
> > Thanks in advance
> >
> > Grant Heryet
> > ITMIS Sytem Administrator
> > Canadian Forces Base Borden
> > E-mail: cfretsg3@bconnex.net
>


Tony Imbierski Posted on 1999-12-16 00:15:39.0Z
Message-ID: <38582F2B.248E03AB@sybase.com>
Date: Thu, 16 Dec 1999 00:15:39 +0000
From: Tony Imbierski <tonyi@sybase.com>
X-Mailer: Mozilla 4.61 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Can't start SQL Server as a service using AT scheduling service
References: <oyGbk9XR$GA.50@forums.sybase.com> <385521F6.9025AD4C@sybase.com> <XRTWQLxR$GA.50@forums.sybase.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 61
NNTP-Posting-Host: 158.76.4.83
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2812
Article PK: 1090250

Do you get any Sybase error messages logged (ie.does the server get off the
ground at all??)

cheers,
tonyi

Grant Heryet wrote:

> Thanks Tony, that has solved the problem, BUT it has introduced a 2nd
> problem.
>
> I can now use the AT service to start up the SQLServer, but I can't get the
> AT service to start it after the first time without re-booting the server.
>
> What I am attempting to do is use the AT service to stop all SYBASE
> services, so that I can do a complete file system backup, and then re-start
> all the SYBASE services. The new problem is that on the 2nd day I can't
> start the SYBASE service using the AT command/service.
>
> Any ideas?
>
> Thanks
>
> Grant
>
> "Tony Imbierski" <tonyi@sybase.com> wrote in message
> news:385521F6.9025AD4C@sybase.com...
> >
> > Try altering the user account for the schedule service. The AT system
> often
> > suffers from security permission problems.
> > cheers,
> > tonyi
> >
> > Grant Heryet wrote:
> >
> > > Here are the details of the server;
> > >
> > > COMPAQ Proliant 4500, Quad Pentium-100, 256MB RAM, 12GB drive space
> > > MS Windows NT 4.0 Enterprise with Service Pack 6
> > > Adaptive Server Enterprise 11.5 for Windows NT
> > >
> > > Here is what I have attempted so far;
> > >
> > > 1) starts using Sybase Central.
> > >
> > > 2) from the command line issued the net start command (i.e. net start
> > > "Sybase SQLServer _ data_5rd_nt") and this works. Also starts Sybase
> > > BCKServer this way as well.
> > >
> > > 3) created a batch file containing the net start command, executed from
> the
> > > command line, and this works as well. (Again, this works for Sybase
> > > BCKServer as well)
> > >
> > > But, here is the problem;
> > >
> > > When I attempt to execute the batch file using the AT command, the SQL
> > > server will not start up, but the Sybase BCKServer will start up.
> > >
> > > There are no errors reported in the log file either, it just doesn't
> start.
> > >
> > > So my questions is this, does anyone know what I need to configure or
> change
> > > so that I can start the SQLServer using the AT command/scheduling
> service.
> > >
> > > Has anyone else been able to do this?
> > >
> > > Thanks in advance
> > >
> > > Grant Heryet
> > > ITMIS Sytem Administrator
> > > Canadian Forces Base Borden
> > > E-mail: cfretsg3@bconnex.net
> >