Can't apply Sql 2k server service pack 4 on XP workstation.

After install sql 2000 server - client tools on Win XP workstation, it won't
allow to install sql 2000 server Service Pack 4 (it will quit to desktop
immediately without any error or warning) But we can intall it on win2000
workstation.
- Is it normal that can't apply or not need to apply service pack on winXP
clients?
- How can I check which sql 2000 server service pack applied on clients?
No that wouldn't be considered normal. You do want to apply
the service packs to PC where the client tools are
installed.
You can open Query Analyzer and go to Help, About to
determine the build number of the client tools.
Build numbers and corresponding service packs are listed in
this article:
http://support.microsoft.com/kb/321185
-Sue
On Thu, 14 Jun 2007 09:46:14 +0800, "Pleo"
<pleoel@.hotmail.com> wrote:

>After install sql 2000 server - client tools on Win XP workstation, it won't
>allow to install sql 2000 server Service Pack 4 (it will quit to desktop
>immediately without any error or warning) But we can intall it on win2000
>workstation.
>- Is it normal that can't apply or not need to apply service pack on winXP
>clients?
>- How can I check which sql 2000 server service pack applied on clients?
>
sql

can't access server

Hi, I'm having problem with a workstation connecting to the Server's SQL
Server. The workstation can access the server's hard drive via share and
TCP/IP seems to be working. But the workstation just can't access the
server.
how to tack it down? Thanks.
Hi
What is the error message?
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"js" <js@.someone.com> wrote in message
news:uzlVHEDLFHA.3628@.TK2MSFTNGP10.phx.gbl...
> Hi, I'm having problem with a workstation connecting to the Server's SQL
> Server. The workstation can access the server's hard drive via share and
> TCP/IP seems to be working. But the workstation just can't access the
> server.
> how to tack it down? Thanks.
>
|||Thanks Mike,
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:eD0%23SeHLFHA.2716@.TK2MSFTNGP15.phx.gbl...
> Hi
> What is the error message?
Error: SQL server does not exist or access denied.
It works local, but not trying to connect from another computer.
And I found there are two instance of sql server.
how to check it out? thanks.
sql

can't access server

Hi, I'm having problem with a workstation connecting to the Server's SQL
Server. The workstation can access the server's hard drive via share and
TCP/IP seems to be working. But the workstation just can't access the
server.
how to tack it down? Thanks.Hi
What is the error message?
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"js" <js@.someone.com> wrote in message
news:uzlVHEDLFHA.3628@.TK2MSFTNGP10.phx.gbl...
> Hi, I'm having problem with a workstation connecting to the Server's SQL
> Server. The workstation can access the server's hard drive via share and
> TCP/IP seems to be working. But the workstation just can't access the
> server.
> how to tack it down? Thanks.
>|||Thanks Mike,
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:eD0%23SeHLFHA.2716@.TK2MSFTNGP15.phx.gbl...
> Hi
> What is the error message?
Error: SQL server does not exist or access denied.
It works local, but not trying to connect from another computer.
And I found there are two instance of sql server.
how to check it out? thanks.

Cannot use Windows Authentication to connect to local Sql 2005

Hi,
I am building my workstation again, freshly installing everything.
The OS is Vista Business, 32 bit. I've installed Sql Server 2005
Developer Edition fine and applied service pack 2 successfully. It
seems to run fine, with one exception.
I can't logon using Windows Authentication. I'm a member of the Local
administrators group (as well as a Domain admin), but my domain
\username gets a logon denied error. I can logon just fine with the
sa account, but I prefer Windows Authentication.
Any ideas?
Thanks
AndyAndy (andyj@.med-associates.com) writes:
> I am building my workstation again, freshly installing everything.
> The OS is Vista Business, 32 bit. I've installed Sql Server 2005
> Developer Edition fine and applied service pack 2 successfully. It
> seems to run fine, with one exception.
> I can't logon using Windows Authentication. I'm a member of the Local
> administrators group (as well as a Domain admin), but my domain
> \username gets a logon denied error. I can logon just fine with the
> sa account, but I prefer Windows Authentication.
Did you run the special Vista thing at the end of the SP2 setup? Keep in
mind that on Vista you are normally not admin, only if you request and
confirm. Either start Mgmt Studio with Run As Administrator, or - better -
add your Windows user as a long and grant it CONTROL SERVER.
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|||On Jul 12, 6:30 pm, Erland Sommarskog <esq...@.sommarskog.se> wrote:
> Did you run the special Vista thing at the end of the SP2 setup? Keep in
> mind that on Vista you are normally not admin, only if you request and
> confirm. Either start Mgmt Studio with Run As Administrator, or - better -
> add your Windows user as a long and grant it CONTROL SERVER.
Yes, I ran the provisioning tool. I added my user specifically and
granted connect and control server, that seems to have worked. I
thought I had tried something similar by adding domain admins, but
that didn't seem to work.
Thanks for the tip.
Andy