can't register server

I have SQL Server 2k, sp3a, on a w2k, sp4 box. I'm at home, where I
have no domain. I have two clients, one w2k Pro, sp4, and the other
XP, sp1. I'm using Windows authentication. Neither can register my
server. The error msg is the same for both:
<mysvr> - SQL Server does not exist or access denied.
ConnectionOpen (Connect())
Mind you, the server did show up in the client window, so the client
does seem to know that the server does exist.
Might anyone have an iea as to what I've done wrong? Or haven't done?
Thanks in advance,
Tom
Do you have a firewall running on the box that is hosting SQL Server?
Perhaps it is blocking the connection attempts.
Keith
"Tcs" <tsmith@.eastpointcityNoSpam.org> wrote in message
news:s5ev619fasn9sskr0pdvevu9mfarrldo3l@.4ax.com...
>I have SQL Server 2k, sp3a, on a w2k, sp4 box. I'm at home, where I
> have no domain. I have two clients, one w2k Pro, sp4, and the other
> XP, sp1. I'm using Windows authentication. Neither can register my
> server. The error msg is the same for both:
> <mysvr> - SQL Server does not exist or access denied.
> ConnectionOpen (Connect())
> Mind you, the server did show up in the client window, so the client
> does seem to know that the server does exist.
> Might anyone have an iea as to what I've done wrong? Or haven't done?
> Thanks in advance,
> Tom
>
|||Tom hi,
Did you check your client network utility in your clients. Is any record in
there?
You use DHCP or static IP?
Is your name resolution correct?
Are your windows logins in the SQL Server logins?
Check these first
HTH
Andreas
"Tcs" wrote:

> I have SQL Server 2k, sp3a, on a w2k, sp4 box. I'm at home, where I
> have no domain. I have two clients, one w2k Pro, sp4, and the other
> XP, sp1. I'm using Windows authentication. Neither can register my
> server. The error msg is the same for both:
> <mysvr> - SQL Server does not exist or access denied.
> ConnectionOpen (Connect())
> Mind you, the server did show up in the client window, so the client
> does seem to know that the server does exist.
> Might anyone have an iea as to what I've done wrong? Or haven't done?
> Thanks in advance,
> Tom
>

Can't install RS

I got a windows XP pro with SQL 2000 SP4 installed. I'm trying to install
Reporting services, it tells me that it requires SP3a and wont let me
continue. I can't uninstall SP4. I installed it a while ago and since it
worked OK did not keep the backed up version of the databases pre-SP4.
Anyone knows how I can get Reporting services installed on this machine?
Thanks for any help.
BobWhat is the result of running the following TSQL:
master.dbo.xp_msver 'ProductVersion'
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Bob" <bdufour@.sgiims.com> wrote in message
news:u9dLVMJtFHA.460@.TK2MSFTNGP15.phx.gbl...
>I got a windows XP pro with SQL 2000 SP4 installed. I'm trying to install
>Reporting services, it tells me that it requires SP3a and wont let me
>continue. I can't uninstall SP4. I installed it a while ago and since it
>worked OK did not keep the backed up version of the databases pre-SP4.
> Anyone knows how I can get Reporting services installed on this machine?
> Thanks for any help.
> Bob
>|||Index = 2
Name = ProductVersion
InternalValue = 524288
Character_value = 8.00.194
Bob
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:ul0dddJtFHA.464@.TK2MSFTNGP15.phx.gbl...
> What is the result of running the following TSQL:
> master.dbo.xp_msver 'ProductVersion'
>
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Bob" <bdufour@.sgiims.com> wrote in message
> news:u9dLVMJtFHA.460@.TK2MSFTNGP15.phx.gbl...
>>I got a windows XP pro with SQL 2000 SP4 installed. I'm trying to install
>>Reporting services, it tells me that it requires SP3a and wont let me
>>continue. I can't uninstall SP4. I installed it a while ago and since it
>>worked OK did not keep the backed up version of the databases pre-SP4.
>> Anyone knows how I can get Reporting services installed on this machine?
>> Thanks for any help.
>> Bob
>>
>|||This doesn't appear to be SP4 of SQL server. The results should be
Index Name Internal_Value Character_Value
-- -- -- --
2 ProductVersion 524288 8.00.2039
RS setup looks for a value greater then 8.00.760. It will not allow you to
setup if this value is less. (For some situations we require 8.00.859 or
greater). If you are sure you have SP4 installed then you would first need
to find out why the version number is not correct before you can install RS.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Bob" <bdufour@.sgiims.com> wrote in message
news:OKsG7sJtFHA.4076@.TK2MSFTNGP11.phx.gbl...
> Index = 2
> Name = ProductVersion
> InternalValue = 524288
> Character_value = 8.00.194
> Bob
> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
> news:ul0dddJtFHA.464@.TK2MSFTNGP15.phx.gbl...
>> What is the result of running the following TSQL:
>> master.dbo.xp_msver 'ProductVersion'
>>
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Bob" <bdufour@.sgiims.com> wrote in message
>> news:u9dLVMJtFHA.460@.TK2MSFTNGP15.phx.gbl...
>>I got a windows XP pro with SQL 2000 SP4 installed. I'm trying to install
>>Reporting services, it tells me that it requires SP3a and wont let me
>>continue. I can't uninstall SP4. I installed it a while ago and since it
>>worked OK did not keep the backed up version of the databases pre-SP4.
>> Anyone knows how I can get Reporting services installed on this machine?
>> Thanks for any help.
>> Bob
>>
>>
>|||Thanks.
Since I had nothing in the databases locally yet, I just completely
uninstalled SQL and did a reinstall from scratch up to and including Sp3a.
Now report server install ok and I also managed to install RS SP2.
However when I call the URL localhost/reports I now get
Access to the path "D:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager\bin" is denied.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.
Exception Details: System.UnauthorizedAccessException: Access to the path
"D:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager\bin" is denied.
ASP.NET is not authorized to access the requested resource. Consider
granting access rights to the resource to the ASP.NET request identity.
ASP.NET has a base process identity (typically {MACHINE}\ASPNET on IIS 5 or
Network Service on IIS 6) that is used if the application is not
impersonating. If the application is impersonating via <identity
impersonate="true"/>, the identity will be the anonymous user (typically
IUSR_MACHINENAME) or the authenticated request user.
To grant ASP.NET write access to a file, right-click the file in Explorer,
choose "Properties" and select the Security tab. Click "Add" to add the
appropriate user or group. Highlight the ASP.NET account, and check the
boxes for the desired access.
Source Error:
An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and location of the
exception can be identified using the exception stack trace below.
Stack Trace:
[UnauthorizedAccessException: Access to the path "D:\Program Files\Microsoft
SQL Server\MSSQL\Reporting Services\ReportManager\bin" is denied.]
System.IO.__Error.WinIOError(Int32 errorCode, String str) +393
System.IO.Directory.InternalGetFileDirectoryNames(String fullPath, String
userPath, Boolean file) +229
System.IO.Directory.InternalGetDirectories(String path, String userPath,
String searchPattern) +24
System.IO.Directory.GetDirectories(String path, String searchPattern)
+477
Microsoft.ReportingServices.Diagnostics.Localization.GetInstalledCultures()
Microsoft.ReportingServices.Diagnostics.Localization..cctor()
[TypeInitializationException: The type initializer for
"Microsoft.ReportingServices.Diagnostics.Localization" threw an exception.]
Microsoft.ReportingServices.Diagnostics.Localization.SetCultureFromPriorityList(String[]
localeList) +0
Microsoft.ReportingServices.UI.GlobalApp.Application_BeginRequest(Object
sender, EventArgs e)
System.Web.SyncEventExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute()
+60
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
completedSynchronously) +87
----
Version Information: Microsoft .NET Framework Version:1.1.4322.2032; ASP.NET
Version:1.1.4322.2032
I'm logged in with domain administrator privileges and the domain account
domain.iwam_asp.net has full privileges to this folder. Any idea what I
might need to do now to get this working.
This Win XP pro is part of a small domain. Might this have something to do
with it? The installation went OK this time.
Thanks for any help,
Bob
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:OEutF2JtFHA.908@.tk2msftngp13.phx.gbl...
> This doesn't appear to be SP4 of SQL server. The results should be
> Index Name Internal_Value Character_Value
> -- -- -- --
> 2 ProductVersion 524288 8.00.2039
> RS setup looks for a value greater then 8.00.760. It will not allow you
> to setup if this value is less. (For some situations we require 8.00.859
> or greater). If you are sure you have SP4 installed then you would first
> need to find out why the version number is not correct before you can
> install RS.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Bob" <bdufour@.sgiims.com> wrote in message
> news:OKsG7sJtFHA.4076@.TK2MSFTNGP11.phx.gbl...
>> Index = 2
>> Name = ProductVersion
>> InternalValue = 524288
>> Character_value = 8.00.194
>> Bob
>> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
>> news:ul0dddJtFHA.464@.TK2MSFTNGP15.phx.gbl...
>> What is the result of running the following TSQL:
>> master.dbo.xp_msver 'ProductVersion'
>>
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Bob" <bdufour@.sgiims.com> wrote in message
>> news:u9dLVMJtFHA.460@.TK2MSFTNGP15.phx.gbl...
>>I got a windows XP pro with SQL 2000 SP4 installed. I'm trying to
>>install Reporting services, it tells me that it requires SP3a and wont
>>let me continue. I can't uninstall SP4. I installed it a while ago and
>>since it worked OK did not keep the backed up version of the databases
>>pre-SP4.
>> Anyone knows how I can get Reporting services installed on this
>> machine?
>> Thanks for any help.
>> Bob
>>
>>
>>
>|||Is the ASP.Net worker process running as the domain account or as the local
ASPNET account. If it is the local one does it have permissions to the
folder?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Bob" <bdufour@.sgiims.com> wrote in message
news:uwL9dpKtFHA.2064@.TK2MSFTNGP09.phx.gbl...
> Thanks.
> Since I had nothing in the databases locally yet, I just completely
> uninstalled SQL and did a reinstall from scratch up to and including Sp3a.
> Now report server install ok and I also managed to install RS SP2.
> However when I call the URL localhost/reports I now get
> Access to the path "D:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportManager\bin" is denied.
> Description: An unhandled exception occurred during the execution of the
> current web request. Please review the stack trace for more information
> about the error and where it originated in the code.
> Exception Details: System.UnauthorizedAccessException: Access to the path
> "D:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportManager\bin" is denied.
> ASP.NET is not authorized to access the requested resource. Consider
> granting access rights to the resource to the ASP.NET request identity.
> ASP.NET has a base process identity (typically {MACHINE}\ASPNET on IIS 5
> or Network Service on IIS 6) that is used if the application is not
> impersonating. If the application is impersonating via <identity
> impersonate="true"/>, the identity will be the anonymous user (typically
> IUSR_MACHINENAME) or the authenticated request user.
> To grant ASP.NET write access to a file, right-click the file in Explorer,
> choose "Properties" and select the Security tab. Click "Add" to add the
> appropriate user or group. Highlight the ASP.NET account, and check the
> boxes for the desired access.
> Source Error:
>
> An unhandled exception was generated during the execution of the
> current web request. Information regarding the origin and location of the
> exception can be identified using the exception stack trace below.
>
> Stack Trace:
>
> [UnauthorizedAccessException: Access to the path "D:\Program
> Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportManager\bin" is
> denied.]
> System.IO.__Error.WinIOError(Int32 errorCode, String str) +393
> System.IO.Directory.InternalGetFileDirectoryNames(String fullPath,
> String userPath, Boolean file) +229
> System.IO.Directory.InternalGetDirectories(String path, String userPath,
> String searchPattern) +24
> System.IO.Directory.GetDirectories(String path, String searchPattern)
> +477
> Microsoft.ReportingServices.Diagnostics.Localization.GetInstalledCultures()
> Microsoft.ReportingServices.Diagnostics.Localization..cctor()
> [TypeInitializationException: The type initializer for
> "Microsoft.ReportingServices.Diagnostics.Localization" threw an
> exception.]
> Microsoft.ReportingServices.Diagnostics.Localization.SetCultureFromPriorityList(String[]
> localeList) +0
> Microsoft.ReportingServices.UI.GlobalApp.Application_BeginRequest(Object
> sender, EventArgs e)
> System.Web.SyncEventExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute()
> +60
> System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
> completedSynchronously) +87
>
>
> ----
> Version Information: Microsoft .NET Framework Version:1.1.4322.2032;
> ASP.NET Version:1.1.4322.2032
> I'm logged in with domain administrator privileges and the domain account
> domain.iwam_asp.net has full privileges to this folder. Any idea what I
> might need to do now to get this working.
> This Win XP pro is part of a small domain. Might this have something to do
> with it? The installation went OK this time.
> Thanks for any help,
> Bob
> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
> news:OEutF2JtFHA.908@.tk2msftngp13.phx.gbl...
>> This doesn't appear to be SP4 of SQL server. The results should be
>> Index Name Internal_Value Character_Value
>> -- -- -- --
>> 2 ProductVersion 524288 8.00.2039
>> RS setup looks for a value greater then 8.00.760. It will not allow you
>> to setup if this value is less. (For some situations we require 8.00.859
>> or greater). If you are sure you have SP4 installed then you would first
>> need to find out why the version number is not correct before you can
>> install RS.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Bob" <bdufour@.sgiims.com> wrote in message
>> news:OKsG7sJtFHA.4076@.TK2MSFTNGP11.phx.gbl...
>> Index = 2
>> Name = ProductVersion
>> InternalValue = 524288
>> Character_value = 8.00.194
>> Bob
>> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
>> news:ul0dddJtFHA.464@.TK2MSFTNGP15.phx.gbl...
>> What is the result of running the following TSQL:
>> master.dbo.xp_msver 'ProductVersion'
>>
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Bob" <bdufour@.sgiims.com> wrote in message
>> news:u9dLVMJtFHA.460@.TK2MSFTNGP15.phx.gbl...
>>I got a windows XP pro with SQL 2000 SP4 installed. I'm trying to
>>install Reporting services, it tells me that it requires SP3a and wont
>>let me continue. I can't uninstall SP4. I installed it a while ago and
>>since it worked OK did not keep the backed up version of the databases
>>pre-SP4.
>> Anyone knows how I can get Reporting services installed on this
>> machine?
>> Thanks for any help.
>> Bob
>>
>>
>>
>>
>|||Both the ASPNET machine local account And the ASPNet account for the domain
have been given full rights to that folder. I even went in IIS and enabled
anonymous access and I still get same message.
Thanks again,
Bob
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:eLgesxKtFHA.3500@.TK2MSFTNGP09.phx.gbl...
> Is the ASP.Net worker process running as the domain account or as the
> local ASPNET account. If it is the local one does it have permissions to
> the folder?
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Bob" <bdufour@.sgiims.com> wrote in message
> news:uwL9dpKtFHA.2064@.TK2MSFTNGP09.phx.gbl...
>> Thanks.
>> Since I had nothing in the databases locally yet, I just completely
>> uninstalled SQL and did a reinstall from scratch up to and including
>> Sp3a. Now report server install ok and I also managed to install RS SP2.
>> However when I call the URL localhost/reports I now get
>> Access to the path "D:\Program Files\Microsoft SQL Server\MSSQL\Reporting
>> Services\ReportManager\bin" is denied.
>> Description: An unhandled exception occurred during the execution of the
>> current web request. Please review the stack trace for more information
>> about the error and where it originated in the code.
>> Exception Details: System.UnauthorizedAccessException: Access to the path
>> "D:\Program Files\Microsoft SQL Server\MSSQL\Reporting
>> Services\ReportManager\bin" is denied.
>> ASP.NET is not authorized to access the requested resource. Consider
>> granting access rights to the resource to the ASP.NET request identity.
>> ASP.NET has a base process identity (typically {MACHINE}\ASPNET on IIS 5
>> or Network Service on IIS 6) that is used if the application is not
>> impersonating. If the application is impersonating via <identity
>> impersonate="true"/>, the identity will be the anonymous user (typically
>> IUSR_MACHINENAME) or the authenticated request user.
>> To grant ASP.NET write access to a file, right-click the file in
>> Explorer, choose "Properties" and select the Security tab. Click "Add" to
>> add the appropriate user or group. Highlight the ASP.NET account, and
>> check the boxes for the desired access.
>> Source Error:
>>
>> An unhandled exception was generated during the execution of the
>> current web request. Information regarding the origin and location of the
>> exception can be identified using the exception stack trace below.
>>
>> Stack Trace:
>>
>> [UnauthorizedAccessException: Access to the path "D:\Program
>> Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportManager\bin" is
>> denied.]
>> System.IO.__Error.WinIOError(Int32 errorCode, String str) +393
>> System.IO.Directory.InternalGetFileDirectoryNames(String fullPath,
>> String userPath, Boolean file) +229
>> System.IO.Directory.InternalGetDirectories(String path, String
>> userPath, String searchPattern) +24
>> System.IO.Directory.GetDirectories(String path, String searchPattern)
>> +477
>> Microsoft.ReportingServices.Diagnostics.Localization.GetInstalledCultures()
>> Microsoft.ReportingServices.Diagnostics.Localization..cctor()
>> [TypeInitializationException: The type initializer for
>> "Microsoft.ReportingServices.Diagnostics.Localization" threw an
>> exception.]
>> Microsoft.ReportingServices.Diagnostics.Localization.SetCultureFromPriorityList(String[]
>> localeList) +0
>> Microsoft.ReportingServices.UI.GlobalApp.Application_BeginRequest(Object
>> sender, EventArgs e)
>> System.Web.SyncEventExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute()
>> +60
>> System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
>> completedSynchronously) +87
>>
>>
>> ----
>> Version Information: Microsoft .NET Framework Version:1.1.4322.2032;
>> ASP.NET Version:1.1.4322.2032
>> I'm logged in with domain administrator privileges and the domain account
>> domain.iwam_asp.net has full privileges to this folder. Any idea what I
>> might need to do now to get this working.
>> This Win XP pro is part of a small domain. Might this have something to
>> do with it? The installation went OK this time.
>> Thanks for any help,
>> Bob
>> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
>> news:OEutF2JtFHA.908@.tk2msftngp13.phx.gbl...
>> This doesn't appear to be SP4 of SQL server. The results should be
>> Index Name Internal_Value Character_Value
>> -- -- -- --
>> 2 ProductVersion 524288 8.00.2039
>> RS setup looks for a value greater then 8.00.760. It will not allow you
>> to setup if this value is less. (For some situations we require
>> 8.00.859 or greater). If you are sure you have SP4 installed then you
>> would first need to find out why the version number is not correct
>> before you can install RS.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Bob" <bdufour@.sgiims.com> wrote in message
>> news:OKsG7sJtFHA.4076@.TK2MSFTNGP11.phx.gbl...
>> Index = 2
>> Name = ProductVersion
>> InternalValue = 524288
>> Character_value = 8.00.194
>> Bob
>> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
>> news:ul0dddJtFHA.464@.TK2MSFTNGP15.phx.gbl...
>> What is the result of running the following TSQL:
>> master.dbo.xp_msver 'ProductVersion'
>>
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Bob" <bdufour@.sgiims.com> wrote in message
>> news:u9dLVMJtFHA.460@.TK2MSFTNGP15.phx.gbl...
>>I got a windows XP pro with SQL 2000 SP4 installed. I'm trying to
>>install Reporting services, it tells me that it requires SP3a and wont
>>let me continue. I can't uninstall SP4. I installed it a while ago and
>>since it worked OK did not keep the backed up version of the databases
>>pre-SP4.
>> Anyone knows how I can get Reporting services installed on this
>> machine?
>> Thanks for any help.
>> Bob
>>
>>
>>
>>
>>
>

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