Hi,
I am trying to start MSSQLServer then it came up with "The MSSQLSERVER
services on Local Computer started and then stopped. Some services stop
automatically if they have no work to do, for example, the Performance Logs
and Alerts services." message. The service is using local computer account
to start. Where should I start to trouble shooting this problem? I will be
appreciated your tips and information.
Thanks,
Johnny Chow
Johny,
Are you using EM, Control Panel - Services or the Sevices Applet to start
the service? Might try using the local system account as a test to ensure
the service can start then check the permissions of the local account you
are using. Are there any informational errors reported in the application
event log?
A couple of things to look at.
HTH
Jerry
"Johnny Chow" <jchow10@.gmail.com> wrote in message
news:ea%23gEb00FHA.2792@.tk2msftngp13.phx.gbl...
> Hi,
> I am trying to start MSSQLServer then it came up with "The MSSQLSERVER
> services on Local Computer started and then stopped. Some services stop
> automatically if they have no work to do, for example, the Performance
> Logs and Alerts services." message. The service is using local computer
> account to start. Where should I start to trouble shooting this problem?
> I will be appreciated your tips and information.
> Thanks,
> Johnny Chow
>
|||Hi,
I tried both of them. I check the application event log file and found out
the evaluation copy period is over. I am using KB 281574 to upgrade to the
retail. One question is how are we going to dinstinquish between eval and
retail version? I suspected we have a couple of server running evals.
Thank you in advance,
Johnny Chow
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:OhpoAf00FHA.404@.TK2MSFTNGP09.phx.gbl...
> Johny,
> Are you using EM, Control Panel - Services or the Sevices Applet to start
> the service? Might try using the local system account as a test to ensure
> the service can start then check the permissions of the local account you
> are using. Are there any informational errors reported in the application
> event log?
> A couple of things to look at.
> HTH
> Jerry
> "Johnny Chow" <jchow10@.gmail.com> wrote in message
> news:ea%23gEb00FHA.2792@.tk2msftngp13.phx.gbl...
>
|||Johnny,
Try:
SELECT SERVERPROPERTY('EDITION')
--OR
SELECT @.@.VERSION
HTH
Jerry
"Johnny Chow" <jchow10@.gmail.com> wrote in message
news:OH5MMx10FHA.3180@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I tried both of them. I check the application event log file and found
> out the evaluation copy period is over. I am using KB 281574 to upgrade
> to the retail. One question is how are we going to dinstinquish between
> eval and retail version? I suspected we have a couple of server running
> evals.
> Thank you in advance,
> Johnny Chow
>
> "Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
> news:OhpoAf00FHA.404@.TK2MSFTNGP09.phx.gbl...
>
Showing posts with label computer. Show all posts
Showing posts with label computer. Show all posts
Tuesday, March 27, 2012
Can't start MSSQLServer services.
Hi,
I am trying to start MSSQLServer then it came up with "The MSSQLSERVER
services on Local Computer started and then stopped. Some services stop
automatically if they have no work to do, for example, the Performance Logs
and Alerts services." message. The service is using local computer account
to start. Where should I start to trouble shooting this problem? I will be
appreciated your tips and information.
Thanks,
Johnny ChowJohny,
Are you using EM, Control Panel - Services or the Sevices Applet to start
the service? Might try using the local system account as a test to ensure
the service can start then check the permissions of the local account you
are using. Are there any informational errors reported in the application
event log?
A couple of things to look at.
HTH
Jerry
"Johnny Chow" <jchow10@.gmail.com> wrote in message
news:ea%23gEb00FHA.2792@.tk2msftngp13.phx.gbl...
> Hi,
> I am trying to start MSSQLServer then it came up with "The MSSQLSERVER
> services on Local Computer started and then stopped. Some services stop
> automatically if they have no work to do, for example, the Performance
> Logs and Alerts services." message. The service is using local computer
> account to start. Where should I start to trouble shooting this problem?
> I will be appreciated your tips and information.
> Thanks,
> Johnny Chow
>|||Hi,
I tried both of them. I check the application event log file and found out
the evaluation copy period is over. I am using KB 281574 to upgrade to the
retail. One question is how are we going to dinstinquish between eval and
retail version? I suspected we have a couple of server running evals.
Thank you in advance,
Johnny Chow
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:OhpoAf00FHA.404@.TK2MSFTNGP09.phx.gbl...
> Johny,
> Are you using EM, Control Panel - Services or the Sevices Applet to start
> the service? Might try using the local system account as a test to ensure
> the service can start then check the permissions of the local account you
> are using. Are there any informational errors reported in the application
> event log?
> A couple of things to look at.
> HTH
> Jerry
> "Johnny Chow" <jchow10@.gmail.com> wrote in message
> news:ea%23gEb00FHA.2792@.tk2msftngp13.phx.gbl...
>|||Johnny,
Try:
SELECT SERVERPROPERTY('EDITION')
--OR
SELECT @.@.VERSION
HTH
Jerry
"Johnny Chow" <jchow10@.gmail.com> wrote in message
news:OH5MMx10FHA.3180@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I tried both of them. I check the application event log file and found
> out the evaluation copy period is over. I am using KB 281574 to upgrade
> to the retail. One question is how are we going to dinstinquish between
> eval and retail version? I suspected we have a couple of server running
> evals.
> Thank you in advance,
> Johnny Chow
>
> "Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
> news:OhpoAf00FHA.404@.TK2MSFTNGP09.phx.gbl...
>
I am trying to start MSSQLServer then it came up with "The MSSQLSERVER
services on Local Computer started and then stopped. Some services stop
automatically if they have no work to do, for example, the Performance Logs
and Alerts services." message. The service is using local computer account
to start. Where should I start to trouble shooting this problem? I will be
appreciated your tips and information.
Thanks,
Johnny ChowJohny,
Are you using EM, Control Panel - Services or the Sevices Applet to start
the service? Might try using the local system account as a test to ensure
the service can start then check the permissions of the local account you
are using. Are there any informational errors reported in the application
event log?
A couple of things to look at.
HTH
Jerry
"Johnny Chow" <jchow10@.gmail.com> wrote in message
news:ea%23gEb00FHA.2792@.tk2msftngp13.phx.gbl...
> Hi,
> I am trying to start MSSQLServer then it came up with "The MSSQLSERVER
> services on Local Computer started and then stopped. Some services stop
> automatically if they have no work to do, for example, the Performance
> Logs and Alerts services." message. The service is using local computer
> account to start. Where should I start to trouble shooting this problem?
> I will be appreciated your tips and information.
> Thanks,
> Johnny Chow
>|||Hi,
I tried both of them. I check the application event log file and found out
the evaluation copy period is over. I am using KB 281574 to upgrade to the
retail. One question is how are we going to dinstinquish between eval and
retail version? I suspected we have a couple of server running evals.
Thank you in advance,
Johnny Chow
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:OhpoAf00FHA.404@.TK2MSFTNGP09.phx.gbl...
> Johny,
> Are you using EM, Control Panel - Services or the Sevices Applet to start
> the service? Might try using the local system account as a test to ensure
> the service can start then check the permissions of the local account you
> are using. Are there any informational errors reported in the application
> event log?
> A couple of things to look at.
> HTH
> Jerry
> "Johnny Chow" <jchow10@.gmail.com> wrote in message
> news:ea%23gEb00FHA.2792@.tk2msftngp13.phx.gbl...
>|||Johnny,
Try:
SELECT SERVERPROPERTY('EDITION')
--OR
SELECT @.@.VERSION
HTH
Jerry
"Johnny Chow" <jchow10@.gmail.com> wrote in message
news:OH5MMx10FHA.3180@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I tried both of them. I check the application event log file and found
> out the evaluation copy period is over. I am using KB 281574 to upgrade
> to the retail. One question is how are we going to dinstinquish between
> eval and retail version? I suspected we have a couple of server running
> evals.
> Thank you in advance,
> Johnny Chow
>
> "Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
> news:OhpoAf00FHA.404@.TK2MSFTNGP09.phx.gbl...
>
Sunday, March 25, 2012
Can't start MSSQLServer services.
Hi,
I am trying to start MSSQLServer then it came up with "The MSSQLSERVER
services on Local Computer started and then stopped. Some services stop
automatically if they have no work to do, for example, the Performance Logs
and Alerts services." message. The service is using local computer account
to start. Where should I start to trouble shooting this problem? I will be
appreciated your tips and information.
Thanks,
Johnny ChowJohny,
Are you using EM, Control Panel - Services or the Sevices Applet to start
the service? Might try using the local system account as a test to ensure
the service can start then check the permissions of the local account you
are using. Are there any informational errors reported in the application
event log?
A couple of things to look at.
HTH
Jerry
"Johnny Chow" <jchow10@.gmail.com> wrote in message
news:ea%23gEb00FHA.2792@.tk2msftngp13.phx.gbl...
> Hi,
> I am trying to start MSSQLServer then it came up with "The MSSQLSERVER
> services on Local Computer started and then stopped. Some services stop
> automatically if they have no work to do, for example, the Performance
> Logs and Alerts services." message. The service is using local computer
> account to start. Where should I start to trouble shooting this problem?
> I will be appreciated your tips and information.
> Thanks,
> Johnny Chow
>|||Hi,
I tried both of them. I check the application event log file and found out
the evaluation copy period is over. I am using KB 281574 to upgrade to the
retail. One question is how are we going to dinstinquish between eval and
retail version? I suspected we have a couple of server running evals.
Thank you in advance,
Johnny Chow
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:OhpoAf00FHA.404@.TK2MSFTNGP09.phx.gbl...
> Johny,
> Are you using EM, Control Panel - Services or the Sevices Applet to start
> the service? Might try using the local system account as a test to ensure
> the service can start then check the permissions of the local account you
> are using. Are there any informational errors reported in the application
> event log?
> A couple of things to look at.
> HTH
> Jerry
> "Johnny Chow" <jchow10@.gmail.com> wrote in message
> news:ea%23gEb00FHA.2792@.tk2msftngp13.phx.gbl...
>> Hi,
>> I am trying to start MSSQLServer then it came up with "The MSSQLSERVER
>> services on Local Computer started and then stopped. Some services stop
>> automatically if they have no work to do, for example, the Performance
>> Logs and Alerts services." message. The service is using local computer
>> account to start. Where should I start to trouble shooting this problem?
>> I will be appreciated your tips and information.
>> Thanks,
>> Johnny Chow
>|||Johnny,
Try:
SELECT SERVERPROPERTY('EDITION')
--OR
SELECT @.@.VERSION
HTH
Jerry
"Johnny Chow" <jchow10@.gmail.com> wrote in message
news:OH5MMx10FHA.3180@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I tried both of them. I check the application event log file and found
> out the evaluation copy period is over. I am using KB 281574 to upgrade
> to the retail. One question is how are we going to dinstinquish between
> eval and retail version? I suspected we have a couple of server running
> evals.
> Thank you in advance,
> Johnny Chow
>
> "Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
> news:OhpoAf00FHA.404@.TK2MSFTNGP09.phx.gbl...
>> Johny,
>> Are you using EM, Control Panel - Services or the Sevices Applet to start
>> the service? Might try using the local system account as a test to
>> ensure the service can start then check the permissions of the local
>> account you are using. Are there any informational errors reported in
>> the application event log?
>> A couple of things to look at.
>> HTH
>> Jerry
>> "Johnny Chow" <jchow10@.gmail.com> wrote in message
>> news:ea%23gEb00FHA.2792@.tk2msftngp13.phx.gbl...
>> Hi,
>> I am trying to start MSSQLServer then it came up with "The MSSQLSERVER
>> services on Local Computer started and then stopped. Some services stop
>> automatically if they have no work to do, for example, the Performance
>> Logs and Alerts services." message. The service is using local computer
>> account to start. Where should I start to trouble shooting this
>> problem? I will be appreciated your tips and information.
>> Thanks,
>> Johnny Chow
>>
>sql
I am trying to start MSSQLServer then it came up with "The MSSQLSERVER
services on Local Computer started and then stopped. Some services stop
automatically if they have no work to do, for example, the Performance Logs
and Alerts services." message. The service is using local computer account
to start. Where should I start to trouble shooting this problem? I will be
appreciated your tips and information.
Thanks,
Johnny ChowJohny,
Are you using EM, Control Panel - Services or the Sevices Applet to start
the service? Might try using the local system account as a test to ensure
the service can start then check the permissions of the local account you
are using. Are there any informational errors reported in the application
event log?
A couple of things to look at.
HTH
Jerry
"Johnny Chow" <jchow10@.gmail.com> wrote in message
news:ea%23gEb00FHA.2792@.tk2msftngp13.phx.gbl...
> Hi,
> I am trying to start MSSQLServer then it came up with "The MSSQLSERVER
> services on Local Computer started and then stopped. Some services stop
> automatically if they have no work to do, for example, the Performance
> Logs and Alerts services." message. The service is using local computer
> account to start. Where should I start to trouble shooting this problem?
> I will be appreciated your tips and information.
> Thanks,
> Johnny Chow
>|||Hi,
I tried both of them. I check the application event log file and found out
the evaluation copy period is over. I am using KB 281574 to upgrade to the
retail. One question is how are we going to dinstinquish between eval and
retail version? I suspected we have a couple of server running evals.
Thank you in advance,
Johnny Chow
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:OhpoAf00FHA.404@.TK2MSFTNGP09.phx.gbl...
> Johny,
> Are you using EM, Control Panel - Services or the Sevices Applet to start
> the service? Might try using the local system account as a test to ensure
> the service can start then check the permissions of the local account you
> are using. Are there any informational errors reported in the application
> event log?
> A couple of things to look at.
> HTH
> Jerry
> "Johnny Chow" <jchow10@.gmail.com> wrote in message
> news:ea%23gEb00FHA.2792@.tk2msftngp13.phx.gbl...
>> Hi,
>> I am trying to start MSSQLServer then it came up with "The MSSQLSERVER
>> services on Local Computer started and then stopped. Some services stop
>> automatically if they have no work to do, for example, the Performance
>> Logs and Alerts services." message. The service is using local computer
>> account to start. Where should I start to trouble shooting this problem?
>> I will be appreciated your tips and information.
>> Thanks,
>> Johnny Chow
>|||Johnny,
Try:
SELECT SERVERPROPERTY('EDITION')
--OR
SELECT @.@.VERSION
HTH
Jerry
"Johnny Chow" <jchow10@.gmail.com> wrote in message
news:OH5MMx10FHA.3180@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I tried both of them. I check the application event log file and found
> out the evaluation copy period is over. I am using KB 281574 to upgrade
> to the retail. One question is how are we going to dinstinquish between
> eval and retail version? I suspected we have a couple of server running
> evals.
> Thank you in advance,
> Johnny Chow
>
> "Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
> news:OhpoAf00FHA.404@.TK2MSFTNGP09.phx.gbl...
>> Johny,
>> Are you using EM, Control Panel - Services or the Sevices Applet to start
>> the service? Might try using the local system account as a test to
>> ensure the service can start then check the permissions of the local
>> account you are using. Are there any informational errors reported in
>> the application event log?
>> A couple of things to look at.
>> HTH
>> Jerry
>> "Johnny Chow" <jchow10@.gmail.com> wrote in message
>> news:ea%23gEb00FHA.2792@.tk2msftngp13.phx.gbl...
>> Hi,
>> I am trying to start MSSQLServer then it came up with "The MSSQLSERVER
>> services on Local Computer started and then stopped. Some services stop
>> automatically if they have no work to do, for example, the Performance
>> Logs and Alerts services." message. The service is using local computer
>> account to start. Where should I start to trouble shooting this
>> problem? I will be appreciated your tips and information.
>> Thanks,
>> Johnny Chow
>>
>sql
Saturday, February 25, 2012
cant open databases folder
Hello, I just installed SQL Server 2000 on my home computer and am
connecting to a remote SQL server over the Internet. I can log into
the server just fine and see 7 folders including the 'Databases'
folder. I can open up all of the other 6 folders but for some crazy
reason when I double click on the 'Databases' folder, I can't open it!
The hourglass appears and Enterprise Manager basically locks up. Does
anyone know what's going on???
Please email response to nkulshresh@.hotmail.com as well as posting to
group.
connecting to a remote SQL server over the Internet. I can log into
the server just fine and see 7 folders including the 'Databases'
folder. I can open up all of the other 6 folders but for some crazy
reason when I double click on the 'Databases' folder, I can't open it!
The hourglass appears and Enterprise Manager basically locks up. Does
anyone know what's going on???
Please email response to nkulshresh@.hotmail.com as well as posting to
group.
Thanks,
Navin[posted and mailed, please reply in news]
Navin Kulshreshtha (amador612@.hotmail.com) writes:
> Hello, I just installed SQL Server 2000 on my home computer and am
> connecting to a remote SQL server over the Internet. I can log into
> the server just fine and see 7 folders including the 'Databases'
> folder. I can open up all of the other 6 folders but for some crazy
> reason when I double click on the 'Databases' folder, I can't open it!
> The hourglass appears and Enterprise Manager basically locks up. Does
> anyone know what's going on???
It could be that autoclose is turned for one or more databasees. Connect
with Query Analyzer, and run an sp_help and check the options columns.
Also check that you have not enabled ODBC tracing on your machine.
> Please email response to nkulshresh@.hotmail.com as well as posting to
> group.
If you want replies to a certain address, please put it in the Reply-To
field of your posting.
--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp
Tuesday, February 14, 2012
Can't install SQL 200 Enterprise Edition!!!!
Hi ,
I can't install SQL Server 2000 Enterprise Edtion on my computer.
The error message shows that 'Operating System doesn't not support for this version.....'
What's the cause of this error?
My computer is already connected to LAN.
Can anybody help?
Any help is appreciated..
Thanks.
Julia168
Julia168 wrote:
The error message shows that 'Operating System doesn't not support for this version.....'
What's the cause of this error?
The partial error message spells it out clearly - you're trying to install Enterprise Edition on a non-supported OS. See Books Online to find out which OS's support Enterprise Edition.
Can I guess you have XP?
|||yes..I've Windows XP with Service Pack 2.
But I've installed Enterprise Edition with XP once before.
Thanks.
Julia
|||Enterprise Edition is not supported on Windows XP. See Books Online topic "Hardware and Software Requirements for Installing SQL Server 2000".
Maybe you installed the Enterprise Evaluation edition on Windows XP, which is supported.
|||I see.
Thanks for your answer.
Regards,
Julia
Can't install MSDE on Windows XP
Hello,
I can't install MSDE on a computer running Windows XP. The installation stop
and, in the error log, I have the following error message
Executing "C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\cnfgsvr.exe -V 1 -M 1 -U sa -I "MILORD" -Q
"French_CI_AS""
MSI (s) (00!E4) [16:24:27:625]: Product : Microsoft SQL Server Desktop
Engine (MILORD) -- The installation program can't configure the server. Look
at the server error and installation logs for more informations
MSI (c) (5C:B4) [16:24:17:890]: Font created. Charset: Req=0, Ret=0, Font:
Req=MS Shell Dlg, Ret=MS Shell Dlg
The installation program can't configure the server. Look at the server
error and installation logs for more informations
MSI (s) (00:08) [16:24:27:703]: User policy value 'DisableRollback' is 0
MSI (s) (00:08) [16:24:27:703]: Machine policy value 'DisableRollback' is 0
End of action 16:24:27 : InstallFinalize. Return value : 3
This is the first time I see this kind of error and I have found nothing
about it. I hope someone knows about it :-)
P.S. : sorry for me bad english, I'm not really good with foreign language
^^
hi David,
David G. wrote:
> Hello,
> I can't install MSDE on a computer running Windows XP. The
> installation stop and, in the error log, I have the following error
> message
> Executing "C:\Program Files\Microsoft SQL
> Server\80\Tools\Binn\cnfgsvr.exe -V 1 -M 1 -U sa -I "MILORD" -Q
> "French_CI_AS""
> MSI (s) (00!E4) [16:24:27:625]: Product : Microsoft SQL Server Desktop
> Engine (MILORD) -- The installation program can't configure the
> server. Look at the server error and installation logs for more
> informations MSI (c) (5C:B4) [16:24:17:890]: Font created. Charset:
> Req=0, Ret=0,
> Font: Req=MS Shell Dlg, Ret=MS Shell Dlg
> The installation program can't configure the server. Look at the
> server error and installation logs for more informations
please have a look at
http://support.microsoft.com/default...99&Product=sql
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks, I will give it a look asap.
Andrea Montanari wrote:
> please have a look at
> http://support.microsoft.com/default...99&Product=sql
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
I can't install MSDE on a computer running Windows XP. The installation stop
and, in the error log, I have the following error message
Executing "C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\cnfgsvr.exe -V 1 -M 1 -U sa -I "MILORD" -Q
"French_CI_AS""
MSI (s) (00!E4) [16:24:27:625]: Product : Microsoft SQL Server Desktop
Engine (MILORD) -- The installation program can't configure the server. Look
at the server error and installation logs for more informations
MSI (c) (5C:B4) [16:24:17:890]: Font created. Charset: Req=0, Ret=0, Font:
Req=MS Shell Dlg, Ret=MS Shell Dlg
The installation program can't configure the server. Look at the server
error and installation logs for more informations
MSI (s) (00:08) [16:24:27:703]: User policy value 'DisableRollback' is 0
MSI (s) (00:08) [16:24:27:703]: Machine policy value 'DisableRollback' is 0
End of action 16:24:27 : InstallFinalize. Return value : 3
This is the first time I see this kind of error and I have found nothing
about it. I hope someone knows about it :-)
P.S. : sorry for me bad english, I'm not really good with foreign language
^^
hi David,
David G. wrote:
> Hello,
> I can't install MSDE on a computer running Windows XP. The
> installation stop and, in the error log, I have the following error
> message
> Executing "C:\Program Files\Microsoft SQL
> Server\80\Tools\Binn\cnfgsvr.exe -V 1 -M 1 -U sa -I "MILORD" -Q
> "French_CI_AS""
> MSI (s) (00!E4) [16:24:27:625]: Product : Microsoft SQL Server Desktop
> Engine (MILORD) -- The installation program can't configure the
> server. Look at the server error and installation logs for more
> informations MSI (c) (5C:B4) [16:24:17:890]: Font created. Charset:
> Req=0, Ret=0,
> Font: Req=MS Shell Dlg, Ret=MS Shell Dlg
> The installation program can't configure the server. Look at the
> server error and installation logs for more informations
please have a look at
http://support.microsoft.com/default...99&Product=sql
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks, I will give it a look asap.
Andrea Montanari wrote:
> please have a look at
> http://support.microsoft.com/default...99&Product=sql
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
Friday, February 10, 2012
Can't get SP3a installed
I'm trying to get SP3a installed on my computer, and it simply will not
update. Here's what SELECT @.@.VERSION returns:
Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation Developer Edition on Windows
NT 5.1 (Build 2600: Service Pack 2)
According to the MS web site, this is the original installation version. I
downloaded all 3 of the files at the end of the "Microsoft SQL Server 2000
Service Pack 3a" page, and followed the instructions and installed
sql2ksp3.exe first, then installed sql2kasp3.exe. I stopped the services,
and restarted the services, and SELECT @.@.VERSION still returns the same
exact thing as what is listed above. What did I do wrong here?
Thanks,
JesseHi
After running sql2ksp3.exe (it extracts to a directory), did you run the
setup.bat to install the SP?
Did the setup.bat run with errors?
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Jesse" wrote:
> I'm trying to get SP3a installed on my computer, and it simply will not
> update. Here's what SELECT @.@.VERSION returns:
> Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48
> Copyright (c) 1988-2000 Microsoft Corporation Developer Edition on Windows
> NT 5.1 (Build 2600: Service Pack 2)
> According to the MS web site, this is the original installation version. I
> downloaded all 3 of the files at the end of the "Microsoft SQL Server 2000
> Service Pack 3a" page, and followed the instructions and installed
> sql2ksp3.exe first, then installed sql2kasp3.exe. I stopped the services,
> and restarted the services, and SELECT @.@.VERSION still returns the same
> exact thing as what is listed above. What did I do wrong here?
> Thanks,
> Jesse
>
>|||No, I guess I missed the part about the setup.bat. I'm running that now.
Thanks,
Jesse
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:9ACC7775-75DD-409D-960B-1AA7507F63B5@.microsoft.com...
> Hi
> After running sql2ksp3.exe (it extracts to a directory), did you run the
> setup.bat to install the SP?
> Did the setup.bat run with errors?
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "Jesse" wrote:
>> I'm trying to get SP3a installed on my computer, and it simply will not
>> update. Here's what SELECT @.@.VERSION returns:
>> Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48
>> Copyright (c) 1988-2000 Microsoft Corporation Developer Edition on
>> Windows
>> NT 5.1 (Build 2600: Service Pack 2)
>> According to the MS web site, this is the original installation version.
>> I
>> downloaded all 3 of the files at the end of the "Microsoft SQL Server
>> 2000
>> Service Pack 3a" page, and followed the instructions and installed
>> sql2ksp3.exe first, then installed sql2kasp3.exe. I stopped the
>> services,
>> and restarted the services, and SELECT @.@.VERSION still returns the same
>> exact thing as what is listed above. What did I do wrong here?
>> Thanks,
>> Jesse
>>|||As you found out, the running of the EXE only extracts the files to actually
run.
Have fun.
--
--
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/
"Jesse" <nospam@.fake.com> wrote in message
news:%231LnLWcbFHA.3464@.tk2msftngp13.phx.gbl...
> No, I guess I missed the part about the setup.bat. I'm running that now.
> Thanks,
> Jesse
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:9ACC7775-75DD-409D-960B-1AA7507F63B5@.microsoft.com...
>> Hi
>> After running sql2ksp3.exe (it extracts to a directory), did you run the
>> setup.bat to install the SP?
>> Did the setup.bat run with errors?
>> Regards
>> --
>> Mike Epprecht, Microsoft SQL Server MVP
>> Zurich, Switzerland
>> MVP Program: http://www.microsoft.com/mvp
>> Blog: http://www.msmvps.com/epprecht/
>>
>> "Jesse" wrote:
>> I'm trying to get SP3a installed on my computer, and it simply will not
>> update. Here's what SELECT @.@.VERSION returns:
>> Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48
>> Copyright (c) 1988-2000 Microsoft Corporation Developer Edition on
>> Windows
>> NT 5.1 (Build 2600: Service Pack 2)
>> According to the MS web site, this is the original installation version.
>> I
>> downloaded all 3 of the files at the end of the "Microsoft SQL Server
>> 2000
>> Service Pack 3a" page, and followed the instructions and installed
>> sql2ksp3.exe first, then installed sql2kasp3.exe. I stopped the
>> services,
>> and restarted the services, and SELECT @.@.VERSION still returns the same
>> exact thing as what is listed above. What did I do wrong here?
>> Thanks,
>> Jesse
>>
>
update. Here's what SELECT @.@.VERSION returns:
Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation Developer Edition on Windows
NT 5.1 (Build 2600: Service Pack 2)
According to the MS web site, this is the original installation version. I
downloaded all 3 of the files at the end of the "Microsoft SQL Server 2000
Service Pack 3a" page, and followed the instructions and installed
sql2ksp3.exe first, then installed sql2kasp3.exe. I stopped the services,
and restarted the services, and SELECT @.@.VERSION still returns the same
exact thing as what is listed above. What did I do wrong here?
Thanks,
JesseHi
After running sql2ksp3.exe (it extracts to a directory), did you run the
setup.bat to install the SP?
Did the setup.bat run with errors?
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Jesse" wrote:
> I'm trying to get SP3a installed on my computer, and it simply will not
> update. Here's what SELECT @.@.VERSION returns:
> Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48
> Copyright (c) 1988-2000 Microsoft Corporation Developer Edition on Windows
> NT 5.1 (Build 2600: Service Pack 2)
> According to the MS web site, this is the original installation version. I
> downloaded all 3 of the files at the end of the "Microsoft SQL Server 2000
> Service Pack 3a" page, and followed the instructions and installed
> sql2ksp3.exe first, then installed sql2kasp3.exe. I stopped the services,
> and restarted the services, and SELECT @.@.VERSION still returns the same
> exact thing as what is listed above. What did I do wrong here?
> Thanks,
> Jesse
>
>|||No, I guess I missed the part about the setup.bat. I'm running that now.
Thanks,
Jesse
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:9ACC7775-75DD-409D-960B-1AA7507F63B5@.microsoft.com...
> Hi
> After running sql2ksp3.exe (it extracts to a directory), did you run the
> setup.bat to install the SP?
> Did the setup.bat run with errors?
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "Jesse" wrote:
>> I'm trying to get SP3a installed on my computer, and it simply will not
>> update. Here's what SELECT @.@.VERSION returns:
>> Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48
>> Copyright (c) 1988-2000 Microsoft Corporation Developer Edition on
>> Windows
>> NT 5.1 (Build 2600: Service Pack 2)
>> According to the MS web site, this is the original installation version.
>> I
>> downloaded all 3 of the files at the end of the "Microsoft SQL Server
>> 2000
>> Service Pack 3a" page, and followed the instructions and installed
>> sql2ksp3.exe first, then installed sql2kasp3.exe. I stopped the
>> services,
>> and restarted the services, and SELECT @.@.VERSION still returns the same
>> exact thing as what is listed above. What did I do wrong here?
>> Thanks,
>> Jesse
>>|||As you found out, the running of the EXE only extracts the files to actually
run.
Have fun.
--
--
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/
"Jesse" <nospam@.fake.com> wrote in message
news:%231LnLWcbFHA.3464@.tk2msftngp13.phx.gbl...
> No, I guess I missed the part about the setup.bat. I'm running that now.
> Thanks,
> Jesse
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:9ACC7775-75DD-409D-960B-1AA7507F63B5@.microsoft.com...
>> Hi
>> After running sql2ksp3.exe (it extracts to a directory), did you run the
>> setup.bat to install the SP?
>> Did the setup.bat run with errors?
>> Regards
>> --
>> Mike Epprecht, Microsoft SQL Server MVP
>> Zurich, Switzerland
>> MVP Program: http://www.microsoft.com/mvp
>> Blog: http://www.msmvps.com/epprecht/
>>
>> "Jesse" wrote:
>> I'm trying to get SP3a installed on my computer, and it simply will not
>> update. Here's what SELECT @.@.VERSION returns:
>> Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48
>> Copyright (c) 1988-2000 Microsoft Corporation Developer Edition on
>> Windows
>> NT 5.1 (Build 2600: Service Pack 2)
>> According to the MS web site, this is the original installation version.
>> I
>> downloaded all 3 of the files at the end of the "Microsoft SQL Server
>> 2000
>> Service Pack 3a" page, and followed the instructions and installed
>> sql2ksp3.exe first, then installed sql2kasp3.exe. I stopped the
>> services,
>> and restarted the services, and SELECT @.@.VERSION still returns the same
>> exact thing as what is listed above. What did I do wrong here?
>> Thanks,
>> Jesse
>>
>
Can't get SP3a installed
I'm trying to get SP3a installed on my computer, and it simply will not
update. Here's what SELECT @.@.VERSION returns:
Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation Developer Edition on Windows
NT 5.1 (Build 2600: Service Pack 2)
According to the MS web site, this is the original installation version. I
downloaded all 3 of the files at the end of the "Microsoft SQL Server 2000
Service Pack 3a" page, and followed the instructions and installed
sql2ksp3.exe first, then installed sql2kasp3.exe. I stopped the services,
and restarted the services, and SELECT @.@.VERSION still returns the same
exact thing as what is listed above. What did I do wrong here?
Thanks,
Jesse
Hi
After running sql2ksp3.exe (it extracts to a directory), did you run the
setup.bat to install the SP?
Did the setup.bat run with errors?
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Jesse" wrote:
> I'm trying to get SP3a installed on my computer, and it simply will not
> update. Here's what SELECT @.@.VERSION returns:
> Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48
> Copyright (c) 1988-2000 Microsoft Corporation Developer Edition on Windows
> NT 5.1 (Build 2600: Service Pack 2)
> According to the MS web site, this is the original installation version. I
> downloaded all 3 of the files at the end of the "Microsoft SQL Server 2000
> Service Pack 3a" page, and followed the instructions and installed
> sql2ksp3.exe first, then installed sql2kasp3.exe. I stopped the services,
> and restarted the services, and SELECT @.@.VERSION still returns the same
> exact thing as what is listed above. What did I do wrong here?
> Thanks,
> Jesse
>
>
|||No, I guess I missed the part about the setup.bat. I'm running that now.
Thanks,
Jesse
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:9ACC7775-75DD-409D-960B-1AA7507F63B5@.microsoft.com...[vbcol=seagreen]
> Hi
> After running sql2ksp3.exe (it extracts to a directory), did you run the
> setup.bat to install the SP?
> Did the setup.bat run with errors?
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "Jesse" wrote:
|||As you found out, the running of the EXE only extracts the files to actually
run.
Have fun.
--
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/
"Jesse" <nospam@.fake.com> wrote in message
news:%231LnLWcbFHA.3464@.tk2msftngp13.phx.gbl...
> No, I guess I missed the part about the setup.bat. I'm running that now.
> Thanks,
> Jesse
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:9ACC7775-75DD-409D-960B-1AA7507F63B5@.microsoft.com...
>
update. Here's what SELECT @.@.VERSION returns:
Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation Developer Edition on Windows
NT 5.1 (Build 2600: Service Pack 2)
According to the MS web site, this is the original installation version. I
downloaded all 3 of the files at the end of the "Microsoft SQL Server 2000
Service Pack 3a" page, and followed the instructions and installed
sql2ksp3.exe first, then installed sql2kasp3.exe. I stopped the services,
and restarted the services, and SELECT @.@.VERSION still returns the same
exact thing as what is listed above. What did I do wrong here?
Thanks,
Jesse
Hi
After running sql2ksp3.exe (it extracts to a directory), did you run the
setup.bat to install the SP?
Did the setup.bat run with errors?
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Jesse" wrote:
> I'm trying to get SP3a installed on my computer, and it simply will not
> update. Here's what SELECT @.@.VERSION returns:
> Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48
> Copyright (c) 1988-2000 Microsoft Corporation Developer Edition on Windows
> NT 5.1 (Build 2600: Service Pack 2)
> According to the MS web site, this is the original installation version. I
> downloaded all 3 of the files at the end of the "Microsoft SQL Server 2000
> Service Pack 3a" page, and followed the instructions and installed
> sql2ksp3.exe first, then installed sql2kasp3.exe. I stopped the services,
> and restarted the services, and SELECT @.@.VERSION still returns the same
> exact thing as what is listed above. What did I do wrong here?
> Thanks,
> Jesse
>
>
|||No, I guess I missed the part about the setup.bat. I'm running that now.
Thanks,
Jesse
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:9ACC7775-75DD-409D-960B-1AA7507F63B5@.microsoft.com...[vbcol=seagreen]
> Hi
> After running sql2ksp3.exe (it extracts to a directory), did you run the
> setup.bat to install the SP?
> Did the setup.bat run with errors?
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "Jesse" wrote:
|||As you found out, the running of the EXE only extracts the files to actually
run.
Have fun.
--
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/
"Jesse" <nospam@.fake.com> wrote in message
news:%231LnLWcbFHA.3464@.tk2msftngp13.phx.gbl...
> No, I guess I missed the part about the setup.bat. I'm running that now.
> Thanks,
> Jesse
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:9ACC7775-75DD-409D-960B-1AA7507F63B5@.microsoft.com...
>
Can't get SP3a installed
I'm trying to get SP3a installed on my computer, and it simply will not
update. Here's what SELECT @.@.VERSION returns:
Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation Developer Edition on Windows
NT 5.1 (Build 2600: Service Pack 2)
According to the MS web site, this is the original installation version. I
downloaded all 3 of the files at the end of the "Microsoft SQL Server 2000
Service Pack 3a" page, and followed the instructions and installed
sql2ksp3.exe first, then installed sql2kasp3.exe. I stopped the services,
and restarted the services, and SELECT @.@.VERSION still returns the same
exact thing as what is listed above. What did I do wrong here?
Thanks,
JesseHi
After running sql2ksp3.exe (it extracts to a directory), did you run the
setup.bat to install the SP?
Did the setup.bat run with errors?
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Jesse" wrote:
> I'm trying to get SP3a installed on my computer, and it simply will not
> update. Here's what SELECT @.@.VERSION returns:
> Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48
> Copyright (c) 1988-2000 Microsoft Corporation Developer Edition on Window
s
> NT 5.1 (Build 2600: Service Pack 2)
> According to the MS web site, this is the original installation version.
I
> downloaded all 3 of the files at the end of the "Microsoft SQL Server 2000
> Service Pack 3a" page, and followed the instructions and installed
> sql2ksp3.exe first, then installed sql2kasp3.exe. I stopped the services,
> and restarted the services, and SELECT @.@.VERSION still returns the same
> exact thing as what is listed above. What did I do wrong here?
> Thanks,
> Jesse
>
>|||No, I guess I missed the part about the setup.bat. I'm running that now.
Thanks,
Jesse
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:9ACC7775-75DD-409D-960B-1AA7507F63B5@.microsoft.com...[vbcol=seagreen]
> Hi
> After running sql2ksp3.exe (it extracts to a directory), did you run the
> setup.bat to install the SP?
> Did the setup.bat run with errors?
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "Jesse" wrote:
>|||As you found out, the running of the EXE only extracts the files to actually
run.
Have fun.
--
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/
"Jesse" <nospam@.fake.com> wrote in message
news:%231LnLWcbFHA.3464@.tk2msftngp13.phx.gbl...
> No, I guess I missed the part about the setup.bat. I'm running that now.
> Thanks,
> Jesse
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:9ACC7775-75DD-409D-960B-1AA7507F63B5@.microsoft.com...
>
update. Here's what SELECT @.@.VERSION returns:
Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation Developer Edition on Windows
NT 5.1 (Build 2600: Service Pack 2)
According to the MS web site, this is the original installation version. I
downloaded all 3 of the files at the end of the "Microsoft SQL Server 2000
Service Pack 3a" page, and followed the instructions and installed
sql2ksp3.exe first, then installed sql2kasp3.exe. I stopped the services,
and restarted the services, and SELECT @.@.VERSION still returns the same
exact thing as what is listed above. What did I do wrong here?
Thanks,
JesseHi
After running sql2ksp3.exe (it extracts to a directory), did you run the
setup.bat to install the SP?
Did the setup.bat run with errors?
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Jesse" wrote:
> I'm trying to get SP3a installed on my computer, and it simply will not
> update. Here's what SELECT @.@.VERSION returns:
> Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48
> Copyright (c) 1988-2000 Microsoft Corporation Developer Edition on Window
s
> NT 5.1 (Build 2600: Service Pack 2)
> According to the MS web site, this is the original installation version.
I
> downloaded all 3 of the files at the end of the "Microsoft SQL Server 2000
> Service Pack 3a" page, and followed the instructions and installed
> sql2ksp3.exe first, then installed sql2kasp3.exe. I stopped the services,
> and restarted the services, and SELECT @.@.VERSION still returns the same
> exact thing as what is listed above. What did I do wrong here?
> Thanks,
> Jesse
>
>|||No, I guess I missed the part about the setup.bat. I'm running that now.
Thanks,
Jesse
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:9ACC7775-75DD-409D-960B-1AA7507F63B5@.microsoft.com...[vbcol=seagreen]
> Hi
> After running sql2ksp3.exe (it extracts to a directory), did you run the
> setup.bat to install the SP?
> Did the setup.bat run with errors?
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "Jesse" wrote:
>|||As you found out, the running of the EXE only extracts the files to actually
run.
Have fun.
--
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/
"Jesse" <nospam@.fake.com> wrote in message
news:%231LnLWcbFHA.3464@.tk2msftngp13.phx.gbl...
> No, I guess I missed the part about the setup.bat. I'm running that now.
> Thanks,
> Jesse
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:9ACC7775-75DD-409D-960B-1AA7507F63B5@.microsoft.com...
>
Subscribe to:
Posts (Atom)