MSSQLServer services

I'm running SQL 7.0 SP4 on NT 4.0. Each time i restart server, the sql
services just showing starting status for 2 minutes & gives error message "1
or more services failed to start". I have start the services manually. I've
tried to reinstall sql server but still the same. Kindly advice wht could be
the possible causes for this problem.
ThanksHi
What does the NT event log say? Any startup errors are logged there.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"chittana" <chittana@.discussions.microsoft.com> wrote in message
news:638D188B-8D35-4667-BFE3-0225BA31CB4B@.microsoft.com...
> I'm running SQL 7.0 SP4 on NT 4.0. Each time i restart server, the sql
> services just showing starting status for 2 minutes & gives error message
"1
> or more services failed to start". I have start the services manually.
I've
> tried to reinstall sql server but still the same. Kindly advice wht could
be
> the possible causes for this problem.
> Thanks|||Nope Mike. No startup error been logged in NT event log.
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> What does the NT event log say? Any startup errors are logged there.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "chittana" <chittana@.discussions.microsoft.com> wrote in message
> news:638D188B-8D35-4667-BFE3-0225BA31CB4B@.microsoft.com...
> > I'm running SQL 7.0 SP4 on NT 4.0. Each time i restart server, the sql
> > services just showing starting status for 2 minutes & gives error message
> "1
> > or more services failed to start". I have start the services manually.
> I've
> > tried to reinstall sql server but still the same. Kindly advice wht could
> be
> > the possible causes for this problem.
> >
> > Thanks
>
>

MSSQLServer services

I'm running SQL 7.0 SP4 on NT 4.0. Each time i restart server, the sql
services just showing starting status for 2 minutes & gives error message "1
or more services failed to start". I have start the services manually. I've
tried to reinstall sql server but still the same. Kindly advice wht could be
the possible causes for this problem.
Thanks
Hi
What does the NT event log say? Any startup errors are logged there.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"chittana" <chittana@.discussions.microsoft.com> wrote in message
news:638D188B-8D35-4667-BFE3-0225BA31CB4B@.microsoft.com...
> I'm running SQL 7.0 SP4 on NT 4.0. Each time i restart server, the sql
> services just showing starting status for 2 minutes & gives error message
"1
> or more services failed to start". I have start the services manually.
I've
> tried to reinstall sql server but still the same. Kindly advice wht could
be
> the possible causes for this problem.
> Thanks
|||Nope Mike. No startup error been logged in NT event log.
"Mike Epprecht (SQL MVP)" wrote:

> Hi
> What does the NT event log say? Any startup errors are logged there.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "chittana" <chittana@.discussions.microsoft.com> wrote in message
> news:638D188B-8D35-4667-BFE3-0225BA31CB4B@.microsoft.com...
> "1
> I've
> be
>
>

MSSQLServer services

I'm running SQL 7.0 SP4 on NT 4.0. Each time i restart server, the sql
services just showing starting status for 2 minutes & gives error message "1
or more services failed to start". I have start the services manually. I've
tried to reinstall sql server but still the same. Kindly advice wht could be
the possible causes for this problem.
ThanksHi
What does the NT event log say? Any startup errors are logged there.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"chittana" <chittana@.discussions.microsoft.com> wrote in message
news:638D188B-8D35-4667-BFE3-0225BA31CB4B@.microsoft.com...
> I'm running SQL 7.0 SP4 on NT 4.0. Each time i restart server, the sql
> services just showing starting status for 2 minutes & gives error message
"1
> or more services failed to start". I have start the services manually.
I've
> tried to reinstall sql server but still the same. Kindly advice wht could
be
> the possible causes for this problem.
> Thanks|||Nope Mike. No startup error been logged in NT event log.
"Mike Epprecht (SQL MVP)" wrote:

> Hi
> What does the NT event log say? Any startup errors are logged there.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "chittana" <chittana@.discussions.microsoft.com> wrote in message
> news:638D188B-8D35-4667-BFE3-0225BA31CB4B@.microsoft.com...
> "1
> I've
> be
>
>

MSSQL status icon

Is there a method to prohibit the server icon (the one with the computer case
and a green arrow) from appearing in the status area of the taskbar? I’m
attempting to lockdown a terminal services desktop and want to avoid a
curious user from playing point and click with the icon.
Many thanks for all of you being there to help.
SQL 2000 running on a 2003 server.
Remove it from the startup group.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:5F8F1072-2D0B-490D-9F7B-69B899ACCFF4@.microsoft.com...
> Is there a method to prohibit the server icon (the one with the computer case
> and a green arrow) from appearing in the status area of the taskbar? I'm
> attempting to lockdown a terminal services desktop and want to avoid a
> curious user from playing point and click with the icon.
> Many thanks for all of you being there to help.
>
> SQL 2000 running on a 2003 server.
>
|||Hi coenzyme,
Remove it out of the Programs\Startup menu for users.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
"coenzyme" wrote:

> Is there a method to prohibit the server icon (the one with the computer case
> and a green arrow) from appearing in the status area of the taskbar? I’m
> attempting to lockdown a terminal services desktop and want to avoid a
> curious user from playing point and click with the icon.
> Many thanks for all of you being there to help.
>
> SQL 2000 running on a 2003 server.
>

MSSQL status icon

Is there a method to prohibit the server icon (the one with the computer cas
e
and a green arrow) from appearing in the status area of the taskbar? I’m
attempting to lockdown a terminal services desktop and want to avoid a
curious user from playing point and click with the icon.
Many thanks for all of you being there to help.
SQL 2000 running on a 2003 server.Remove it from the startup group.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:5F8F1072-2D0B-490D-9F7B-69B899ACCFF4@.microsoft.com...
> Is there a method to prohibit the server icon (the one with the computer c
ase
> and a green arrow) from appearing in the status area of the taskbar? I'm
> attempting to lockdown a terminal services desktop and want to avoid a
> curious user from playing point and click with the icon.
> Many thanks for all of you being there to help.
>
> SQL 2000 running on a 2003 server.
>|||Hi coenzyme,
Remove it out of the Programs\Startup menu for users.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
"coenzyme" wrote:

> Is there a method to prohibit the server icon (the one with the computer c
ase
> and a green arrow) from appearing in the status area of the taskbar? I’m
> attempting to lockdown a terminal services desktop and want to avoid a
> curious user from playing point and click with the icon.
> Many thanks for all of you being there to help.
>
> SQL 2000 running on a 2003 server.
>

MSSQL status icon

Is there a method to prohibit the server icon (the one with the computer case
and a green arrow) from appearing in the status area of the taskbar? Iâ'm
attempting to lockdown a terminal services desktop and want to avoid a
curious user from playing point and click with the icon.
Many thanks for all of you being there to help.
SQL 2000 running on a 2003 server.Remove it from the startup group.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:5F8F1072-2D0B-490D-9F7B-69B899ACCFF4@.microsoft.com...
> Is there a method to prohibit the server icon (the one with the computer case
> and a green arrow) from appearing in the status area of the taskbar? I'm
> attempting to lockdown a terminal services desktop and want to avoid a
> curious user from playing point and click with the icon.
> Many thanks for all of you being there to help.
>
> SQL 2000 running on a 2003 server.
>|||Hi coenzyme,
Remove it out of the Programs\Startup menu for users.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
"coenzyme" wrote:
> Is there a method to prohibit the server icon (the one with the computer case
> and a green arrow) from appearing in the status area of the taskbar? Iâ'm
> attempting to lockdown a terminal services desktop and want to avoid a
> curious user from playing point and click with the icon.
> Many thanks for all of you being there to help.
>
> SQL 2000 running on a 2003 server.
>

mssql service manager don't start

after a black out mssqlservice doesn't start also if i try to start it manually
it say no errors or alert windows just return to stop status after few second
have an idea?
i don't know much about mssql this program is used only by my main
billing/accountacy program
thank you for your answer
exscuse for my bad english i am italian
Stivi,
I'm not sure that the problem have something to do with this but i think you
can try.
Sometimes happens that the account used with mssqlservice is not well
configured.
Use Services in the administrative tools to see wich account is used to
authenticate mssqlservice. This account must have administrative permissions
in the machine and the password must not expire or be changed by anyone.
after verifying this try to restart the service.
"stivi" wrote:

> after a black out mssqlservice doesn't start also if i try to start it manually
> it say no errors or alert windows just return to stop status after few second
> have an idea?
> i don't know much about mssql this program is used only by my main
> billing/accountacy program
> thank you for your answer
> exscuse for my bad english i am italian
|||Check the application and system event logs to see why the service
isn't starting. If your server didn't have a UPS then the abrupt
shutdown could've damaged files on the hard drive. As a consequence
the service encounters a damaged file and is unable to start.
Hopefully you (or your system administrator) can fix the
problem...otherwise, be prepared to uninstall/reinstall SQL Server
:-(.
On Sat, 26 Nov 2005 03:56:01 -0800, "stivi"
<stivi@.discussions.microsoft.com> wrote:

>after a black out mssqlservice doesn't start also if i try to start it manually
>it say no errors or alert windows just return to stop status after few second
>have an idea?
>i don't know much about mssql this program is used only by my main
>billing/accountacy program
>thank you for your answer
>exscuse for my bad english i am italian

mssql service manager don't start

after a black out mssqlservice doesn't start also if i try to start it manua
lly
it say no errors or alert windows just return to stop status after few secon
d
have an idea?
i don't know much about mssql this program is used only by my main
billing/accountacy program
thank you for your answer
exscuse for my bad english i am italianStivi,
I'm not sure that the problem have something to do with this but i think you
can try.
Sometimes happens that the account used with mssqlservice is not well
configured.
Use Services in the administrative tools to see wich account is used to
authenticate mssqlservice. This account must have administrative permissions
in the machine and the password must not expire or be changed by anyone.
after verifying this try to restart the service.
"stivi" wrote:

> after a black out mssqlservice doesn't start also if i try to start it man
ually
> it say no errors or alert windows just return to stop status after few sec
ond
> have an idea?
> i don't know much about mssql this program is used only by my main
> billing/accountacy program
> thank you for your answer
> exscuse for my bad english i am italian|||Check the application and system event logs to see why the service
isn't starting. If your server didn't have a UPS then the abrupt
shutdown could've damaged files on the hard drive. As a consequence
the service encounters a damaged file and is unable to start.
Hopefully you (or your system administrator) can fix the
problem...otherwise, be prepared to uninstall/reinstall SQL Server
:-(.
On Sat, 26 Nov 2005 03:56:01 -0800, "stivi"
<stivi@.discussions.microsoft.com> wrote:

>after a black out mssqlservice doesn't start also if i try to start it manu
ally
>it say no errors or alert windows just return to stop status after few seco
nd
>have an idea?
>i don't know much about mssql this program is used only by my main
>billing/accountacy program
>thank you for your answer
>exscuse for my bad english i am italian

mssql service manager don't start

after a black out mssqlservice doesn't start also if i try to start it manually
it say no errors or alert windows just return to stop status after few second
have an idea?
i don't know much about mssql this program is used only by my main
billing/accountacy program
thank you for your answer
exscuse for my bad english i am italianStivi,
I'm not sure that the problem have something to do with this but i think you
can try.
Sometimes happens that the account used with mssqlservice is not well
configured.
Use Services in the administrative tools to see wich account is used to
authenticate mssqlservice. This account must have administrative permissions
in the machine and the password must not expire or be changed by anyone.
after verifying this try to restart the service.
"stivi" wrote:
> after a black out mssqlservice doesn't start also if i try to start it manually
> it say no errors or alert windows just return to stop status after few second
> have an idea?
> i don't know much about mssql this program is used only by my main
> billing/accountacy program
> thank you for your answer
> exscuse for my bad english i am italian|||Check the application and system event logs to see why the service
isn't starting. If your server didn't have a UPS then the abrupt
shutdown could've damaged files on the hard drive. As a consequence
the service encounters a damaged file and is unable to start.
Hopefully you (or your system administrator) can fix the
problem...otherwise, be prepared to uninstall/reinstall SQL Server
:-(.
On Sat, 26 Nov 2005 03:56:01 -0800, "stivi"
<stivi@.discussions.microsoft.com> wrote:
>after a black out mssqlservice doesn't start also if i try to start it manually
>it say no errors or alert windows just return to stop status after few second
>have an idea?
>i don't know much about mssql this program is used only by my main
>billing/accountacy program
>thank you for your answer
>exscuse for my bad english i am italian

MSSQL Server Recovery

Can you give us some indication on the status of your
server i.e. is it accessable.
Can you also give us some indication of your backups and
any replication.
Peter
"It's true hard work never killed anybody, but I figure,
why take the chance?"
Ronald Reagan

>--Original Message--
>Hi,
>The Windows 2000 Server (that has MSSQL Server
installed) is corrupted.
>Can anybody tell me how I can make the existing SQL data
files work in
>another Windows 2000 Server?
>What should I do?
>Thanks & Regards,
>KS
>
>.
>
Hi,
Due to I cannot log into Windows 2000 Server (installed by
ex-administrator),
I need to install a new Windows 2000 Server.
And transfer the existing data files to the new machine.
Regards,
KS
"Peter The Spate" <anonymous@.discussions.microsoft.com> wrote in message
news:136701c48c22$49618100$a501280a@.phx.gbl...[vbcol=seagreen]
> Can you give us some indication on the status of your
> server i.e. is it accessable.
> Can you also give us some indication of your backups and
> any replication.
> Peter
> "It's true hard work never killed anybody, but I figure,
> why take the chance?"
> Ronald Reagan
>
> installed) is corrupted.
> files work in

MSSQL Server Recovery

Can you give us some indication on the status of your
server i.e. is it accessable.
Can you also give us some indication of your backups and
any replication.
Peter
"It's true hard work never killed anybody, but I figure,
why take the chance?"
Ronald Reagan

>--Original Message--
>Hi,
>The Windows 2000 Server (that has MSSQL Server
installed) is corrupted.
>Can anybody tell me how I can make the existing SQL data
files work in
>another Windows 2000 Server?
>What should I do?
>Thanks & Regards,
>KS
>
>.
>Hi,
Due to I cannot log into Windows 2000 Server (installed by
ex-administrator),
I need to install a new Windows 2000 Server.
And transfer the existing data files to the new machine.
Regards,
KS
"Peter The Spate" <anonymous@.discussions.microsoft.com> wrote in message
news:136701c48c22$49618100$a501280a@.phx.gbl...[vbcol=seagreen]
> Can you give us some indication on the status of your
> server i.e. is it accessable.
> Can you also give us some indication of your backups and
> any replication.
> Peter
> "It's true hard work never killed anybody, but I figure,
> why take the chance?"
> Ronald Reagan
>
> installed) is corrupted.
> files work in