Showing posts with label version. Show all posts
Showing posts with label version. Show all posts

Tuesday, March 27, 2012

Can't start SSIS

Hello,

Our enterprise have bought a sql server 2005 standard edition.
Before installing it i have installed the beta version.
And after I desinstalled this beta version (with difficulties).
But the problem is that I can't start SSIS.

I have the following message:
"The request failed or the service did not respond in a timely fashion.
Consult event log or other applicable error logs for details.
"

Please can you help me.
Thanks.

You should really format the machine and reinstall the OS, especially if you had an early beta. The fact that you had problems cleaning it up would be a clear indication to me that you should do that more than ever.

Are there any errors in the event log, as the message directs?

Have you applied SP1? There is an issue with starting the service with that.

|||If you have installed SP1, please review this KB article
http://support.microsoft.com/kb/918644|||

Thanks!!!
In fact I haven't installed the SP1 because the SP1 I have seen is only for express edition (I have the standard edition)!!
For the event log I haven't seen it yet!! I'll try to do it Monday.

PS:
One thing I remembered during the installation is that all the system requirements were not OK.I didn't have errors but there were 2 warnings(i don't remember them)!! .

May be it will be that!!Or it will be because I haven't installed SP1 (if you know where I can download it please indicate me ).

Thanks for comments!!!

|||

taze wrote:

if you know where I can download it please indicate me

The SP1 can be downloaded http://www.microsoft.com/sql/sp1.mspx, but I don't think it will fix this particular issue.

I join Darren's advice to reinstall the OS if earlier it had any beta builds.

|||Thank U very much for your advice!!!
I will try reinstall SQL Server 2005 in a new machine wirhout any SQL 2005 beta version!!!
Thanks!!!

Monday, March 19, 2012

Can't see Designer view in Asp.net 2005

Hi All,

I am using VS2005 Trial version, In my website project i can't able to see Designer View of all .aspx files but i can able to view code part. Earlier days i can able to see Designer page but now i can't do why? This problem occurs even new website project also.

Can any one help me?

Thanks in advance

Regards

Nat Raja

This forum is dedicated to SQL/e, not to ASP.Net. Please post to relevant forum or news group instead:

http://forums.asp.net/

http://support.microsoft.com/newsgroups/default.aspx

Closing as off topic.

Can't run under the Eval version of Sql2000

I install the evaluation version of SQL Server 2000.
When I install the evaluation version of Reporting Service, the Installer
require me a SqlServer with Server pack 3a
But the Server pack 3a can't install with evaluation version of SQL Server
2000
How can I do?I guess theres nothing much you can do in this case :(
>--Original Message--
>I install the evaluation version of SQL Server 2000.
>When I install the evaluation version of Reporting
Service, the Installer
>require me a SqlServer with Server pack 3a
>But the Server pack 3a can't install with evaluation
version of SQL Server
>2000
>How can I do?
>
>.
>|||Actually, that's not correct. You can install SQL Server 2000 Service Pack
3a on the Evaluation Edition. See
http://www.microsoft.com/sql/downloads/2000/sp3.asp, a section of which is
copied below:
SQL Server 2000 SP3a:
a.. Improves serviceability for SQL Server 2000 Evaluation Edition. SP3a
enables service pack upgrades for trial software. In the past, service packs
have not been applicable to trial software.
--
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"ad" <ad@.wfes.tcc.edu.tw> wrote in message
news:u1hHCavjEHA.2652@.TK2MSFTNGP15.phx.gbl...
>I install the evaluation version of SQL Server 2000.
> When I install the evaluation version of Reporting Service, the Installer
> require me a SqlServer with Server pack 3a
> But the Server pack 3a can't install with evaluation version of SQL Server
> 2000
> How can I do?
>

Sunday, February 19, 2012

cant load report( error20525)

Hai i am working in vb programs.i used crystal report 8 for repots.
today i upgrade crystal report to version 10,now when i am tking my report through program iam geting the error like "can not load report errorno:20525"
is any solution for this errorMay be a piece of solutio.. let us know..

http://www.bglcorp.com.au/faq.php?view=143

Thursday, February 16, 2012

Cant install SQL Server 2005 on vista..

I'm loading the dev version of sql 2005 on vista ultmate. I'm not seeing the manager tools. I've installed sp2. In the services it says sql express but not sql server. I read the requirments for the dev version and it didn't list vista. Any ideas?

Two issues.

First, you may have SQL Express installed. SQL Express is NOT installed by SQL Developer Edition. You may wish to remove the SQL Express instance.

Second, the client tools are not automatically installed when you install SQL Server. You will need to insert the installation media, and select [Client Tools] to install SSMS.

|||

Thanks Arnie.

I'll take a look. However when I had xp pro setup SQL and SQL Express were both runnning. And I did the client tools and I'll revisit that. I want to make sure there are no issues between Vista Ultmate and SQL 2005. I think I've seen a few problems out there, but none like this particular issue.

|||

I am unable to download the following modules/components with my installation on Vista. As for not seeing the management console, I am using the trial download, so I cannot access any of the management tools on the media you are referring to, as well. Once I finish the installation, I do not see any reference to the SQL Server application in the Program directory, however, a directory has been created for it. I suppose this is because most of the key components are failing to install. In addition, IIS is installed, enabled, and running on my system, but I continually receive the error message during the first stage of installation indicating that IIS has not been detected and needs to be installed and enabled. I have tried stopping the service during installation, and it has not made a difference. I would greatly appreciate any good advice. Thanks.

==================================

BUTTONS:

&Retry
Cancel

TITLE: Microsoft SQL Server 2005 Setup

SQL Server Setup Failed to compile the Managed Object Format (MOF) file C:\Program Files\Microsoft SQL Server\90\Shared\sqlmgmproviderxpsp2up.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=setup.rll&EvtID=29513&EvtType=sqlca%5csqlmofca.cpp%40Do_sqlMofcomp%40Do_sqlMofcomp%40x7349


BUTTONS:

&Retry
Cancel

TITLE: Microsoft SQL Server 2005 Setup

SQL Server Setup Failed to compile the Managed Object Format (MOF) file C:\Program Files\Microsoft SQL Server\90\Shared\sqlmgmproviderxpsp2up.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=setup.rll&EvtID=29513&EvtType=sqlca%5csqlmofca.cpp%40Do_sqlMofcomp%40Do_sqlMofcomp%40x7349


BUTTONS:

&Retry
Cancel

TITLE: Microsoft SQL Server 2005 Setup

SQL Server Setup Failed to compile the Managed Object Format (MOF) file C:\Program Files\Microsoft SQL Server\90\Shared\sqlmgmproviderxpsp2up.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=setup.rll&EvtID=29513&EvtType=sqlca%5csqlmofca.cpp%40Do_sqlMofcomp%40Do_sqlMofcomp%40x7349


BUTTONS:

&Retry
Cancel

Tuesday, February 14, 2012

Cant install SQL Server 05 EE, VB 2005, or Visual Web Dev 2005

hi! i just joined this group today after a colleague told me about it.
anyway, i'm new to SQL and haven't tried installing any version of it.
I do have vb 6.0 though on my pc. My problem is that I can't install
SQL server 05 EE, VB 2005 or VW 2005. I have downloaded all of the
installer from the Microsoft site as well as the dotnetfix which is
supposed to install the .net framework 2.0.

whenever i try to install SQL server EE, it is telling me that it has
found beta components. but i don't have any beta versions of SQL. I
tried uninstalling my Vb 6.0 thinking its causing the error, but same
thing happened.

The next thing I did is I uninstall my .net 2.0 and when i try to
install VB or VW 2005, i got to the step where it is trying to download
the .net framework 2.0 but it is taking so long. Question: is the
dotnetfix.exe which installed .net 2.0, different from the .net 2.0
that the setup.exe of VB2005 will download? if yes, may i know if there
is a direct site where i can manually download and install it so the
VB2005 will just skip that part and go on with the installation?

When i downloaded the exe files for SQL, .net 2.0, VB and VW, i did
select the SAVE option and saved them on my external mini hard drive so
I can install it at home. Does that make any difference? could that
cause the error?

pretty clear that i am a newbie with this stuff and i never thought
that it would be this hassle to install them heheheh any help, in a
detailed way if possible, would highly be appreciated.

thanks so much!

mannypine (mrehpine@.gmail.com) writes:

Quote:

Originally Posted by

hi! i just joined this group today after a colleague told me about it.
anyway, i'm new to SQL and haven't tried installing any version of it.
I do have vb 6.0 though on my pc. My problem is that I can't install
SQL server 05 EE, VB 2005 or VW 2005. I have downloaded all of the
installer from the Microsoft site as well as the dotnetfix which is
supposed to install the .net framework 2.0.


EE = Express Edition or Enterprise Edition?

Quote:

Originally Posted by

The next thing I did is I uninstall my .net 2.0 and when i try to
install VB or VW 2005, i got to the step where it is trying to download
the .net framework 2.0 but it is taking so long. Question: is the
dotnetfix.exe which installed .net 2.0, different from the .net 2.0
that the setup.exe of VB2005 will download? if yes, may i know if there
is a direct site where i can manually download and install it so the
VB2005 will just skip that part and go on with the installation?


I can't speak for Visual Basic, but once installed, in
C:\WINDOWS\Microsoft.NET\Framework you should have a directory v2.0.50727.
If you have a lower number, that is a beta version.

Did you ever install a beta of Visual Studio 2005? Apparently you did
install the beta of something since you get the message. And that would be
a beta of SQL 2005, .Net Fx or VS 2005.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||hi erland. Sorry for that one, i meant Express Edition (EE). Im sure I
did not install any beta versions of any kind for this matter as I just
have reformatted my hard drive cuz i upgraded my motherboard just 3
nights ago. also, I checked my .net 2.0 folder and yes, i do have the
v2.0.50727 directory. btw, im not sure if it will help, i have winxp
sp2.

Erland Sommarskog wrote:

Quote:

Originally Posted by

pine (mrehpine@.gmail.com) writes:

Quote:

Originally Posted by

hi! i just joined this group today after a colleague told me about it.
anyway, i'm new to SQL and haven't tried installing any version of it.
I do have vb 6.0 though on my pc. My problem is that I can't install
SQL server 05 EE, VB 2005 or VW 2005. I have downloaded all of the
installer from the Microsoft site as well as the dotnetfix which is
supposed to install the .net framework 2.0.


>
EE = Express Edition or Enterprise Edition?
>

Quote:

Originally Posted by

The next thing I did is I uninstall my .net 2.0 and when i try to
install VB or VW 2005, i got to the step where it is trying to download
the .net framework 2.0 but it is taking so long. Question: is the
dotnetfix.exe which installed .net 2.0, different from the .net 2.0
that the setup.exe of VB2005 will download? if yes, may i know if there
is a direct site where i can manually download and install it so the
VB2005 will just skip that part and go on with the installation?


>
I can't speak for Visual Basic, but once installed, in
C:\WINDOWS\Microsoft.NET\Framework you should have a directory v2.0.50727.
If you have a lower number, that is a beta version.
>
Did you ever install a beta of Visual Studio 2005? Apparently you did
install the beta of something since you get the message. And that would be
a beta of SQL 2005, .Net Fx or VS 2005.
>
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
>
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

|||pine (mrehpine@.gmail.com) writes:

Quote:

Originally Posted by

hi erland. Sorry for that one, i meant Express Edition (EE). Im sure I
did not install any beta versions of any kind for this matter as I just
have reformatted my hard drive cuz i upgraded my motherboard just 3
nights ago. also, I checked my .net 2.0 folder and yes, i do have the
v2.0.50727 directory. btw, im not sure if it will help, i have winxp
sp2.


Hm, if the install is that fresh, then it the easiest way would be
to start over again, and then start with installing .Net Fx followed
by SQL Server, and then Visual Basic and Visual Web Developer. (But
avoid the other junk you usually cram in. :-)

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Cant install MSDE

I have tried to install MSDE 2000, first the normal version, then the
one for developers using Visual Studio .NET. Each time the installation
appears to complete, but there is no shortcut to start the program and
it's not in the Start/Programs menu. However, if I look for it in "Add
and Remove Programs" it's there.
The directory

C:\Program Files\Microsoft SQL Server\MSSQL\Binn

includes some exe files and I have tried to start them, but nothing
appears to happen. If I start sqlsrvr.exe I get a command prompt window
in which I see things like "Server Process ID is 182", "Logging SQL
server messages in file..." etc, but I have no idea how to go on from
there.
I tried installing the new 2005 Beta version but exactly the same
problem.
Why is this happening? How can I make it work?
Thanks in advance.

Bruno PanettaPS the installation probably doesn't even complete. The installation
window just disappears at some point, without saying that it completed
successfully.

Bruno Panetta wrote:
> I have tried to install MSDE 2000, first the normal version, then the
> one for developers using Visual Studio .NET. Each time the installation
> appears to complete, but there is no shortcut to start the program and
> it's not in the Start/Programs menu. However, if I look for it in "Add
> and Remove Programs" it's there.
> The directory
> C:\Program Files\Microsoft SQL Server\MSSQL\Binn
> includes some exe files and I have tried to start them, but nothing
> appears to happen. If I start sqlsrvr.exe I get a command prompt window
> in which I see things like "Server Process ID is 182", "Logging SQL
> server messages in file..." etc, but I have no idea how to go on from
> there.
> I tried installing the new 2005 Beta version but exactly the same
> problem.
> Why is this happening? How can I make it work?
> Thanks in advance.
> Bruno Panetta|||There is no UI tool for MSDE. MSDE is a database engine that can be
manipulated programmatically via the various APIs, using the OSQL command
line utility or using any of various third party utilities.

SQL 2005 Express (the product that replaces MSDE) does have a UI called
Express Manager but it's a separate download to the database engine product.
http://lab.msdn.microsoft.com/express/sql/

--
David Portas
SQL Server MVP
--|||Thanks but I'm afraid I don't understand since I'm a beginner to SQL
and am trying to install this program in order to learn it.
What should I do once I have installed MSDE 2000 in order to start
creating databases and running SQL queries?
Thank you very much.

Bruno

David Portas wrote:
> There is no UI tool for MSDE. MSDE is a database engine that can be
> manipulated programmatically via the various APIs, using the OSQL command
> line utility or using any of various third party utilities.
> SQL 2005 Express (the product that replaces MSDE) does have a UI called
> Express Manager but it's a separate download to the database engine product.
> http://lab.msdn.microsoft.com/express/sql/
> --
> David Portas
> SQL Server MVP
> --|||http://www.aspfaq.com/show.asp?id=2442

--
David Portas
SQL Server MVP
--

Can't install Express June CTP?!

Hey all, I'm trying to install SQL Server 2005 Express June CTP on a windows 2003 Web Edition Server (With SP1).

I've had an old version of the .NET 2.0 Framework installed, so I downloaded the one mentioned next to the SQL Express download (this one: http://go.microsoft.com/fwlink/?linkid=48448).

Each and every time I run the setup I encounter this error:
The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
There is not even any sort of SQL Server service in the list of services, what should I do?
Regards,

Hendrik BehrensI've also tried the same on Windows XP Professional SP2. I had to uninstall a previous version of .NET 2.0 and VWD Express/VB Express Beta 2 are installed.

I get the same error message?! - The service is not there and the setup just fails with that message.

I've had SQL Express April CTP installed on a windows 2003 Enterprise *trial*, which worked, the update to Junce CTP... right, fails with the same message.
Any proposals?|||Did you look for the log files?

-Euan|||Yes I did, and I found the problem: My windows XP Professional and Windows Server 2003 Web Edition are both german - the setup fails on non-english langauge versions with default settings, this german article describes the problem and how to solve it (for everyone else who encounters this):

http://www.microsoft.com/germany/msdn/vs2005/installvs2005beta.mspx
(basically, remove the tick "Hide advanced configuration Options" and select "Local System" as the service account, instead of "Network Service", which is the default.)

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
>>
>

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...
>

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...
>