Tuesday, March 27, 2012

Can't start SQL 2000 after MS Update

Hi,
I recently installed several Windows Updates and security
patches. Now the SQL Server on my XP Pro development
machine won't start. The only message box that I get
when trying to restart is a message box:
SQL Server does not exist or access denied.
Any clues on how to fix this? I can't seem to find any
other references to this problem.
Regards,
DougSQL Server does not exist or access denied is a generic error message for a
failed connection.
If the MSSQLServer service is not started, then this makes sense.
Try running : Net start MSSQLServer
Check the account you're using to start MSSQLServer.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||I do have the SQLServer icon in the tray, stopped of
course.
I am logged in to the box as Doug with administrator
privledges, SQLServer is set to logon using Local System
account.
The exact message I get when trying to start from
Computer Management console is:
--
A connection could not be established to (local).
Reason: SQL Server does not exist or access denied.
ConnectionOpen (Connect())...
Please verify SQL Server is running and check your SQL
Server registration properties (by right-clicking on the
(local) node) and try again.
--
This had been working fine for months. Nothing that I
know of changed, other than these Windows Updates two or
three days ago when the problem started.
This is my development machine and I'm right in the
middle of a project, so I REALLY appreciate your help
here.
Doug

>--Original Message--
>SQL Server does not exist or access denied is a generic
error message for a
>failed connection.
>If the MSSQLServer service is not started, then this
makes sense.
>Try running : Net start MSSQLServer
>Check the account you're using to start MSSQLServer.
>Thanks,
>Kevin McDonnell
>Microsoft Corporation
>This posting is provided AS IS with no warranties, and
confers no rights.
>
>.
>|||Doug,
The MSSQLServer service needs to be running in order to connect.
Verify that the MSSQLServer service is running / started.
If you continue to have problems connecting, you should open a support case
with SQL Server.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Kevin,
Please don't keep telling me that I need to start before
I can connect. I know that. As I mentioned before, I
CAN'T start or connect. THAT IS the problem.
Something happened, probably during an Update. I don't
know what else could have happened.
HELP. Please! Anyone!!!!
Doug

>--Original Message--
>Doug,
> The MSSQLServer service needs to be running in order
to connect.
>Verify that the MSSQLServer service is running / started.
>If you continue to have problems connecting, you should
open a support case
>with SQL Server.
>Thanks,
>Kevin McDonnell
>Microsoft Corporation
>This posting is provided AS IS with no warranties, and
confers no rights.
>
>.
>|||Doug,
Go into Control Panel to services and try to start the service from
there. If it doesn't start, check the event logs and your SQL Server
error log (the errorlog file in the SQL Server installation path \Log
folder).
-Sue
On Fri, 21 May 2004 13:42:27 -0700,
<anonymous@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Kevin,
>Please don't keep telling me that I need to start before
>I can connect. I know that. As I mentioned before, I
>CAN'T start or connect. THAT IS the problem.
>Something happened, probably during an Update. I don't
>know what else could have happened.
>HELP. Please! Anyone!!!!
>Doug
>
>to connect.
>open a support case
>confers no rights.|||Hi! If you haven't solved your problem yet, try:
restoring your Windows XP to a previous state prior to the installation of
Windows patches. You can do this using System Restore of Windows XP.
Or, you can uninstall the patch(es) you had installed.
Or, try running sqlservr.exe from the command line and see if it generates a
more detailed error message.
HTH. =)
Ricky
<anonymous@.discussions.microsoft.com> wrote in message
news:105bb01c43f74$20bb2b70$a301280a@.phx
.gbl...[vbcol=seagreen]
> Kevin,
> Please don't keep telling me that I need to start before
> I can connect. I know that. As I mentioned before, I
> CAN'T start or connect. THAT IS the problem.
> Something happened, probably during an Update. I don't
> know what else could have happened.
> HELP. Please! Anyone!!!!
> Doug
>
> to connect.
> open a support case
> confers no rights.
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.688 / Virus Database: 449 - Release Date: 5/18/2004

No comments:

Post a Comment