named server failed logon after installing MS04-011 patch

Need help urgently.
I have on win 2000 machine a default SQL Server (local) & a named SQL Server
instance (for separate web machine).
After installing the MS04-011 Patch last nite, the named SQL Server fails to
startup on reboot or manual. The default server on the other hand is runnin
g. But I cannot use the default server as it requires access within the loca
l machine only.
I tried uninstalling the patch, but it still cannot get the SQL server runni
ng again.
HOW CAN I RECOVER THE SQL Server Instance?
Additional info: On logon, following error massage:
"NtUninstall Q8877565\WinSys.cer" not found
before and after the uninstall of the patch.What error do you get when you start it? Is there anything in he SQL Server
errorlog when it fails?
Rand
This posting is provided "as is" with no warranties and confers no rights.|||Thank Rand for responding.
The Error is simply Login Failed. Service Manager shows the instance is stop
ped, while the Default Instance (Local) is started. Click start, and return
Login Failure again.
Any idea what's wrong and how I may recover the Instance?
Almon|||Error listing end at the last restart after patch install. That is, never re
start again.
Almon

named server failed logon after installing MS04-011 patch

Need help urgently
I have on win 2000 machine a default SQL Server (local) & a named SQL Server instance (for separate web machine)
After installing the MS04-011 Patch last nite, the named SQL Server fails to startup on reboot or manual. The default server on the other hand is running. But I cannot use the default server as it requires access within the local machine only
I tried uninstalling the patch, but it still cannot get the SQL server running again.
HOW CAN I RECOVER THE SQL Server Instance'
Additional info: On logon, following error massage
"NtUninstall Q8877565\WinSys.cer" not foun
before and after the uninstall of the patch.What error do you get when you start it? Is there anything in he SQL Server
errorlog when it fails?
Rand
This posting is provided "as is" with no warranties and confers no rights.|||Thank Rand for responding
The Error is simply Login Failed. Service Manager shows the instance is stopped, while the Default Instance (Local) is started. Click start, and return Login Failure again
Any idea what's wrong and how I may recover the Instance
Almo|||Error listing end at the last restart after patch install. That is, never restart again
Almo

named server failed logon after installing MS04-011 patch

Need help urgently.
I have on win 2000 machine a default SQL Server (local) & a named SQL Server instance (for separate web machine).
After installing the MS04-011 Patch last nite, the named SQL Server fails to startup on reboot or manual. The default server on the other hand is running. But I cannot use the default server as it requires access within the local machine only.
I tried uninstalling the patch, but it still cannot get the SQL server running again.
HOW CAN I RECOVER THE SQL Server Instance?
Additional info: On logon, following error massage:
"NtUninstall Q8877565\WinSys.cer" not found
before and after the uninstall of the patch.
What error do you get when you start it? Is there anything in he SQL Server
errorlog when it fails?
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||Thank Rand for responding.
The Error is simply Login Failed. Service Manager shows the instance is stopped, while the Default Instance (Local) is started. Click start, and return Login Failure again.
Any idea what's wrong and how I may recover the Instance?
Almon
|||Error listing end at the last restart after patch install. That is, never restart again.
Almon
sql

Named Pipes problem

We have just installed SQL server on a Win 2003 server. We are getting the
following error message when we try to use it from the 2003 machine.
A connection was successfully established with the server, but then an error
occurred during the login process. (Provider: Named Pipes. Provider error
0 -
No process is on the other end of the Pipe.)
I am a networking guy and I don't know much about SQL (I just set up the
server) The Database guy is asking me for advice.
Next time you ask a question here, mention wich version of SQL youre using.
Check this article.
http://error.codebetter.com/blogs/sahil.malik/archive/2005/11/05/134318.aspx
I drank alot of beer and ended up in the police department database.
Drank more beer and learned SQL in the dark hours.
DELETE FROM offenders WHERE Title=''MrAA'' AND Year=2006;
I love SQL
"pogo" wrote:

> We have just installed SQL server on a Win 2003 server. We are getting the
> following error message when we try to use it from the 2003 machine.
> A connection was successfully established with the server, but then an error
> occurred during the login process. (Provider: Named Pipes. Provider error
> 0 -
> No process is on the other end of the Pipe.)
> I am a networking guy and I don't know much about SQL (I just set up the
> server) The Database guy is asking me for advice.
>
>
|||Sorry, Version is 2005 standard. Thanks for the info I'll try it.
"Hate_orphaned_users" <Hateorphanedusers@.discussions.microsoft.com> wrote in
message news:5460A768-4DF6-4671-BFF2-BE2384F462D9@.microsoft.com...[vbcol=seagreen]
> Next time you ask a question here, mention wich version of SQL youre
> using.
> Check this article.
> http://error.codebetter.com/blogs/sahil.malik/archive/2005/11/05/134318.aspx
>
> --
> I drank alot of beer and ended up in the police department database.
> Drank more beer and learned SQL in the dark hours.
> DELETE FROM offenders WHERE Title=''MrAA'' AND Year=2006;
> I love SQL
>
>
> "pogo" wrote:
|||Books Online also describes this error in the topic: "Troubleshooting: No
Process is on the Other End of the Pipe"
Rick Byham (MSFT)
This posting is provided "AS IS" with no warranties, and confers no rights.
"pogo" <xx@.xx.com> wrote in message
news:uT9RyDZYHHA.408@.TK2MSFTNGP04.phx.gbl...
> Sorry, Version is 2005 standard. Thanks for the info I'll try it.
>
> "Hate_orphaned_users" <Hateorphanedusers@.discussions.microsoft.com> wrote
> in message news:5460A768-4DF6-4671-BFF2-BE2384F462D9@.microsoft.com...
>
sql

Named Pipes problem

We have just installed SQL server on a Win 2003 server. We are getting the
following error message when we try to use it from the 2003 machine.
A connection was successfully established with the server, but then an error
occurred during the login process. (Provider: Named Pipes. Provider error
0 -
No process is on the other end of the Pipe.)
I am a networking guy and I don't know much about SQL (I just set up the
server) The Database guy is asking me for advice.Next time you ask a question here, mention wich version of SQL youre using.
Check this article.
http://error.codebetter.com/blogs/s.../05/134318.aspx
I drank alot of beer and ended up in the police department database.
Drank more beer and learned SQL in the dark hours.
DELETE FROM offenders WHERE Title=''MrAA'' AND Year=2006;
I love SQL
"pogo" wrote:

> We have just installed SQL server on a Win 2003 server. We are getting the
> following error message when we try to use it from the 2003 machine.
> A connection was successfully established with the server, but then an err
or
> occurred during the login process. (Provider: Named Pipes. Provider error
> 0 -
> No process is on the other end of the Pipe.)
> I am a networking guy and I don't know much about SQL (I just set up the
> server) The Database guy is asking me for advice.
>
>|||Sorry, Version is 2005 standard. Thanks for the info I'll try it.
"Hate_orphaned_users" <Hateorphanedusers@.discussions.microsoft.com> wrote in
message news:5460A768-4DF6-4671-BFF2-BE2384F462D9@.microsoft.com...[vbcol=seagreen]
> Next time you ask a question here, mention wich version of SQL youre
> using.
> Check this article.
> [url]http://error.codebetter.com/blogs/sahil.malik/archive/2005/11/05/134318.aspx[/ur
l]
>
> --
> I drank alot of beer and ended up in the police department database.
> Drank more beer and learned SQL in the dark hours.
> DELETE FROM offenders WHERE Title=''MrAA'' AND Year=2006;
> I love SQL
>
>
> "pogo" wrote:
>|||Books Online also describes this error in the topic: "Troubleshooting: No
Process is on the Other End of the Pipe"
--
Rick Byham (MSFT)
This posting is provided "AS IS" with no warranties, and confers no rights.
"pogo" <xx@.xx.com> wrote in message
news:uT9RyDZYHHA.408@.TK2MSFTNGP04.phx.gbl...
> Sorry, Version is 2005 standard. Thanks for the info I'll try it.
>
> "Hate_orphaned_users" <Hateorphanedusers@.discussions.microsoft.com> wrote
> in message news:5460A768-4DF6-4671-BFF2-BE2384F462D9@.microsoft.com...
>

My XP Client doesn't access SQL Server 2000

Hi,

I have a server (WIN 2000 server), is connected with many clients mostly having Win 2000 Professional OS. My application is developed in VB 6.0 and we have MS SQL Server 2000 DB in our server. All the clients with win 2000 professional have no problem with connecting and accessing my SQL Database. But few of my WIN XP clients don’t connect to database thru my application. It gives error as follows.

Runtime error

Login Failed for user ‘(null)’ . Reason: Not associated with a trusted SQL Connection.

Can anyone help me?

Regards

Ahmed Sahib

the server needs an nt login

you are connecting with an expectation to connect to a server in mixed server mode

to do:

1. configure the system to use mixed authentication

right click the server in the enterprise manager>click on properties> security

in the authentication option choose sql server and windows

or

2. change your connection string to use an nt login

|||

What kind of login is used by your application to connect to the database? Are all your clients within the same domain?

Thanks
Laurentiu

|||

Thanks Mr.Joe for your promp reply. My Server has mixed authentication.

I can ping; browse the server from my XP client. So there is no trouble in my network connection settings.

|||

Thanks Mr. Laurentiu Cristofor

Yes, My All clients are in the same domain. Kindly read my previous post.

Thanks

Ahmed Sahib

|||

Are your clients in the same domain as the server? Are you sure that they are attempting to connect using SQL Authentication and not using Windows authentication?

Thanks
Laurentiu